Guide · StatementTidy
How to convert a bank statement to CSV (clean enough to import)
Short answer
Open the statement in online banking, click StatementTidy and press CSV. You get one row per transaction with ISO dates (2026-03-05), plain numbers (-1234.50), a signed Amount column instead of Debit/Credit, the currency in its own column, repeated headers and empty rows removed and total rows flagged. The cleaning happens in your browser; the statement is never uploaded.
Last updated · by Mumshad Jawad
Why this happens
“Export to CSV” buttons in online banking are often missing, limited to a few months, or produce files that still need cleaning. Copying the on-screen table is usually the fastest route, but a raw copy is not a usable CSV:
- Amounts carry thousands separators and currency codes (
AED 18,765.50), so importers read them as text. - Money out and money in sit in two columns, while most importers want one signed amount.
- The header repeats on every page of the statement, and there are blank spacer rows and a Total row that would double your sums.
- Excel on Windows opens a CSV without a UTF-8 marker in the legacy code page, so Arabic narrations and accents turn into garbage.
Real example: before and after
The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 05/03/2026 | CARREFOUR MOE DUBAI | 1,234.50 | AED 18,765.50 | |
| 14/03/2026 | SALARY MAR 2026 | 15,000.00 | AED 33,765.50 | |
| Date | Description | Debit | Credit | Balance |
| 16/03/2026 | DEWA BILL 2026-03 | (420.75) | AED 33,344.75 | |
| 21/03/2026 | UBER *TRIP HELP.UBER | 86.00 | AED 33,258.75 | |
| Total | 1,741.25 | 15,000.00 |
| Date | Description | Amount | Balance | Balance currency | Row flag |
|---|---|---|---|---|---|
| 2026-03-05 | CARREFOUR MOE DUBAI | -1234.50 | 18765.50 | AED | |
| 2026-03-14 | SALARY MAR 2026 | 15000.00 | 33765.50 | AED | |
| 2026-03-16 | DEWA BILL 2026-03 | -420.75 | 33344.75 | AED | |
| 2026-03-21 | UBER *TRIP HELP.UBER | -86.00 | 33258.75 | AED | |
| Total | 13258.75 | total |
- 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
- Currency moved to its own column (Balance currency)
- 1 repeated header row removed
- 1 empty row removed
- 1 total/balance row flagged, left out of sums
The CSV file it writes
Date,Description,Amount,Balance,Balance currency,Row flag 2026-03-05,CARREFOUR MOE DUBAI,-1234.50,18765.50,AED, 2026-03-14,SALARY MAR 2026,15000.00,33765.50,AED, 2026-03-16,DEWA BILL 2026-03,-420.75,33344.75,AED, 2026-03-21,UBER *TRIP HELP.UBER,-86.00,33258.75,AED, Total,,13258.75,,,total
Dot decimals, no thousands separators, ISO dates. The download also starts with a UTF-8 marker (on by default) so Excel opens Arabic and accents correctly.
Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.
How to fix it by hand in Excel
What a good bank CSV looks like
- One header row and one row per transaction.
- Dates as
YYYY-MM-DD, which no spreadsheet or importer misreads. - Numbers with a dot decimal and no grouping (
-1234.50), so they import in every locale. - One signed Amount: negative for money out, positive for money in. Many accounting tools that import bank CSVs (for example Xero and QuickBooks Online) accept a single signed amount column.
- Comma or semicolon. Excel in many European locales expects
;as the list separator. StatementTidy’s options let you pick comma, semicolon or tab. - No formula-looking text. A description that starts with
=,+,-or@can run as a formula when the CSV is opened. StatementTidy prefixes such text with an apostrophe.
Doing it by hand in Excel
Paste the table, delete repeated header and blank rows, convert amounts to numbers (see the guides below), add an Amount column with =N(D2)-N(C2), convert dates, then File → Save As → CSV UTF-8 (Comma delimited). Expect 10–20 minutes per statement.
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open your statement as a web page. Sign in to online banking and open the account activity or statement view for the period you need.
- Click the StatementTidy icon. Choose the transactions table. Check the chips: dates detected, Debit + Credit merged, rows removed.
- Choose CSV settings once. In the extension’s options pick comma or semicolon, and keep the UTF-8 marker on if you open CSVs in Excel.
- Download the CSV. Click CSV. The file is saved straight to your Downloads folder.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
Is it safe to use with my bank statement?
The extension only reads the tab you click it on (Chrome’s activeTab permission), cleans the table in its popup and saves the file locally. It sends no page content anywhere. The only network request is a licence check, and only if you enter a Pro key.
Can it convert a PDF bank statement to CSV?
Not in version 1: it reads tables on web pages. Most banks show the same transactions in online banking before offering the PDF, and that web view is what StatementTidy reads.
Why is the Total row still in my CSV?
Subtotal, total and balance rows are flagged in a “Row flag” column rather than silently deleted, so you can check them. Tick “Remove subtotal / balance rows” in the popup to drop them.