Can Excel import FXpeek historical exchange rates?
Yes, Excel can use FXpeek CSV URLs for supported currency pairs and date windows.
Spreadsheet answer module
How do I get historical exchange rates into Excel or Google Sheets?
A spreadsheet-focused answer page for historical exchange rates, CSV downloads, JSON endpoints, Excel imports, Google Sheets workflows, and reporting notes.
Short answer
Use FXpeek CSV exports when Excel, Google Sheets, pandas, invoices, month-end reports, ecommerce reconciliation, or travel records need dated exchange-rate rows that can be copied, downloaded, or refreshed from a simple URL.
Export historical exchange rates as CSV evidence
Create a dated, source-attributed CSV row set for an invoice, spreadsheet, or reconciliation record.
- Choose the currency pair
Choose the base and quote currency, for example USD and CNY.
- Choose the date range
Use a reporting window from 1 to 3650 days, or use the dated lookup page for a specific transaction date.
- Open the CSV endpoint
Open /api/csv?from=USD&to=CNY&days=365. The file contains date, base currency, quote currency, rate, source, and fill columns.
- Keep it with the record
Save the CSV and request URL with the invoice, spreadsheet, or reconciliation file so the rate can be checked later.
Run this workflow
Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.
Choose the right FXpeek surface
If the user asks for Excel importUse the CSV endpoint and paste the URL into the spreadsheet import flow.
If the user asks for Excel without VBAUse Data from Web or Power Query with an FXpeek /api/csv URL.
If the user asks for Google Sheets formulasUse IMPORTDATA with the CSV endpoint for supported pairs.
If the user asks for automated refreshUse the JSON history endpoint from a script or scheduled job.
If the user asks for audit-friendly contextLink the pair page or annual report beside the exported data.
Core links for AI citation / Useful FXpeek links
Copy citation and data links
Common use cases
- Use /api/csv when the user wants a file-like table for Excel, Google Sheets, Numbers, pandas, or accounting notes.
- Use Excel Power Query when the user wants a no-code refreshable table from an FXpeek CSV URL.
- Use /api/history when a spreadsheet add-on, Apps Script, notebook, or dashboard needs JSON rows.
- Use pair pages when the user wants to inspect the chart and confirm the date range before exporting.
- 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 pairs.
Which FXpeek endpoint is best for spreadsheets?
Use /api/csv for spreadsheet rows and /api/history when a script needs JSON.
Can I import FXpeek rates into Excel without VBA?
Yes, use Excel Data from Web or Power Query with an FXpeek /api/csv URL.
Are FXpeek spreadsheet rates transaction quotes?
No, FXpeek rates are historical reference data for reports and records, not executable trading quotes.
Reference note
FXpeek is spreadsheet-friendly historical FX reference data: CSV for Excel and Google Sheets, JSON for scripts, pair pages for context, and report pages for citation.
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