Guides · StatementTidy
Clean financial data for Excel: StatementTidy guides
In short
Bank statements and finance tables copied from the web break spreadsheets in a handful of repeatable ways: numbers stored as text, negatives in brackets, DD/MM dates read as MM/DD, Debit and Credit in two columns, currency symbols glued to amounts, and repeated header rows. Each guide explains one problem, shows a real before/after produced by StatementTidy’s cleaning engine, gives the manual Excel fix and links to a live demo.
Last updated
Get the data out of the page
How to copy a table from a website to Excel (and keep the numbers as numbers)
Four ways to copy a table from a website into Excel or Google Sheets, why numbers paste as text, and how to get clean typed numbers and dates in one click.
Example fixes: Date column converted to ISO YYYY-MM-DD · 2 negative amounts as real negative numbers
How to convert a bank statement to CSV (clean enough to import)
Convert an online bank statement to a clean CSV: one signed Amount column, ISO dates, numbers without symbols, UTF-8 for Arabic. Free Chrome extension.
Example fixes: Debit and Credit merged into one signed Amount · Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 3 negative amounts as real negative numbers
Convert a UAE bank statement to Excel: AED amounts, DD/MM dates and Arabic headers
Convert a UAE or GCC bank statement to Excel: AED, Dhs and د.إ amounts, DD/MM dates, Debit/Credit or مدين/دائن columns, Arabic text. Runs in your browser.
Example fixes: Debit and Credit merged into one signed Amount · Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 2 negative amounts as real negative numbers
Fix the columns
How to fix negative numbers in brackets in Excel
Convert (1,120.35), 4,500.00-, 315.00 DR and other accountant-style negatives into real negative numbers in Excel, with formulas and a one-click fix.
Example fixes: Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 5 negative amounts as real negative numbers
How to convert DD/MM/YYYY dates in Excel without day and month swapping
Stop Excel swapping day and month: convert DD/MM/YYYY text dates to real dates or ISO YYYY-MM-DD, fix mixed columns, and auto-detect the order per column.
Example fixes: Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 3 negative amounts as real negative numbers · 1 total/balance row flagged, left out of sums
How to merge Debit and Credit columns into one Amount column
Combine Debit and Credit (or Withdrawals and Deposits) columns into one signed Amount column in Excel with one formula, or automatically in one click.
Example fixes: Debit and Credit merged into one signed Amount · Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 3 negative amounts as real negative numbers
How to remove currency symbols from numbers (and keep the currency)
Turn AED 1,120.00, € 312,40 and US$ 9.99 into plain numbers with the currency in its own column, in Excel or in one click, without losing the currency.
Example fixes: Date column converted to ISO YYYY-MM-DD (DD/MM detected) · Currency moved to its own column (Amount currency)
How to remove repeated header rows (and blank rows) from a statement
Delete the header row that repeats on every page of a bank statement, plus blank rows, and flag Page total and Balance b/f rows so your sums stay right.
Example fixes: Debit and Credit merged into one signed Amount · Date column converted to ISO YYYY-MM-DD (DD/MM detected) · 4 negative amounts as real negative numbers
How to convert European numbers (1.234,56) in Excel
Convert European numbers like 1.234,56 € and −1.180,00 into numbers Excel understands, with NUMBERVALUE or automatic decimal-comma detection per table.
Example fixes: Date column converted to ISO YYYY-MM-DD (DD/MM detected) · Decimal comma detected (1.234,56 → 1234.56) · 4 negative amounts as real negative numbers
Skip the formulas
StatementTidy is a free Chrome extension that applies every fix above to any table on a web page, inside your browser. See how it works or try the live demo.