CSV needs to be saved as XLS or XLSX to import

  • 1
  • Problem
  • Updated 5 years ago
  • Solved
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: bug resolved

Hello, I cannot seem to make my upload work. It is a CSV (comma delimited) file and I keep getting and error. I have uploaded to the documents Library, any assistance would be appreciated
Photo of Fishing Survey

Fishing Survey

  • 2 Posts
  • 0 Reply Likes

Posted 5 years ago

  • 1
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Hi there! Thanks so much for going ahead and adding the CSV to your document library. That was really helpful. :)

I took a look at the CSV, and it seems you're doing everything right. I want to try one quick thing so we can rule it out -- I've resaved this CSV file as an Excel file (XLS or XLSX) and uploaded it to your library. Will you try importing this version? We've found recently that CSVs that won't import will go through when saved as Excel files.

Let me know if that doesn't do the trick, and I'll keep digging!
Photo of Fishing Survey

Fishing Survey

  • 2 Posts
  • 0 Reply Likes
Hi Katie,

Thanks a ton! That worked like a charm!
Photo of Katie Lewis

Katie Lewis, Official Rep

  • 3414 Posts
  • 309 Reply Likes
Fantastic! I'm making a note on your account that you ran into this bug, and I'll give you a shout here as soon as this defect has been fixed so you'll know you can start using CSVs again. :)