Koinly's csv file importer can automatically detect common file formats from popular exchanges like Binance, so you can use the same steps to upload the files:
1. Go to the Transactions page
2. Click on 'Import from file'
3. Select the wallet you want to import the transactions into (or enter the name for a new wallet).
4. Drag & drop or select the file you want to upload.
5. Hit the Import button.
If the file is recognised by Koinly, it will get imported automatically. If not, you may contact us to add support for it (we do this on a case by case basis, depending on popularity for the format).
Alternatively, you may upload a file in this format:
- The first row must contain these headers:
Date, Sent Amount, Sent Currency, Received Amount, Received Currency
- The following optional headers may also be included:
Fee Amount, Fee Currency, Net Worth Amount, Net Worth Currency, Label, Description, TxHash
- The date should be formatted like this:
- Rows that do not have a Received Amount will be imported as Withdrawals (optional labels: gift, lost)
- Rows that do not have a Sent Amount will be imported as Deposits (optional labels: airdrop, fork, mined, income)
- Rows with a fiat Sent Currency and a crypto Received Currency will be imported as Buys
- Rows with a crypto Sent Currency and a fiat Received Currency will be imported as Sells
- Rows with a crypto Sent Currency and a crypto Received Currency will be imported as Trades
- Duplicate transactions will be ignored if a TxHash is provided. In cases where no txhash is provided we will attempt to ignore duplicates by generating a unique txhash based on the row contents and index.
For a sample file click here.