場景型長尾答案模組

Exchange-rate CSV for Excel and Google Sheets

簡短答案

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.

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

直接開始這個工作流

先使用對應的 FXpeek 工具，再把複製的來源 URL、CSV 或 API 輸出和記錄一起儲存。

開啟工具

選擇合適的 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 附近貨幣兌換會計報表用匯率 Excel 與 Google Sheets 匯率 CSV Shopify 提現換算 USD/IDR 歷史 CSV USD/VND 表格公式 CNY/TRY 匯率歷史日元干預證據

複製引用和資料連結

開啟

申請 API Key · 檢視 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=90") 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=90
GET https://fxpeek.com/api/csv?from=CNY&to=TRY&days=90
GET https://fxpeek.com/api/stablecoin?pair=USDT-CNY