Skip to main content
All CollectionsImporting dataInstructions
How to import a CSV file using a different timezone
How to import a CSV file using a different timezone
Robin Singh avatar
Written by Robin Singh
Updated over 4 months ago

All the transactions should be imported into Koinly using UTC timezone.

If the transactions are not in UTC, you may experience issues with:

  • Unmatched transfers

  • Missing purchase history errors

If timestamps are not in UTC

If the file you exported from your broker/wallet has timestamps in a different timezone, you do not need to edit the file manually. You can offset the timestamps back to UTC upon importing the file to Koinly.

In order to import a file in a different timezone:

  1. Go to file import window as usual (How to import a CSV or Excel file)

  2. After choosing the file and before clicking import, change the Timezone dropdown
    ​

  3. You should choose the timezone the files are in
    So if your file contains timestamps in EST, you should choose EST in the dropdown

I don't know the timezone

The datetime data in the file is ambiguous by itself. You can't tell from the file if 2022-03-13 09:18 is in UTC, EST, GMT, or any other.

If you do not know the timezone of the timestamps, you need to contact the support of your exchange/service and confirm this.
​
Otherwise, you can try the following method:
​
​How to Determine the Timezone of Your Files

  1. Import deposits and withdrawals without changing the timezone (as UTC).

  2. Compare the imported data with deposits/withdrawals from your other API-connected wallets (our API always imports timestamps as UTC, so it's a reliable benchmark).

  3. If they don't merge into transfers, check the hour offset. Delete the wallet and recreate it, this time choosing the hour offset you observed.

  4. Repeat the process until the data aligns correctly.

  5. Once you're confident in the timezone of the deposits/withdrawals, apply the same method to trades:

    • Import trades "as they are."

    • Check if the data makes sense (e.g., trades should occur after deposits or before withdrawals).

    • If the timing is off, delete and recreate the wallet, selecting the appropriate timezone offset.

Did this answer your question?