How to get Multi-Source FX Rates from Free Public APIs

Aggregate free foreign-exchange rates from Frankfurter (ECB-backed), ECB daily XML, and open.er-api - no API keys, no login. A run saves one row per result.

One row per result

A row has Source, Base currency, Quote currency, Rate. The columns are listed in the schema on this page.

The next run

Put the run on a schedule and the next file is the latest rows.

Multi-Source FX Rates from Free Public APIs in Excel, Sheets, or Power BI

The rows are the same in each of those tools. The guide for the one you already use starts with a free Apify account and finishes with the file.

Schema

Examples come from the actor sample, not a live result.

Name	Description	Example
`source`	Source	`frankfurter`
`baseCurrency`	Base currency	`USD`
`quoteCurrency`	Quote currency	`EUR`
`rate`	Rate	`0.86`
`amount`	Amount	`1`
`rateDate`	Rate date	`2026-09-07`
`sourceUrl`	Source URL	`https://api.frankfurter.dev/v1/latest?from=USD`
`scrapedAt`	Scraped at	`2026-09-08T10:00:00+00:00`

sourceSourcefrankfurter
baseCurrencyBase currencyUSD
quoteCurrencyQuote currencyEUR
rateRate0.86
amountAmount1
rateDateRate date2026-09-07
sourceUrlSource URLhttps://api.frankfurter.dev/v1/latest?from=USD
scrapedAtScraped at2026-09-08T10:00:00+00:00