Bitstamp CSV export format
parser live🔒 CSV conversion runs in your browser — files are not uploaded
This is the format reference for Bitstamp transaction-history CSV — 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: v1 and v2 layouts per BittyTax’s bitstamp.py plus a real file excerpt (hledger issue #627 / rotki #6275) — see research/parser-fixture-validation-2026-10.md.
How to export the file
- Bitstamp → Transactions (account history).
- Export → CSV for your date range.
- Older accounts may get the v1 layout — both parse.
Column reference
v2 transaction history (current)
| Column | What it means |
|---|---|
ID / Order ID | Row and order ids. |
Account | Account label. |
Type | Deposit, Withdrawal, Ripple deposit/payment, Staking reward, Market. |
Subtype | On Market rows: Buy or Sell. |
Datetime | Bitstamp display format "Jan. 28, 2022, 12:13 AM" — assumed UTC. |
Amount / Amount currency | Base-asset quantity and its currency. |
Value / Value currency | Quote total and its currency. |
Rate / Rate currency | Implied price and currency. |
Fee / Fee currency | Fee amount and currency. |
v1 transaction history (older)
Cells pack amount+currency in one string ("1.00000000 ETH").
| Column | What it means |
|---|---|
Type | Deposit, Withdrawal, Ripple deposit/payment, Staking reward, Market. |
Datetime | Same "Jan. 28, 2022, 12:13 AM" display format. |
Account | Account label. |
Amount | Packed "<amount> <currency>" — the base leg. |
Value | Packed "<amount> <currency>" — the quote total. |
Rate | Packed rate cell. |
Fee | Packed fee cell. |
Sub Type | On Market rows: Buy or Sell. |
Format quirks
- Two generations exist: v2 splits every leg into amount + currency columns; v1 packs them ("1.00000000 ETH") — cells are split per-value.
- The Datetime column is a locale display format ("Jan. 28, 2022, 12:13 AM") with month names and a 12-hour clock — parsed month-name-aware and assumed UTC (the export states no zone; flagged once).
- Trades are Type=Market rows carrying Sub type/Subtype Buy or Sell; Amount is the base leg, Value the quote total.
- Ripple-era types (Ripple deposit/payment) map to deposit/withdrawal.
Convert this file (1)
| Convert a Bitstamp CSV to the Koinly format | live |
All Bitstamp CSV converters · Format reference index · All converters