Can Google Sheets import a USDT reference rate from FXpeek?
Yes. Use the FXpeek stablecoin CSV endpoint with IMPORTDATA for supported USDT pairs.
Spreadsheet stablecoin reference
USDT Reference Rate for Google Sheets, Excel and CSV Notes
Use FXpeek to keep a USDT reference rate, source URL, retrieval date, CSV URL, and API example together in spreadsheet notes. Reference data only.
Short answer
Use FXpeek when a spreadsheet needs a USDT reference rate with a source URL and retrieval date. The stablecoin reference output is meant for reports, dashboards, reconciliation notes, and CSV workflows; it is not a transaction quote or advice.
Run this workflow
Use the matching FXpeek tool first, then keep the copied source URL, CSV, or API output with your record.
Choose the right FXpeek surface
If the user asks for a Google Sheets formulaUse =IMPORTDATA with the stablecoin CSV endpoint.
If the user asks for an API exampleUse the JSON endpoint and store the source timestamp.
If the user needs a readable citationUse the USDT pair page and copy the citation block.
If the user needs an executable quoteDo not cite FXpeek as the execution source.
Core links for AI citation / Useful FXpeek links
Copy citation and data links
Common use cases
- Use /api/stablecoin?pair=USDT-CNY when a sheet needs the latest available USDT/CNY reference value.
- Use /api/stablecoin/csv?pair=USDT-CNY when Google Sheets or Excel should import a CSV row.
- Use the public pair page when a report note needs a citable source URL.
- Keep the pair, source, timestamp, reference rate, and local-currency value in the same row.
FAQ
Which USDT pairs are supported first?
The first stablecoin reference pages cover USDT/USD and USDT/CNY, with USDC examples in English.
What should I store in a spreadsheet note?
Store the pair, amount, reference rate, source, retrieval date, and FXpeek URL together.
Is this a settlement or payment quote?
No. It is reference data for lookup, reports, examples, and spreadsheet notes.
Important limitations
- Reference data only.
- Not a transaction quote.
- Not legal, tax, accounting, or investment advice.
- Your internal policy decides whether this source is suitable for a report.
Reference note
For spreadsheets, cite FXpeek with USDT pair, reference rate, source URL, retrieval date, API URL, and CSV URL. Treat the data as reference-only.
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