Export Methods and File Formats
You can export data from Dune using two primary methods. Each offers different capabilities and file formats:- CSV Downloads: Ideal for static data exports, CSV downloads allow you to save query results in a spreadsheet-compatible format. You can easily open these files in spreadsheet software like Microsoft Excel or Google Sheets.
- API Exports: API exports offer more flexibility and customization options. You can retrieve data in JSON or CSV formats, making it suitable for integration with third-party tools or custom analytics platforms.
Understanding Credit Usage for Data Export
Before you start exporting data from Dune, it’s essential to understand how credits are consumed during the export process. Each export action, whether through CSV downloads or the API, deducts credits from your account based on the amount of data and the method used. For a comprehensive overview of how credits work in Dune, please refer to our detailed guide on the credit system. Teams can also export detailed credit usage data to analyze consumption patterns and optimize their usage.Costs for Exporting Data:
- CSV Exports: Available only to users on Plus and Enterprise plans. Each CSV file download will deduct credits depending on the size and complexity of the data extracted:
- Plus Plan: 5,000 data points per credit
- Enterprise Plan: Custom data points per credit
- API Exports: Available across all plans, but with varying rate limits and credit costs:
- Free Plan: 1,000 data points per credit
- Plus Plan: 5,000 data points per credit
- Enterprise Plan: Custom data points per credit
Rate Limits:
Rate limits determine how frequently you can initiate data exports and at what volume. For detailed information on adjusting your export activities to stay within these limits while managing your credits efficiently, refer to our API rate limits guide.Identify the Dataset for Export
Begin by pinpointing the dataset or query result you wish to export. For instance, given the recent buzz around Friend.Tech, you might want to export the results from this query: https://dune.com/queries/2945343.Export via CSV
- Navigate to the query interface.
- Simply click the “Export to CSV” button.
Export via API
To export data via the API, you’ll need an API key. For details on how to generate and manage your API key, visit the Authentication section of the API reference. When viewing a query on Dune, click the Try API button in the header of the query results panel to see your options for retrieving that data via API. You can copy endpoint URLs and use your API key to start pulling data right away.- Get Latest Query Result — Use the Get Latest Query Result endpoint to retrieve data in JSON or CSV format without needing to trigger a new execution.
- SDKs — Dune offers official SDKs for Python, TypeScript, and Go that handle authentication, polling, and pagination for you. Check out the SDK Quickstart to get up and running quickly.