CSV file formats supported for importing transactions

CryptFolio supports the following file formats for importing a list of transactions into an account or address:

Aragon format

CSV Row Description
TXID Transaction reference
TXURL (ignored)
DATE The date of the transaction, including timezone
COINAMOUNT The value and currency of the transaction
FEE The value and currency of the transaction fee, may be empty
BALANCE (ignored)
EXCHANGE (ignored)
MEMO Transaction comment

Bitstamp format

CSV Row Description
Type Deposit, Withdrawal, Market, or Sub Account Transfer
Datetime Date of the transaction (UTC)
Account The title of the account
Value The value and currency of the transaction
Rate The rate used in the Market transaction, may be empty
Fee The value and currency of the transaction fee, may be empty
Sub Type Buy, Sell, or empty

Bittrex format

CSV Row Description
OrderUuid Transaction reference
Exchange The exchange pair (e.g. BTC-REP)
Quantity The quantity bought or sold
Limit The quantity sold or bought
CommissionPaid The transaction fee
Price The rate used in the transaction
Opened (ignored)
Closed Date of the transaction (UTC)

CryptFolio format

CSV Row Description
txn_id (ignored)
portfolio_id (ignored)
account_id (ignored)
wallet (ignored)
txn_at Date of the transaction (UTC)
currency Currency of the transaction
delta Value of the transaction
fee Fee of the transaction, may be empty
reference Transaction reference
comment Optional transaction comment
source (ignored)
updated_at (ignored)
valuation Manual valuation of the transaction, or empty
valuation_currency Currency of the valuation, or empty

This is the same format that CryptFolio can export for any account or address.

Cryptopia format (deposit)

CSV Row Description
# Transaction reference
Currency The currency deposited (e.g. LTC)
Amount The quantity deposited
Status (ignored)
Type (ignored)
Transaction (ignored)
Conf. (ignored)
Timestamp Date of the transaction (UTC)

Cryptopia format (withdrawal)

CSV Row Description
# Transaction reference
Currency The currency withdrawn (e.g. LTC)
Amount The quantity withdrawn
Fee The fee for the withdrawal
Status (ignored)
TransactionId (ignored)
Address (ignored)
Timestamp Date of the transaction (UTC)

Cryptopia format (trade)

CSV Row Description
# Transaction reference
Market The exchange pair (e.g. BTC/LTC)
Type Sell or Buy
Rate (ignored)
Amount The quantity sold, or bought
Total The quantity received, or spent
Fee Fee of the transaction
Timestamp Date of the transaction (UTC)

Kiwi-Coin formats

Kiwi-Coin XBT/NZD statement
CSV Row Description
Balance before
Balance after transaction, ignored
Amount Value of the transaction
Type Deposit, Withdrawal, Market-maker fee, Market-taker fee, or [amount] [currency] bought/sold
Balance after
Balance after transaction, ignored
Transaction Id
Transaction ID
Date/Time Date of the transaction (UTC)

Kiwi-Coin buying statement

CSV Row Description
XBT amount Purchase value of the trade, before fees (BTC)
XBT/NZD price
Currently ignored
XBT income
Purchase value of the trade, after fees (BTC)
XBT fee
Transaction fees (BTC)
NZD spent Sale value of the trade (NZD)
Id Transaction ID
Date/Time Date of the transaction (UTC)

Kiwi-Coin selling statement

CSV Row Description
XBT amount Sale value of the trade (BTC)
XBT/NZD price
Currently ignored
NZD income
Purchase value of the trade, after fees (BTC)
NZD fee
Transaction fees (NZD)
Id Transaction ID
Date/Time Date of the transaction (UTC)

Kraken ledgers format

CSV Row Description
txid (ignored)
refid Transaction reference
time Date of the transaction (UTC)
type Type of transaction (deposit, withdrawal, transfer, trade)
aclass Asset class (currency)
asset The currency of the transaction (e.g. ZUSD, XXBT)
amount Transaction amount, before fees
fee Fee of the transaction, in the currency of the transaction
balance (ignored)

KuCoin formats

CSV Row Description
Coin The exchange pair (e.g. BTC/LTC)
Time Date of the transaction (UTC)
Sell/Buy Sell or Buy
Filled Price The price and currency received, or spent
Amount The quantity and currency sold, or bought
Volume (ignored)

Alternative KuCoin format

CSV Row Description
Time Date of the transaction (UTC)
Coins The exchange pair (e.g. BTC/LTC)
Sell/Buy Sell or Buy
Filled Price The price received, or spent
Coin The currency received, or sent
Amount The quantity sold, or bought
Coin The currency sold, or bought
Volume (ignored)
Coin (ignored)
Fee The fee of the transaction
Coin The currency of the fee

LocalBitcoins.com format

CSV Row Description
id (ignored)
created_at Date of the transaction (UTC)
buyer (ignored)
seller (ignored)
trade_type ONLINE_BUY or ONLINE_SELL
btc_amount (ignored)
btc_traded (ignored)
fee_btc BTC fee for transaction
btc_amount_less_fee (ignored)
btc_final The amount of BTC bought or sold
fiat_amount The amount of fiat currency bought or sold
fiat_fee Fiat fee for transaction
fiat_per_btc (ignored)
currency Fiat currency used for transaction
exchange_rate (ignored)
transaction_released_at (ignored)
online_provider (ignored)
reference Transaction reference

Other formats

If you would like to import a CSV file of a different format, you have two options:

  • Submit a support request with the file format to support
  • Modify your CSV file to match one of the supported formats above
Was this article helpful?
0 out of 0 found this helpful