Some cryptocurrency exchanges do not offer a direct API connection to CoinTracker, nor a custom CSV parser in CoinTracker. Luckily, you can still convert any incompatible transaction history CSV to the generic CoinTracker CSV format and upload it to your account. Here's how:


Sample CSV

Date

Received Quantity

Received Currency

Sent Quantity

Sent Currency

Fee Amount

Fee Currency

Tag

06/14/2017 20:57:35

0.5

BTC

4005.80

USD

0.00001

BTC

08/19/2017 10:05:15

0.3

BTC

3

ETH

08/21/2017 12:00:00

3

ETH

0.0001

ETH

gift

08/30/2017 12:01:30

3

ETH

mined

CSV Requirements

  • The first (header) row must exactly match the example

  • The required date format is MM/DD/YYYY HH:MM:SS (e.g. 09/30/2019 07:19:01)

  • No negative numbers

  • Numbers can be up to eight decimals places

  • Currency symbols must match the ones available when adding manual transactions

  • Send/withdrawal transactions:

    • Should have empty values for the received quantity and received currency

    • Sent Quantity should include fees

  • Receive/deposit transactions:

    • Should have empty values for the sent quantity and sent currency

    • Received Quantity should *NOT* include fees

  • Trade transactions:

    • Should have values for the received quantity, received currency, sent quantity, and sent currency

  • Tag (optional):

    • Send transactions possible values include: gift, lost, donation

    • Receive transactions possible values include: fork, airdrop, mined, payment, staked

    • trades and transfers cannot have tagged values

  • Importing transactions that already exist in your account will result in duplicate transactions

Tips and tricks to convert

Spreadsheet filters:

Filters on spreadsheet software is super helpful for sorting out which transactions are send and receive transactions. For this, we can take advantage of most transaction history formats using simple terms such as Sell, Buy, Deposit, Withdrawal, etc. to filter for the entries that should go in each of the columns in the CoinTracker CSV format.

In Google Sheets (free), you can turn on filters from the menubar under Data > Create a filter:

Data menu on Google Sheets showing the cursor on the

How to create a filter in Google Sheets

You can then filter by type and copy-paste over in a blank spreadsheet with the right headers for the CoinTracker CSV format. In the example below, I've taken a user's Gemini transaction history and sorted for any LINK Sell transactions to add to the Sent quantity column:

A filtered view of sell-side LINKUSD transactions

A filtered view of LINKUSD sell side transactions

Find-and-replace

Use find-and-replace functionality to remove symbols that are not accepted or needed for the CoinTracker format. For example, if a cell with a deposit amount also contains the currency code (i.e. 10 BTC) remove it using find-and-replace.

Did this answer your question?