Download Central Bank Exchange Rates as Excel or CSV

Month-end closes, customs entries and audit responses all need the same awkward thing: the rate a named institution published on a specific date, in a file you can attach or paste into a spreadsheet. Central banks do publish that rate — but as an HTML table, a PDF bulletin, or an XML feed built for machines, and rarely for the date you actually need.

AllRatesToday serves every source it covers as a downloadable file. This guide covers the three ways to get one, what is inside it, and the full list of 116 central banks and 3 tax authorities you can pull.

Three ways to get the file

No code: the buttons on each coverage page

Every source has a page listing its currently published table — the ECB, the Central Bank of Oman, and so on. Pick the date you need, then use the CSV or Excel button. The publication date appears on the button itself, which matters more than it sounds: a source may not have published today, and the file is dated by what the bank actually printed rather than by when you clicked.

Automating it: one query parameter

Every table endpoint takes a format parameter. The default is JSON; add csv, xlsx or xml and you get a file instead:

# The latest published table as an Excel workbook
curl -L "https://allratestoday.com/api/v1/central-bank/ecb/latest?format=xlsx" \
  -H "Authorization: Bearer YOUR_API_KEY" -o ecb-latest.xlsx

# A specific date as CSV
curl -L "https://allratestoday.com/api/v1/central-bank/ecb/2026-06-30?format=csv" \
  -H "Authorization: Bearer YOUR_API_KEY" -o ecb-2026-06-30.csv

The latest table is available on every plan, including the free tier. Historical dates and time series need a paid plan. An unsupported format value returns a 400 before anything else happens, so a typo fails loudly rather than silently handing you JSON.

What is in the file

One row per currency, with the columns an accountant needs and nothing else: the base and quote currency, the rate, the rate type, and the publication date. Two details worth knowing:

• The CSV carries a UTF-8 byte-order mark, so Excel opens it with currency symbols and non-Latin names intact instead of mangling them.
• The XLSX is a real workbook, not a CSV with a different extension — dates are dates and rates are numbers at full precision, so VLOOKUP and arithmetic work without a cleanup pass.

The rate_type column is the one people overlook. Some institutions print a single reference rate; others print buying and selling rates, a weighted average, or a monthly average. A few publish figures they explicitly label non-official — those arrive typed as informational, and should never be cited as an official rate.

Weekends, holidays and dates that do not exist

No central bank publishes every calendar day, and the weekend is not the same everywhere: Oman and Bangladesh close Friday and Saturday, Israel runs Sunday to Friday, and every country has its own holidays. Ask for a date a source skipped and the file contains the most recent published table instead, dated by that publication. Nothing is interpolated and nothing is invented — which is exactly the behaviour a compliance rule expects, since the rule usually says to use the last published rate.

Every source you can download

116 central banks and 3 national tax authorities. Each name links to its coverage page, where the download buttons live.

FAQ

Can I download central bank exchange rates as an Excel file?

Yes. Every covered source offers its published table as a real Excel workbook (.xlsx) or CSV, from its coverage page or from the API with format=xlsx. Dates arrive as dates and rates at full precision, so the file is ready to reference in a formula without re-typing anything.

Do I need to write code to get the file?

No. Each coverage page has CSV and Excel buttons that download the table currently on screen, with the publication date shown on the button. The API is there if you want to automate it later.

Can I download the rates for a past date?

Yes. Pick the date on the coverage page before downloading, or pass the date to the API. If the source did not publish that day — a weekend, or a public holiday — the file contains the most recent published table instead, and the date in the file tells you which day it is.

Is the download free?

The latest table is free through the API with a free key, using format=csv or format=xlsx. The one-click file downloads on the coverage pages, and any file for a historical date, need a paid plan.

Which rate is in the file — the market rate or the official one?

The official published rate, exactly as the named institution printed it, with its own publication date. It is not a market or mid-market quote, and it does not move after publication. That is what makes it citable in a filing.