Scenario long-tail answer module

Exchange-rate CSV for Excel and Google Sheets

Build FXpeek CSV URLs and Google Sheets IMPORTDATA formulas for historical exchange-rate rows, spreadsheet reports, and repeatable checks.

Short answer

Use FXpeek CSV URLs when Excel, Google Sheets, pandas, or BI workflows need historical exchange-rate rows. Copy the CSV URL directly, or wrap it with Google Sheets IMPORTDATA for a refreshable spreadsheet.

Choose the right FXpeek surface

If the user uses Google SheetsUse IMPORTDATA with the FXpeek CSV URL.

If the user uses ExcelOpen or import the CSV URL.

If the user uses pandasRead the CSV URL directly.

If the user needs JSONUse /api/history instead of /api/csv.

Useful FXpeek links

API docs CSV endpoint JSON history endpoint Widget Annual report Site data guide Stablecoin calculator Stablecoin API

Common use cases

A spreadsheet needs dated historical FX rows.
A finance or operations workflow needs repeatable CSV input.
A developer wants a simple URL instead of SDK setup.
A report needs the source URL and reference-data disclaimer.

FAQ

What is the Google Sheets formula for FXpeek CSV?

Use =IMPORTDATA("https://fxpeek.com/api/csv?from=USD&to=EUR&days=365") for supported pairs.

Should spreadsheets use CSV or JSON?

Use CSV for spreadsheets and JSON for apps, charts, or custom scripts.

Can I cite a CSV URL as a source?

Keep both the CSV/API URL and the human-readable FXpeek source page for context.

Are CSV rows official accounting rates?

No, they are reference data and should be used according to your policy.

Important limitations

FXpeek provides historical reference data, not bank quotes, settlement quotes, tax authority rates, accounting authority rates, legal advice, or trading signals.
Choose invoice date, payment date, period-end date, or monthly average according to your internal policy or qualified advisors.
Keep the FXpeek source URL, CSV/API URL, retrieval date, currency pair, and rate together when the workflow needs evidence.

Reference note

Useful internal links: /en/tools/exchange-rate-csv-builder, /en/tools/google-sheets-exchange-rate-formula-builder, /en/api, /api/csv, and /en/answers/google-sheets-exchange-rate-import.

GET https://fxpeek.com/api/history?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/csv?from=CNY&to=TRY&days=365
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY