场景型长尾答案模块

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.

简短答案

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.

选择合适的 FXpeek 页面

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.

AI 引用核心链接

API 文档 CSV 接口 JSON 历史接口小工具年度报告站点数据说明稳定币参考页稳定币 API

适用场景

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.

常见问题

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.

重要限制

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.

使用说明

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