For exchanges or blockchains that do not provide any API or CSV export of your transaction history, you can still import your data to Koinly by creating your own custom CSV. This article explains what template formats are available and how to use them.

If your exchange is not supported by Koinly but it does provide a CSV export of your data, it's usually better to modify the file instead of creating it from scratch:

Koinly supports multiple CSV formats to create CSV files with your data - Simple, Trades and Universal template.

You can decide which template to use depending on what transactions you need to import. In short:

Once you decided which format is most suitable for your transactions, you can download them below so you don't have to add all the columns manually. We also share detailed steps on how to import the template to Google Sheets or Excel:

Best for: importing deposits and withdrawals, staking rewards, futures

The below columns are required for the file to be recognized. Column names you use in your file have to match exactly the column names below

Apart from the required columns, you can also use any of the below optional columns in your CSV. These columns don't need to be filled for every row.

Check the examples below to see how the Simple template can be used to import different types of transactions

Best for: Importing spot trades only

The below columns are required for the file to be recognized. Column names you use in your file have to match exactly the column names below

Apart from the required columns, you can also use any of the below optional columns in your CSV. These columns don't need to be filled for every row.

Trades template may seem confusing at first, since the "Amount" and "Total" columns always talk about the same currency, while the direction of the trade (whether base is sold for quote or quote is sold for base) is decided by the "Side" column. The below examples should help with understanding it:
​

Best for: can be used to import any transaction (deposits, spot trades, futures, etc.)

The below columns are required for the file to be recognized. Column names you use in your file have to match exactly the column names below

When using this format, Sent or Received columns should be left empty depending on what transaction you're adding:

Apart from the required columns, you can also use any of the below optional columns in your CSV. These columns don't need to be filled for every row.

To better understand how the Universal template should be used depending on what type of transaction you want to add, check the examples below:

You can add any of the below tags in the "Tags" column of your CSVs to that tag to the transaction upon import. Mind that only one tag can be added to each row.

Learn more what each tag does in

In crypto multiple tokens can have the same symbol. When importing a CSV, Koinly chooses the most popular token with the particular symbol in its database. Sometimes this means that the wrong token gets imported.

You can ensure Koinly imports the correct currency either by using Koinly's internal ID of the token or using its contract address in the CSV instead of just the symbol.

You can add the contract address of the symbol and (optionally) the blockchain's native currency to target a specific token. The format is:

Using WIF as an example, you can put

or

in the "Currency" column to ensure the correct WIF is imported:

If you want to add NFTs, you can use the same notation:

Every currency in Koinly has its own unique ID. You can find it by searching for the token on our Markets page - the ID will be visible in the URL:

Use this ID instead of the symbol, with the format:

Using WIF as an example - instead of WIF, you would put

in the "Currency" column of your file: