CBUAE Exchange Rate History: Download Central Bank of the UAE Dirham Rates 2019 to 2026 as CSV, Excel or API

If you need the Central Bank of the UAE (CBUAE) rate for one past date, the bank's website will give it to you. If you need a year of daily rates for a revaluation model, a corporate tax working paper or a pricing analysis, you are downloading and stitching monthly files. This guide points to the series already assembled, and shows how to use it from a spreadsheet, a script or an API call.

What the Central Bank itself provides

The CBUAE exchange rates page shows the current table of more than 70 currencies against the dirham, and a historical section offers download files by month, starting from January 2018. The bank states the rates are updated Monday to Friday, are based on FX rates prevailing at 6pm UAE time, and are mid rates. There is no API on the page: the machine-readable output is the monthly file.

The assembled series: one CSV per year

The central-bank-exchange-rates repository holds the official CBUAE table under data/cbuae/: latest.json for the newest table, daily/ for one JSON file per date, and history/ with one CSV per year from 2019 to 2026.

https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/cbuae/history/2025.csv

date,base,quote,type,value
2025-01-01,ARS,AED,reference,0.003562
2025-01-01,AUD,AED,reference,2.272727
...

Each row is dirhams per one unit of the base currency on that date. The series runs from 2 January 2019 and holds about 144,000 rows. Files update each business day after the bank publishes. Licence: CC BY-NC 4.0, so free for research, study and internal non-commercial use with attribution; commercial systems use the API below.

Excel

Data > Get Data > From Web, paste the raw URL above, and Power Query loads it as a table. Filter base to the currencies you need and pivot on date. Refresh re-reads the file, so the current year's sheet stays up to date.

Google Sheets

=QUERY(IMPORTDATA("https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/cbuae/history/2026.csv"),
       "select Col1, Col5 where Col2 = 'EUR'", 1)

That returns the date and the EUR rate for every business day of 2026. Wrap it in VLOOKUP to pick the rate for an invoice date.

Python

import pandas as pd
base = "https://raw.githubusercontent.com/AllRates-Today/central-bank-exchange-rates/main/data/cbuae/history/{}.csv"
df = pd.concat(pd.read_csv(base.format(y), parse_dates=["date"]) for y in range(2019, 2027))
wide = df.pivot(index="date", columns="base", values="value")

print(wide.loc["2025-12-31", ["USD", "EUR", "GBP", "INR"]])
# USD 3.672500, EUR 4.310952, GBP 4.938811, INR 0.040866
print(wide["EUR"].resample("ME").mean().tail(3))   # monthly averages
print(wide["EUR"].asof("2026-11-08"))              # Sunday -> Friday's table, 4.091466

asof is the important call for finance work: for a weekend or holiday date it returns the last official table before it, which is the fallback every invoice and closing process needs.

One date, as an API call

Today's table:

curl "https://allratestoday.com/api/open/central-bank/cbuae"

A past date or a range, with a key:

curl -H "Authorization: Bearer YOUR_KEY" \
  "https://allratestoday.com/api/v1/central-bank/cbuae/2025-12-31"

curl -H "Authorization: Bearer YOUR_KEY" \
  "https://allratestoday.com/api/v1/central-bank/cbuae/history?symbol=EUR&from=2026-01-01&to=2026-11-09"

The dated response includes requested_date, rate_date and published_on_requested_date, so the weekend fallback is explicit in the data. Add ?format=csv, xml or xlsx to any table endpoint. Dated tables and history are on paid plans; a history request is counted as one call per currency per month of data.

Reference points for checking your load

If your import shows USD at anything other than 3.6725, the column mapping is wrong: the dirham has been pegged at that rate since 1997.

What people use the history for

• VAT: the rate at the date of supply for foreign-currency invoices. See the Article 69 guide.
• Corporate tax: spot, monthly-average and annual-average conversion under FTA Decision No. 13 of 2023.
• Closing: period-end revaluation. See the 31 December 2025 closing rates.
• Audit: recomputing a sample of converted invoices against the official table.

FAQ

Where can I download historical Central Bank of the UAE exchange rates?

The Central Bank of the UAE website offers monthly download files from January 2018. The same official daily tables are available as one CSV per year from 2019 in the AllRates-Today central-bank-exchange-rates repository, and by date through the AllRatesToday API.

Does the Central Bank of the UAE have an exchange rate API?

Its exchange rates page offers a web table and monthly files but no API. AllRatesToday serves the same official table as JSON, CSV, XML and Excel.

How far back does the history go?

The assembled series starts on 2 January 2019 and covers every business day since, for more than 70 currencies against the dirham.

Are rates published on weekends?

No. The Central Bank of the UAE publishes Monday to Friday. For a Saturday or Sunday the last official table is Friday's.

Can I use the CSV files commercially?

The files are licensed CC BY-NC 4.0, which covers research and internal non-commercial use with attribution. Commercial products and production systems should use the API on a paid plan.