Guide · StatementTidy
Convert a UAE bank statement to Excel: AED amounts, DD/MM dates and Arabic headers
Short answer
UAE online banking statements usually show Date, Description, Debit, Credit, Balance, with dates as DD/MM/YYYY and balances like AED 12,067.65. StatementTidy turns that into ISO dates, one signed Amount, numeric balances and a separate currency column, and it understands Arabic headers such as مدين (debit) and دائن (credit). It is not affiliated with any bank and works on any statement shown as a table on a web page.
Last updated · by Mumshad Jawad
Why this happens
Statements from banks in the UAE and the wider GCC trip up spreadsheets in a few specific ways:
- DD/MM/YYYY dates. A laptop set to US English reads
09/09/2026correctly by luck,07/09/2026as 9 July, and leaves25/09/2026as text. - The dirham written four ways:
AED,Dhs,Dhandد.إ. Each one keeps the cell as text. - Arabic or bilingual column headers (
التاريخdate,البيانdescription,مدينdebit,دائنcredit,الرصيدbalance). - Arabic narrations that come out as question marks when a CSV is opened in Excel without a UTF-8 marker.
StatementTidy also recognises the other GCC currencies by code and Arabic symbol: SAR (ر.س), QAR (ر.ق), KWD (د.ك), BHD (د.ب) and OMR (ر.ع).
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.
| التاريخ | البيان | مدين | دائن | الرصيد |
|---|---|---|---|---|
| 02/09/2026 | CARREFOUR MOE DUBAI | 412.35 | AED 12,067.65 | |
| 07/09/2026 | تحويل من أحمد خان | 2,500.00 | AED 14,567.65 | |
| 09/09/2026 | DEWA BILL PAYMENT | (587.20) | AED 13,980.45 | |
| 25/09/2026 | SALARY SEP 2026 WPS | 18,750.00 | AED 32,730.45 |
| التاريخ | البيان | Amount | الرصيد | الرصيد currency |
|---|---|---|---|---|
| 2026-09-02 | CARREFOUR MOE DUBAI | -412.35 | 12067.65 | AED |
| 2026-09-07 | تحويل من أحمد خان | 2500.00 | 14567.65 | AED |
| 2026-09-09 | DEWA BILL PAYMENT | -587.20 | 13980.45 | AED |
| 2026-09-25 | SALARY SEP 2026 WPS | 18750.00 | 32730.45 | AED |
- 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
- Currency moved to its own column (الرصيد currency)
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
Fixing a UAE statement by hand
- Paste the table with Paste Special → Text.
- Convert dates: select the date column, Data → Text to Columns → Next → Next, choose Date: DMY, Finish. Do this before Excel has turned any of them into wrong dates.
- Remove the dirham: Ctrl+H, find
AED(with the space), replace with nothing; repeat forDhsandد.إ. - Add a signed amount:
=N(D2)-N(C2)where C is Debit and D is Credit. - Save as CSV UTF-8 so Arabic survives.
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open the statement in online banking. Use the account activity or e-statement view that shows transactions as a table.
- Click the StatementTidy icon. DD/MM is detected from the dates themselves; you can also force DD/MM/YYYY in the popup.
- Copy or download. Copy for Excel, or download a CSV with the UTF-8 marker so Arabic text opens correctly.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
Does it work with Emirates NBD, FAB, ADCB or Mashreq online banking?
It works on any statement your bank shows as an HTML table or accessible grid in the browser. I have not tested every bank’s portal, and StatementTidy is not affiliated with any bank. If a portal draws the grid with plain <div>s, Pro’s “Select a region” rebuilds it from the layout. Try the live demo first: paste a few rows and see the result.
Will 05/06/2026 be read as 5 June or 6 May?
StatementTidy looks at the whole column: dates like 25/06/2026, which can only be DD/MM, decide the order for the column. If every date in the table is ambiguous it uses the page’s language: US English means MM/DD, everything else DD/MM. You can also force DD/MM/YYYY in the popup.
Are Arabic descriptions kept?
Yes. Arabic and mixed-direction text is kept as shown. Only invisible zero-width and direction-control characters are removed and repeated spaces collapsed, which is also what lets numbers next to Arabic text parse.