Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Error Code 86 :: 1 when importing csv file

Explorer ,
Aug 28, 2022 Aug 28, 2022

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.pngexpand image

Screenshot 2022-08-28 101110.pngexpand image

  

Screenshot 2022-08-28 101330.pngexpand image

 

TOPICS
Error or problem , Import and export
1.1K
Translate
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.

Translate
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.

Translate
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

Got it, thank you for yourt help

Translate
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
LATEST

Got it, thank you for your help

Translate
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