Bought Pro? Your keys are in your account. Sign in

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/2026 correctly by luck, 07/09/2026 as 9 July, and leaves 25/09/2026 as text.
  • The dirham written four ways: AED, Dhs, Dh and د.إ. 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.

Before As copied from the web page
التاريخالبيانمديندائنالرصيد
02/09/2026CARREFOUR MOE DUBAI412.35 AED 12,067.65
07/09/2026تحويل من أحمد خان 2,500.00AED 14,567.65
09/09/2026DEWA BILL PAYMENT(587.20) AED 13,980.45
25/09/2026SALARY SEP 2026 WPS 18,750.00AED 32,730.45
After Cleaned by StatementTidy
التاريخالبيانAmountالرصيدالرصيد currency
2026-09-02CARREFOUR MOE DUBAI-412.3512067.65AED
2026-09-07تحويل من أحمد خان2500.0014567.65AED
2026-09-09DEWA BILL PAYMENT-587.2013980.45AED
2026-09-25SALARY SEP 2026 WPS18750.0032730.45AED
  • 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

  1. Paste the table with Paste Special → Text.
  2. 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.
  3. Remove the dirham: Ctrl+H, find AED (with the space), replace with nothing; repeat for Dhs and د.إ.
  4. Add a signed amount: =N(D2)-N(C2) where C is Debit and D is Credit.
  5. Save as CSV UTF-8 so Arabic survives.

How to fix it in one click with StatementTidy

  1. Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
  2. Open the statement in online banking. Use the account activity or e-statement view that shows transactions as a table.
  3. Click the StatementTidy icon. DD/MM is detected from the dates themselves; you can also force DD/MM/YYYY in the popup.
  4. 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.