Whether it's for personal reconciliation, calculating profits and losses, tax filing, or financial audits, exporting your Binance trade history is a very practical need. But when you actually try to do it, you'll find that Binance's export features are scattered across several different locations, making them tricky to find. This article organizes all export methods and paths — just follow along.
If you don't have a Binance account yet, register through sign up here for fee discounts. Download the official app at the download page — some export features can also be completed on the app.
What Data You Might Need to Export
"Trade history" on Binance actually includes many different types of records. Depending on your needs, you may need to export some or all of the following:
- Spot trading records: Detailed records of your cryptocurrency buys and sells
- C2C trading records: Records of buying or selling crypto through fiat channels
- Deposit and withdrawal records: Records of crypto sent to or from Binance
- Futures trading records: If you've traded futures (derivatives)
- Earn income records: Interest and yields from Binance Earn products
- Fee records: Detailed fee breakdowns for each transaction
- Distribution records: Airdrops, referral commissions, event rewards, etc.
Let's go through the different export methods.
Method 1: Manual Export via Web Platform
This is the most basic method, suitable for most users.
Exporting Spot Trading Records
- Log into the Binance website (verify it's the official domain)
- Click your user icon in the upper right, go to "Account"
- In the left menu, find "Orders" then "Spot Orders"
- Select the "Trade History" tab
- Set the time range (maximum 3 months per export)
- Click the "Export" button on the right
- Select CSV format to download
If you need a full year of data, since each export covers only 3 months, you'll need to do it four times: Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec. Set the time range for each and export separately.
Exporting Deposit/Withdrawal Records
- Under "Account," find "Orders" then "Deposit/Withdrawal History"
- Select the "Deposits" or "Withdrawals" tab
- Set the time range
- Click export
Exporting C2C Trading Records
- Under "Account," find "Orders" then "C2C Orders"
- View the historical order list
- Click export
Exporting Futures Trading Records
- Go to the futures trading page
- In the "Orders" section at the bottom, select "Trade History"
- Set the time range and export
Method 2: Using Binance's "Trade Report" Feature
Binance provides a more centralized report generation feature that can produce comprehensive reports including multiple data types at once.
Steps:
- Log into the Binance web platform
- Click the user icon, select "Account"
- Find "Reports" or "Trade Reports" in the left menu
- Click "Generate Report"
- Select the data types to include (you can select all)
- Set the time range
- Submit the generation request
Report generation may take minutes to hours depending on your data volume. Once complete, Binance will notify you by email, and you can return to the reports page to download.
The exported file format is typically CSV. CSV files can be opened and processed with Excel, Google Sheets, or any spreadsheet software.
Method 3: Export via API
For technical users or those with very high trading volumes, Binance's API provides programmatic data access.
Basic approach:
- Create an API Key in your Binance account (under "API Management")
- Use a programming language (like Python) to call Binance's API
- Automatically retrieve and save trading data
Commonly used API endpoints:
/api/v3/myTrades- Get spot trade records/api/v3/allOrders- Get all order records/sapi/v1/capital/deposit/hisrec- Get deposit records/sapi/v1/capital/withdraw/history- Get withdrawal records
The API advantage is automation, more precise data, and no web export time-range limitations. The downside is programming skills are required.
If you don't know how to code, many free Python scripts are available online — search for "Binance export trade history Python" to find ready-to-use code.
Method 4: Using Third-Party Tools
Several dedicated crypto tax and accounting platforms can connect directly to your Binance account and automatically import all trading data to generate reports. Notable ones include:
- CoinTracker
- Koinly
- CoinLedger
- TokenTax
These tools typically connect via a read-only API Key (no withdrawal permissions needed), so security isn't a major concern. Just make sure to grant only read permissions — never enable trading or withdrawal access.
Benefits of third-party tools:
- Automatically consolidate all types of trading data
- Automatic profit/loss calculations
- Generate reports compliant with different countries' tax requirements
- Support merging data from multiple exchanges
Drawbacks:
- Most are paid services
- Data privacy requires trusting these third-party platforms
How to Process Exported Data
After getting your CSV files, you may need to do the following:
Opening and Organizing in Excel
- Open Excel, select "Data" then "From Text/CSV"
- Select your downloaded CSV file
- Confirm the encoding format is UTF-8 (otherwise text may display as garbled characters)
- Sort by time after import
Common Data Field Explanations
- Date/Time: Transaction time (usually UTC — convert to your local timezone)
- Pair: Trading pair (e.g., BTC/USDT)
- Side: Buy or Sell
- Price: Execution price
- Amount/Qty: Executed quantity
- Total: Total trade value
- Fee: Fee charged
- Fee Coin: Currency in which fees were paid
Calculating Profits and Losses
The simplest P&L method:
- Record total cost for each buy (trade amount + fees)
- Record total proceeds for each sell (trade amount - fees)
- Total sell proceeds - Total buy costs = Profit/Loss
If you bought the same coin multiple times, you need to determine which cost calculation method to use:
- FIFO (First In, First Out): First purchased coins are sold first
- LIFO (Last In, First Out): Last purchased coins are sold first
- Average cost method: Use the average cost of all purchases
Different methods may produce different P&L results, with different tax implications.
Common Issues During Export
Export Fails Due to Data Volume
If you trade very frequently, exporting too large a dataset at once may fail. The solution is to slice the time range more finely — export monthly instead of quarterly.
Timezone Issues
Binance exports typically use UTC time. To convert to your local timezone, add or subtract the appropriate hours. In Excel, you can use a formula like =A2+TIME(8,0,0) for batch conversion (example for UTC+8).
Incomplete Data
Some very early trading records may not be exportable via the web platform. Try the API method instead, or contact Binance support to request the data.
CSV File Character Encoding Issues
If the downloaded CSV shows garbled characters when opened, it's usually an encoding issue. Select UTF-8 encoding when importing in Excel to resolve. Alternatively, open the file in a text editor and save with UTF-8 encoding.
Practical Tips
One, develop a regular export habit. Don't wait until year-end to think about exporting data. Export monthly or quarterly — smaller data volumes make it faster, and you can catch and resolve issues early.
Two, back up your data properly. Store exported files securely with multiple backups. This data isn't just your trading records — it may be evidence you'll need for tax authorities in the future.
Three, mind privacy and security. Trading records contain your financial information. Don't share them casually or upload to unreliable platforms.
Four, understand your local tax requirements. Different countries and regions have different crypto tax regulations. Some require reporting all transactions, others only profitable ones. Learn the applicable rules in advance and prepare accordingly.
Five, consider professional tools. If your trading volume is high or spans multiple exchanges, manually organizing data will be extremely time-consuming. Investing in a professional crypto tax tool may be the more efficient choice.
Good trade record management is a habit every serious investor should develop. While it's still fresh in your mind, go ahead and export your trade history to organize it.