Spreadsheet distribution

FXpeek Google Sheets custom function

Use FXpeek historical exchange-rate CSV/API data from Google Sheets with IMPORTDATA today and the FXPEEK custom-function workflow.

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 an accounting workbook, analyst sheet, dashboard, or operations model needs repeatable historical FX rows without manually copying rates from a web page.

Workflow

  1. Choose pair and date range
  2. Copy the Google Sheets formula
  3. Paste into your workbook
  4. Register for an API key for heavier usage

FAQ

Can Google Sheets use FXpeek now?

Yes. Use the generated IMPORTDATA formula with FXpeek CSV endpoints for supported historical reference rows.

Is there a custom FXPEEK function?

A Google Apps Script custom-function template is available for controlled internal testing before marketplace distribution.

FXpeek Google Sheets custom function | FXpeek