Google Sheets 工具
Google Sheets exchange rate formula builder
Generate a copy-paste Google Sheets IMPORTDATA formula for FXpeek historical exchange-rate CSV output. The tool also provides the CSV URL, API URL, and source citation so spreadsheet users can keep the data path visible.
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 trading signal.
=IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=EUR&days=365")GOOGLEFINANCE vs IMPORTDATA: choosing the right exchange-rate formula
The built-in GOOGLEFINANCE formula returns the latest spot rate, which is fine for a live quote. Its history window is limited and it exposes no source URL. The FXpeek IMPORTDATA formula imports dated historical reference rows over CSV, which is what invoices, receipts, month-end files, and reviewable reports need.
| Need | Formula | Best for |
|---|---|---|
| Latest spot rate | =GOOGLEFINANCE("CURRENCY:USDGBP") | Live check, no evidence needed |
| Recent dated history | =GOOGLEFINANCE("CURRENCY:USDGBP","price",DATE(2026,1,15)) | Single day inside the recent window |
| Full-year history + source URL | =IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=GBP&days=365") | Invoices, month-end, audit trail |
Use the builder below to generate the IMPORTDATA formula for your pair, and keep the source URL beside the sheet.
Workflow
- Choose a source currency, target currency, date, and history window.
- Copy the IMPORTDATA formula into Google Sheets.
- Keep the FXpeek source URL beside the sheet when the workflow needs evidence.
FAQ
What does the Google Sheets formula import?
It imports FXpeek historical reference-rate CSV rows for the selected currency pair and date window.
Can I keep the source URL with the spreadsheet?
Yes. The builder provides the CSV URL, API URL, and a source citation alongside the IMPORTDATA formula.
Is the imported rate a bank or settlement quote?
No. FXpeek provides reference data for research, reports, and spreadsheet workflows, not transaction or settlement quotes.
What is the exchange rate formula in Google Sheets?
The built-in formula is =GOOGLEFINANCE("CURRENCY:USDGBP"), which returns the latest spot rate. For a dated historical rate you can use =GOOGLEFINANCE("CURRENCY:USDGBP","price",DATE(2026,1,15)) for recent windows, or import FXpeek dated reference rows with =IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=GBP&days=365") when you need older dates, a full year of rows, or a source URL for the audit trail.
Why does GOOGLEFINANCE not work for old exchange-rate dates?
GOOGLEFINANCE history is limited to a recent window and returns no source URL, so an old invoice or receipt date often fails or cannot be verified. FXpeek serves dated reference rows over CSV/JSON with an explicit source date and page URL, which is what reviewable records need.