Numbers in any locale
1,234.56 · 1.234,56 · 1 234,56 · 1’234.56 · 1,23,456.78: every one becomes a real number. The decimal separator is detected per table.
Free Chrome extension · bank statement to Excel
Copying a statement or any table from a website into Excel gives you numbers stored as text, swapped dates and two amount columns. StatementTidy finds every table on the page (bank statements, broker portals, invoices) and exports it with real numbers, ISO dates and one signed Amount column. One click, entirely in your browser.
v1.0.1 · 49 KB · no account · your data never leaves your browser
Before
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 05/03/2024 | CARREFOUR MOE DUBAI | 1,234.50 | AED 18,765.50 | |
| 14/03/2024 | SALARY MAR 2024 | 15,000.00 | AED 33,765.50 | |
| Date | Description | Debit | Credit | Balance |
| 16/03/2024 | DEWA BILL 2024-03 | (420.75) | AED 33,344.75 | |
| 21/03/2024 | UBER *TRIP HELP.UBER | 86.00 | AED 33,258.75 | |
| Total | 1,741.25 | 15,000.00 |
After · StatementTidy
| Date | Description | Amount | Balance | Ccy |
|---|---|---|---|---|
| 2024-03-05 | CARREFOUR MOE DUBAI | -1,234.50 | 18,765.50 | AED |
| 2024-03-14 | SALARY MAR 2024 | 15,000.00 | 33,765.50 | AED |
| 2024-03-16 | DEWA BILL 2024-03 | -420.75 | 33,344.75 | AED |
| 2024-03-21 | UBER *TRIP HELP.UBER | -86.00 | 33,258.75 | AED |
| Total | total | 13,258.75 |
4 narrow permissions
0 page data sent anywhere
60+ currencies recognised
7 languages of month names
How it works
What it fixes
1,234.56 · 1.234,56 · 1 234,56 · 1’234.56 · 1,23,456.78: every one becomes a real number. The decimal separator is detected per table.
(123.45), 123.45-, −123.45, 123.45 DR and CR are read the way accountants mean them.
AED, USD, €, £, ₹, SAR, Dhs and 60+ more move to their own column, so the amount stays a number.
05/03/2024, 5-Mar-24, Mar 5 2024, 5. März 2024 → 2024-03-05. DD/MM vs MM/DD is worked out from the whole column.
Separate Debit and Credit (or Withdrawal / Deposit, Soll / Haben) columns become one signed Amount.
Empty rows and repeated header rows are removed. Subtotal, total and balance-forward rows are flagged so they never double your sums.
Sum, count, average, min, max, money in and money out for any numeric column, before you even open Excel.
Text that looks like a formula is neutralised (CSV injection guard). UTF-8 marker so Arabic and accents open correctly.
Typed numbers and dates, bold frozen header, filters, sensible column widths. Built inside the extension.
Portal draws its table with <div>s? Point at it and StatementTidy rebuilds the rows and columns from the layout.
Your own keyword rules (“carrefour, lulu → Groceries”) add a Category column. Rules stay in your browser.
One click puts every table on the page into one workbook, a sheet each.
Live demo
This runs the extension’s own cleaning code in your browser. Pick a sample, or paste a table copied from any website or spreadsheet. Nothing is uploaded.
Tip: copy a table on any website, click in the box and paste. StatementTidy reads the HTML of what you copied.
Privacy
StatementTidy is built for data you should not upload anywhere. The facts, not a promise to be careful:
Install
The Chrome Web Store listing is on its way. Until then, install the same build with Chrome’s developer mode:
chrome://extensions in Chrome, Edge or Brave.statementtidy folder.SHA-256: 89658a217999d69cc011575ad976fc9cc73608b78e5704b539c973309097d5df
Pricing
Free forever
Pro
$5 / 30 days
Your licence key appears right after you pay and is saved in your mumshadjawad.com account. Paste the key from your account into the extension’s settings (“Enter licence key”).
Guides
Each guide explains one problem, shows a real before/after from StatementTidy’s engine and gives the manual Excel fix too.
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.
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.
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.
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.
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.
Combine Debit and Credit (or Withdrawals and Deposits) columns into one signed Amount column in Excel with one formula, or automatically in one click.
FAQ
Open the statement in your online banking, click the StatementTidy icon and pick the transactions table. Click “Copy for Excel” and paste, or download a CSV (free) or .xlsx (Pro). Dates arrive as YYYY-MM-DD, amounts as real numbers in one signed Amount column.
No. The extension reads the table in the open tab, cleans it in the popup and saves the file on your computer. It has no access to any page until you click its icon (Chrome’s activeTab permission), and it does not send page content anywhere. The only network request it ever makes is the licence check, and only if you enter a Pro key.
Any page with an HTML table or an accessible grid: online banking, card statements, brokers and exchanges, payroll, invoicing and accounting tools, finance news and data sites. For portals that draw tables with plain <div>s, Pro’s region selection rebuilds the grid from the layout.
It works on any statement your bank shows as a table in the browser, and it understands AED, Dhs and د.إ amounts, DD/MM dates and Arabic headers such as مدين and دائن. It is not affiliated with any bank and I have not tested every portal; the live demo shows the result on your own rows first.
It looks at the whole column: dates such as 25/03/2026 that can only be read one way decide the order. If every date is ambiguous it uses the page’s language (US English → MM/DD, otherwise DD/MM), and you can force either order in the popup.
Not in version 1. It cleans tables on web pages. Many banks show the same statement as a web page before offering the PDF.
The cleaning, Copy for Excel and CSV export are free. Pro (.xlsx export, region selection, categoriser, export all tables) costs US$5.00 for 30 days.
The listing is being prepared. Until then you install it with Chrome’s “Load unpacked” button. The download is the same code that will be published, and it uses only four narrow permissions.
Free features never need the internet. A verified Pro licence keeps working offline for several days; the extension re-checks it once a day when online.