Skip to main content
Patrick Lomasney
Inspiring
August 28, 2022
Answered

Error Code 86 :: 1 when importing csv file

  • August 28, 2022
  • 1 reply
  • 1297 views

It is extremely hit and miss whether the csv file will import properly.  Sometimes when I save the file from Excel it will import fine into AE but the row numbers will seem to be a bit off, in that the 0,0 cell seems to be where the 1,1 cell should be, and the rest of the time I get an import error.

I have attatcehd the error screenshots below along with me Excel export settings and the csv file.

Thanks

  

This topic has been closed for replies.
Correct answer Joost van der Hoeven

Make sure the columns are named. Your first colums have no name. I've given them a name and now there is no error.

1 reply

Joost van der Hoeven
Community Expert
Joost van der HoevenCommunity ExpertCorrect answer
Community Expert
August 28, 2022

Make sure the columns are named. Your first colums have no name. I've given them a name and now there is no error.

Patrick Lomasney
Inspiring
August 28, 2022

Got it, thank you for yourt help