Binance trade history CSV, without the spreadsheet cleanup
Binance gives you a detailed record of every fill, but the export is not a ready-made trade journal. This guide shows which file to download, what each column means, and how to turn it into closed trades and R-multiple stats.
How to export Binance trade history
Open the right order history
Log in to Binance on desktop. For spot, open Orders → Spot Order → Trade History. For USDⓈ-M or COIN-M futures, open Futures → Order → Trade History.
Choose the date range
Select the period you want to review. Some Binance exports are limited to a shorter window; if your range is too wide, export one month at a time.
Export the CSV
Click Export and choose CSV. Binance may ask for email or 2FA confirmation. Keep the downloaded file unchanged so the headers stay intact.
Check spot vs futures columns
Spot exports use Date(UTC), Pair, Side, Price, Executed, Amount and Fee. Futures exports use Time, Symbol, Side, Price, Qty, Realized Profit and Fee. They are different formats; import them separately.
CSV columns you need to understand
Exact headers vary by export type and region. These are the columns that change the import result.
| Column | What it means |
|---|---|
| Date(UTC) | Fill time in UTC. The date can differ from your local calendar day. |
| Pair | Spot market, for example BTCUSDT. |
| Side | Buy or Sell. A spot Sell normally closes an existing long, not opens a short. |
| Price | Fill price, not the order price. |
| Executed | Base-asset quantity filled. Use this as quantity, not Amount. |
| Amount | Quote-asset turnover (price × executed). Do not map it as quantity. |
| Fee | Trading fee. Check whether it was charged in USDT, BNB or another asset. |
Common Binance CSV mistakes
- Mapping Amount as quantity inflates or deflates P&L. Use Executed (spot) or Qty (futures).
- BNB fee deductions are not USDT; convert them before importing if you want an exact net P&L.
- Futures exports often contain realized P&L per fill, but no single entry/exit row. Pair the fills instead of importing them as closed trades.
- Partial fills produce multiple rows for the same order. A fills importer should keep them, not collapse them by order ID.
How SureGain handles Binance files
If your file is one row per closed trade, use the closed-trade CSV importer. If it is a Binance fill export, use Pair exchange fills: SureGain groups by symbol and position side, sorts by time, and pairs opens and closes FIFO.
The Binance adapter prefers Executed/Qty over Amount, detects Date(UTC) or Time, and keeps fees separate. Everything runs in your browser; the CSV is not uploaded.
FAQ
Can I import a Binance spot trade history CSV directly?+
Yes. Binance spot trade history is a fills file, so use the fills pairing panel. It pairs buys and sells into closed trades and shows open quantity that was not imported.
Does SureGain support Binance futures CSV?+
Yes. Futures trade history with Time, Symbol, Side, Price, Qty and Fee is detected automatically. If your export uses contracts instead of base quantity, set the contract multiplier before pairing.
Why is my Binance P&L different from the exchange?+
The usual reasons are BNB fees, funding payments, contract size, or importing Amount as quantity. Check those four before comparing totals.
Is my Binance CSV uploaded?+
No. The journal parses and stores trades in your browser's IndexedDB. Only the waitlist email is stored on the server.
Other exchange guides
SureGain is a trade journaling tool, not an exchange or financial adviser. CSV exports can be incomplete; verify imported numbers before making decisions.