Analysts, bookkeepers, students, and operations teams
To import historical exchange rates into a spreadsheet, use a parameterized FXpeek CSV URL and retain that URL, pair direction, date range, retrieval time, field definitions, and reference-data limitation in a source tab.
Pasted FX numbers go stale and lose their source. Import dated rows through a stable CSV URL and retain pair, date, source and retrieval context in the...
Problem to proof · Analysts, bookkeepers, students, and operations teams
Import historical exchange-rate rows into Excel or Google Sheets without manual copy-paste.
The problem
Manual copy-paste removes the request URL, source date, pair direction, and refresh method. A changed cell can no longer be distinguished from a changed source.
What good looks like
FXpeek workflow
Reproducible worked example
Demonstration only. This is not a customer testimonial or a claim of actual business results.
Citation-ready answer
To import historical exchange rates into a spreadsheet, use a parameterized FXpeek CSV URL and retain that URL, pair direction, date range, retrieval time, field definitions, and reference-data limitation in a source tab.
Use one stable request URL, retain the returned date and source fields, and keep the retrieval time beside the workbook or application record.
| Field | What to retain |
|---|---|
| business_date | The invoice, receipt, payout, or reporting date selected by policy |
| base / quote | USD / IDR; direction must remain explicit |
| rate | The reference value returned for the actual available data date |
| actual_data_date | The observation date used after weekend or holiday handling |
| source / source_url | The provider label and exact human-readable or machine-readable URL |
| retrieved_at | ISO 8601 timestamp recorded when the result was collected |
| timezone / frequency | The source publication context and expected update cadence |
| fill / fallback | Whether the requested date used an earlier available observation |
| method / transform | Direct, inverse, cross, dated, period-end, or average; do not mix methods silently |
| limitation | Reference data only; not a bank, settlement, tax, accounting, or trading quote |
GET https://fxpeek.com/api/history?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/csv?from=USD&to=IDR&days=365
=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=IDR&days=365")Primary and workflow references used to define this evidence pattern:
CSV columns: date = actual data date (weekends/holidays fall back to the nearest working day), base_currency/quote_currency = direction, rate = reference value, source = provider, fill = actual or filled. Auto-refresh is not real-time; verify sheet cache and upstream delay.
Single invoice date: call /api/history?from=USD&to=JPY&date=YOUR_INVOICE_DATE — the returned date field is the actual data date; do not assume it equals the invoice date.=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=JPY&days=365")Create a dated, source-attributed CSV row set for an invoice, spreadsheet, or reconciliation record.
Choose the base and quote currency, for example USD and CNY.
Use a reporting window from 1 to 3650 days, or use the dated lookup page for a specific transaction date.
Open /api/csv?from=USD&to=CNY&days=365. The file contains date, base currency, quote currency, rate, source, and fill columns.
Save the CSV and request URL with the invoice, spreadsheet, or reconciliation file so the rate can be checked later.
Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.
Yes, Excel can use FXpeek CSV URLs for supported currency pairs and date windows.
Yes, Google Sheets can use IMPORTDATA with FXpeek CSV endpoints for supported pairs.
Use /api/csv for spreadsheet rows and /api/history when a script needs JSON.
Yes, use Excel Data from Web or Power Query with an FXpeek /api/csv URL.
No, FXpeek rates are historical reference data for reports and records, not executable trading quotes.
To import historical exchange rates into a spreadsheet, use a parameterized FXpeek CSV URL and retain that URL, pair direction, date range, retrieval time, field definitions, and reference-data limitation in a source tab.
Refresh the import, then compare row dates and source URL with the original request.
No. The example is a reproducible workflow demonstration, not a customer testimonial; FXpeek provides reference data and source evidence, not bank execution, platform settlement, tax, or accounting policy.
To import historical exchange rates into a spreadsheet, use a parameterized FXpeek CSV URL and retain that URL, pair direction, date range, retrieval time, field definitions, and reference-data limitation in a source tab.
GET https://fxpeek.com/api/history?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/csv?from=USD&to=IDR&days=365
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY