This guide will show you how to export data using the Coin Metrics API.
HTTP API
On a web browser, you can append any valid API request URL with &format=csv or &format=json to download the data in CSV or JSON format, respectively.For example:
Sheets re-runs IMPORTDATA periodically, so the cell keeps pulling fresh data without you touching it.
Building a reusable sheet
Editing that URL by hand gets tedious as soon as you want a different asset or date range. Put each query parameter in its own cell instead and assemble the URL with a formula, which turns the sheet into a small control panel you can point anywhere.
Open a new Google Sheet and enter the parameter names in column A with their values in column B, starting at row 1:
Cell
Parameter
Value
B1
api_key
<your_key>
B2
assets
btc
B3
metrics
PriceUSD
B4
page_size
1000
B5
start_time
2025-01-01T00:00:00Z
B6
end_time
2025-01-31T00:00:00Z
B7
paging_from
end
B8
frequency
1d
In another cell, build the query URL from those values:
The first time you do this, Sheets asks you to allow the connection to an external URL:
Once you allow it, the CSV response fills the cells below:
Your API key sits in a cell and in the assembled URL, so anyone you share the sheet with can read it. Keep these sheets private, or use a key scoped to what the sheet needs.
Python API Client
In the Python API client, you can use the export_to_csv and export_to_json methods to export data to a CSV or JSON file.For example:
As of version 2025.9.17.17, exporting to JSON files using the Python API Client is as fast using a curl command. See these release notes for more on benchmarking.Exporting data can be sped up significantly by splitting the API calls to parallel threads.
Note that the download speed is evenly divided between all active connections of a single api key. 10 parallel connections are allowed. Excessing connections will be queued (no data transfer will happen).
Assistant
Responses are generated using AI and may contain mistakes.