How to Export Binance Trading History to CSV from the App
- Exportable Data Types
- Exporting via Web Version
- Exporting via Mobile App
- Time Range Limits
- CSV File Structure
- For Tax Reporting
- Integration with Third-Party Tax Tools
- Advantages of API Integration
- Handling Large Data Volumes
- Troubleshooting Export Failures
- Privacy and Security
- Exporting for Multiple Accounts
- Recommended Export Frequency
- FAQ
- Further Reading
Whether for tax reporting, reconciliation, or trading review, you will often need to export your Binance trading history. This guide outlines the steps and key considerations for this process. To access the platform directly, open the Binance Official Website; to download the app, use the Official Binance App; for iPhone installation, refer to the iOS Installation Tutorial.
Exportable Data Types
Binance allows you to export several categories of records:
| Type | Content |
|---|---|
| Spot Orders | All spot market transaction logs |
| Futures Orders | Perpetual and Delivery futures |
| Margin Orders | Margin trading records |
| OTC Trades | OTC spot transactions |
| Fiat Deposits | Bank card / P2P deposits |
| Fiat Withdrawals | Withdrawals to fiat currency |
| Crypto Deposits/Withdrawals | On-chain transfers |
| Fund Flows | Changes across all account balances |
| Referral Rewards | Affiliate commissions |
| Earn Earnings | Staking and savings yields |
Each type is exported separately for easier analysis.
Exporting via Web Version
The web version offers the most comprehensive export options:
- Log in to binance.com.
- Go to the User Center → "Reports" (or Billing/Financial Reports).
- Select "Generate Report."
- Choose the record type (e.g., "Spot Trading").
- Select the time range (maximum 6 months per export).
- Choose the format (CSV or Excel).
- Submit and wait for generation.
- Check your email → Click the link to download.
Generation time ranges from a few seconds to several minutes, depending on the data volume.
Exporting via Mobile App
The process is also available on the mobile app:
- Open the App → Account → Order History / Asset History.
- Tap the "Download" icon at the top of the menu.
- Select the time range and record type.
- Submit.
- The report will be generated within the app or sent to your email.
The app interface may be simplified; some advanced filtering options are only available on the web version.
Time Range Limits
| Record Type | Max Time Range per Export |
|---|---|
| Spot Orders | 6 Months |
| Futures Orders | 6 Months |
| Fund Flows | 1 Year |
| Deposits/Withdrawals | Flexible (as needed) |
| Referral Rewards | 1 Year |
If you need to export spot orders for the past two years, you must perform four separate exports (6 months each).
CSV File Structure
The downloaded CSV typically includes:
- Timestamp (precise to the second)
- Trading Pair (e.g., BTCUSDT)
- Side (Buy / Sell)
- Price
- Executed Amount
- Total Amount
- Fee
- Fee Asset
- Order ID
These files can be opened directly with Excel, Google Sheets, or other spreadsheet software.
For Tax Reporting
Crypto tax requirements vary significantly by region:
| Country/Region | Tax Basis |
|---|---|
| USA | Form 1099 for every transaction |
| Canada | Capital Gains |
| Mainland China | Policy varies (Foreign assets) |
| Hong Kong | Generally no Capital Gains tax |
| Japan | Miscellaneous Income |
Once exported, you can import your CSV into tax tools like Koinly or CoinTracker for automatic calculation.
Integration with Third-Party Tax Tools
Popular tools include:
- Koinly: Supports direct API integration with Binance.
- CoinTracker: Fully supported.
- TaxBit: Fully supported.
API integration is generally more accurate than CSV uploads, as CSVs can occasionally have omissions.
Advantages of API Integration
Connecting your tax software via an API Key offers:
- Automatic synchronization of all trades (no omissions).
- Real-time updates.
- No need for manual monthly exports.
- Enhanced security by setting the API Key to "Read-Only" permissions.
Handling Large Data Volumes
If you trade frequently (dozens of trades per day), a six-month CSV might contain thousands of rows:
- Excel can handle this (up to 1 million rows), but analysis may be slow.
- For high-volume data, using Python (pandas) or R is recommended.
- Alternatively, import the data into a local database for easier querying.
Troubleshooting Export Failures
Common reasons for failure:
- Time range too large: The system will return an error automatically.
- Server timeout: Occurs when data volume is extremely high.
- Email filtered: The download link email may end up in spam.
Solutions:
- Reduce the time range and export in batches.
- Check your spam folder.
- Avoid peak hours (e.g., month-end).
Privacy and Security
Exported CSVs contain highly sensitive information:
- Detailed transaction logs
- Balance changes
- Deposit/Withdrawal addresses
Best practices for storage:
- Use encrypted compression.
- Do not upload unencrypted files to cloud storage.
- Avoid sending these files to insecure email addresses.
Exporting for Multiple Accounts
If you have multiple Binance accounts, you must export from each one individually. Binance does not currently offer a "Consolidated Report" for multiple primary accounts.
Sub-accounts:
- The primary account can download reports for its sub-accounts.
- Path: API Management → Sub-account → Reports.
Recommended Export Frequency
| Purpose | Frequency |
|---|---|
| Daily Reconciliation | Monthly |
| Tax Reporting | Annually |
| Performance Review | Quarterly |
| Legal/Compliance | As needed |
Adding a date prefix to your filenames is a good practice for organization.
FAQ
Q: Is there a fee for exporting data? A: No, this is a free service provided by Binance.
Q: Can I export open (unfilled) orders? A: Yes. There is an "Export" button on the "Open Orders" page.
Q: Which is better, CSV or Excel? A: CSV is more universal for data tools; Excel preserves formatting but may lose compatibility with some third-party software.
Q: Is there an export limit? A: There is a daily limit (around 5–10 times), which is typically more than enough for regular use.