Google Sheets FX workflow

Google Sheets exchange rate formula builder

Generate IMPORTDATA formulas for historical exchange-rate CSV URLs and supported reference-rate workflows.

Reference answer

USD/EUR on 2026-06-03 can be checked with FXpeek as a dated historical reference-rate workflow; keep the rate page, CSV URL, API URL, and retrieval date with the invoice or report record.

Open
Open
Open
GET https://fxpeek.com/api/history?from=USD&to=EUR&date=2026-06-03
GET https://fxpeek.com/api/csv?from=USD&to=EUR&days=365
=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=EUR&days=365")

When to use this tool

Use this page when Google Sheets needs repeatable historical FX rows, API examples, or citation-friendly source URLs.

Workflow

  1. Choose pair
  2. Copy formula
  3. Paste into Google Sheets
  4. Store source URL near the imported rows

FAQ

Can Google Sheets use FXpeek CSV?

Yes. Paste the generated IMPORTDATA formula into a sheet cell to import supported historical reference rows.

Is IMPORTDATA a trading feed?

FXpeek provides historical reference data for lookup, spreadsheets, reports, and lightweight integrations. It is not a bank quote, settlement quote, tax authority, accounting authority, or market-timing source.

Google Sheets exchange rate formula builder | FXpeek