MEXC CSV export format
parser live🔒 CSV conversion runs in your browser — files are not uploaded
This is the format reference for MEXC CSV export (spot trades / orders / deposits & withdrawals) — where the file comes from, what each column means, and the export quirks that matter. Our parser reads the layout(s) below and converts it in your browser.
Layout evidence: Four profiles per BittyTax’s mexc.py cross-checked with daybook’s MEXC adapter (both built from real exports) — see research/parser-fixture-validation-2026-10.md.
How to export the file
- MEXC → Orders → Spot Orders → Trade History → export CSV (preferred — it carries fee data).
- Order History, Deposits, and Withdrawals are separate exports — each parses on its own.
- Download per date range; times are naive UTC "yyyy-MM-dd HH:mm:ss" unless the header states an offset.
Column reference
Trade History (preferred — has fees)
| Column | What it means |
|---|---|
UID | Optional leading account id — its presence changes the Fee cell shape (see quirks). |
Pairs | Pair code, "BTCUSDT" or "BTC_USDT". |
Time | Fill time; the export offset may ride in the header name ("Time(UTC+08:00)"). |
Side | Buy or Sell. |
Filled Price | Fill price. |
Executed Amount | Base quantity. |
Total | Quote quantity. |
Fee | Fee — packed "0.001BTC" when UID is present, numeric in the quote asset otherwise. |
Role | Maker/taker (optional trailing column). |
Order History (no fee data)
| Column | What it means |
|---|---|
Pairs / Time | Pair and order time. |
Type / Direction | Order kind; Direction is Buy/Sell. |
Average Filled Price | Average execution price. |
Order Price | Limit price. |
Filled Quantity | Executed base quantity. |
Order Quantity / Order Amount | Ordered quantity and whole-order value — Order Amount overstates on partial fills. |
Status | Order state — canceled rows are skipped. |
Deposits
| Column | What it means |
|---|---|
Status | Only "Credited Successfully" rows emit. |
Time | Credit timestamp. |
Crypto / Network | Asset and chain. |
Deposit Amount | Credited quantity. |
TxID / Progress | On-chain txid and progress label. |
Withdrawals
| Column | What it means |
|---|---|
Status | Only "Withdrawal Successful" rows emit. |
Time | Event timestamp. |
Crypto / Network | Asset and chain. |
Request Amount | Gross sent quantity (fee NOT deducted). |
Withdrawal Address / memo | Destination (memo optional). |
TxID | On-chain txid. |
Trading Fee | Fee in the withdrawn asset. |
Settlement Amount / Withdrawal Descriptions | Net settled amount and free text. |
Format quirks
- The Fee column changes shape depending on the file: with a leading UID column it packs amount+asset ("0.001BTC"); without UID it is a bare number in the quote asset — both are handled.
- Order History carries no fee column at all — the quote leg is derived as Filled Quantity × Average Filled Price (stated-data math on the executed part; Order Amount would overstate partial fills).
- Withdrawals report the gross Request Amount with the fee separate — matching the sent-plus-fee model.
- Only success statuses emit rows ("Credited Successfully" / "Withdrawal Successful").
- Futures exports (Futures Trading Pair / Filled Qty (Cont.) columns) are a different position-ledger shape — detected and refused rather than guessed.
Convert this file (1)
| Convert an MEXC CSV to the Koinly format | live |
All MEXC CSV converters · Format reference index · All converters