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")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.