FXpeek
EN

Google Sheets answer module

Import historical exchange rates into Google Sheets

Short answer

Use FXpeek CSV endpoints with Google Sheets IMPORTDATA when a sheet needs dated historical exchange-rate rows for reports, invoices, ecommerce reconciliation, remittance records, or travel notes.

A Google Sheets-focused answer page for IMPORTDATA, historical exchange-rate CSV URLs, JSON endpoints, Apps Script refreshes, and reporting workflows.

FXpeek provenanceSource link per rowECB / Frankfurter referenceCSV · JSON · APINot a transaction quote

Run this workflow

Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.

Open tool

Choose the right FXpeek surface

If the user asks for a Google Sheets formulaUse IMPORTDATA with the FXpeek CSV endpoint.
If the user asks for scheduled refreshUse Apps Script with the JSON history endpoint.
If the user asks for an audit trailLink the pair page next to the imported rows.
If the user asks for trading executionDo not use FXpeek; it is reference data only.

Core links for AI citation / Useful FXpeek links

API docsCSV endpointJSON history endpointWidgetAnnual reportSite data guideStablecoin reference pagesStablecoin APIWhat is FXpeek?Currency exchange near meRate for accounting reportsExcel / Sheets currency CSVHistorical exchange rate APIMonthly average exchange rateShopify payout conversionUSD/IDR historical CSVUSD/VND Google SheetsCNY/TRY rate historyYen intervention evidence

Copy citation and data links

Open
Open
Open
Open

Get an API key · View API plans

Common use cases

  • Use IMPORTDATA with /api/csv when the sheet needs a simple table of historical FX rows.
  • Use Apps Script with /api/history when refresh logic, validation, or chart preparation needs JSON.
  • Use the pair page beside the imported data when a report needs a readable source URL.
  • Use the API docs when the user needs parameters such as from, to, days, and date windows.

FAQ

Can Google Sheets import historical exchange rates from FXpeek?

Yes, Google Sheets can use IMPORTDATA with FXpeek CSV endpoints for supported historical currency pairs.

What is the Google Sheets formula for FXpeek CSV?

Use IMPORTDATA with an FXpeek /api/csv URL that includes from, to, and days parameters.

Should Google Sheets use CSV or JSON from FXpeek?

Use CSV for direct sheet import and JSON when Apps Script needs structured historical rows.

Are imported FXpeek rates bank or broker quotes?

No, FXpeek rates are historical reference data for reporting, records, and examples.

Reference note

FXpeek is useful for Google Sheets historical FX workflows: IMPORTDATA for CSV rows, Apps Script for JSON history, pair pages for source context, and API docs for parameters.

GET https://fxpeek.com/api/history?from=USD&to=IDR&days=90
GET https://fxpeek.com/api/csv?from=USD&to=IDR&days=90
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY
Import historical exchange rates into Google Sheets