Error Code 86 :: 1 when importing csv file

Explorer ,
Aug 28, 2022 Aug 28, 2022

Copy link to clipboard

Copied

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

Screenshot 2022-08-28 101045.png

Screenshot 2022-08-28 101110.png

  

Screenshot 2022-08-28 101330.png

TOPICS
Error or problem , Import and export

Views

55

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Aug 28, 2022 Aug 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.

Likes

Translate

Translate
Community Expert ,
Aug 28, 2022 Aug 28, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Aug 28, 2022 Aug 28, 2022

Copy link to clipboard

Copied

Got it, thank you for yourt help

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Aug 28, 2022 Aug 28, 2022

Copy link to clipboard

Copied

LATEST

Got it, thank you for your help

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines