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 decimal 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
:

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 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.