# KuCoin (.CSV / XLSX) import, does not work **URL:** \ **Category:** Koinly Support\ **Created:** [May 13, 2021, 11:42am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761 "2021-05-13T11:42:11Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![BSOv](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/bsov/32/2961_2.png) [@BSOv](https://discuss.koinly.io/u/BSOv)\ **Post date:** [May 13, 2021, 11:42am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/1 "2021-05-13T11:42:11Z")
**Describe the problem:** API import does not work properly, so I got a complete .XLSX Trade report from KuCoin. If i try to upload it on Koinly, it says “This file could not be imported automatically, follow the tips below to resolve this.” **Which exchange/wallet is this regarding?** KuCoin **How did you import data into this wallet?** KuCoin provided me with a full Report xlsx File **What have you tried to fix this so far?** Tried to redownload, tried to rearrange the file myself. Did not work. For my trade report the collums are: user\_id trade\_id symbol order\_type deal\_price amount direction funds fee\_currency fee created\_at created\_date For the payment report the collums are: id user\_id coin\_type type address wallet\_tx\_id vol fee created\_at created\_date I just paid for a plan, this does not seem to work. (I did not trade KuCoin Futures) Anyone has a clue how to reformat these Reports for Koinly to read them? ---
**Author:** ![Anakin\_Koinly](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/anakin_koinly/32/2943_2.png) [@Anakin\_Koinly](https://discuss.koinly.io/u/Anakin_Koinly)\ **Post date:** [May 14, 2021, 10:15am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/2 "2021-05-14T10:15:34Z")
Hello, Sorry for the inconvenience. I’ll take a look at the KuCoin data import parameters and get back to you. Regards, Anakin ---
**Author:** ![rdmailuk](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/rdmailuk/32/3832_2.png) [@rdmailuk](https://discuss.koinly.io/u/rdmailuk)\ **Post date:** [July 19, 2021, 9:25pm UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/8 "2021-07-19T21:25:39Z")
I have this same issue, how to i DM you my file ? ---
**Author:** ![BSOv](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/bsov/32/2961_2.png) [@BSOv](https://discuss.koinly.io/u/BSOv)\ **Post date:** [May 14, 2021, 11:18am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/3 "2021-05-14T11:18:37Z")
Thank you, another thing i noticed (besides Spot trades via API) is that the .xlsx report i imported has a wrong timestamp ☹ If tech support needs the report, I can happily provide it. I did add a huge amount of trades now by myself manually. ---
**Author:** ![Anakin\_Koinly](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/anakin_koinly/32/2943_2.png) [@Anakin\_Koinly](https://discuss.koinly.io/u/Anakin_Koinly)\ **Post date:** [May 14, 2021, 11:47am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/4 "2021-05-14T11:47:00Z")
Hello, Can you DM me the file? Regards, Anakin ---
**Author:** ![soyhyunsoo](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/soyhyunsoo/32/915_2.png) [@soyhyunsoo](https://discuss.koinly.io/u/soyhyunsoo)\ **Post date:** [May 22, 2021, 2:51pm UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/5 "2021-05-22T14:51:59Z")
is there an update on this? I signed up for koinly to compelte my taxes but the inability to export my kucoin futures csv or auto sync the data will lead me to look elsewhere if this isn’t resolved by the next tax season… ---
**Author:** ![Pascal\_AOMS](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/pascal_aoms/32/3486_2.png) [@Pascal\_AOMS](https://discuss.koinly.io/u/Pascal_AOMS)\ **Post date:** [June 23, 2021, 8:19pm UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/6 "2021-06-23T20:19:47Z")
I’d like an answer as well. Importing the CSV file tells me “transactions are missing purchase history”. Looks like Koinly can’t handle the file very well. ---
**Author:** ![DrinkWater](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/drinkwater/32/213_2.png) [@DrinkWater](https://discuss.koinly.io/u/DrinkWater)\ **Post date:** [June 26, 2021, 8:13am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/7 "2021-06-26T08:13:48Z")
Any updates on this? Having the same issue with the .xlsx file provided by Kucoin, the timestamps are not copied correctly when converting everything using the Kucoin CSV template. The Koinly account gets bugged with omitted duplicated transactions even after deleting and creating a new Kucoin wallet. ---
**Author:** ![walkthewalk](https://yyz2.discourse-cdn.com/flex052/user_avatar/discuss.koinly.io/walkthewalk/32/2782_2.png) [@walkthewalk](https://discuss.koinly.io/u/walkthewalk)\ **Post date:** [August 24, 2021, 10:23am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/10 "2021-08-24T10:23:08Z")
I found that editing the auto-sync settings and specifying a date (rather than beginning of time) seemed to work. ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex052/uploads/koinly_app/original/1X/7ac58e5593a7122893d066794a7254dcdb5ddb31.png) [@system](https://discuss.koinly.io/u/system)\ **Post date:** [October 23, 2021, 10:23am UTC](https://discuss.koinly.io/t/kucoin-csv-xlsx-import-does-not-work/4761/11 "2021-10-23T10:23:26Z")
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.