Hi snider,
This sounds like one of two issues. Either there is some data in your spreadsheet that is causing a conflict with the import, or it’s just that the formatting of the CSV file is not matching with the import.
The first thing I would try is to just save your spreadsheet as an XLS or XLSX file instead of CSV file. That should rectify any potential issues with the saved format of the CSV. Try importing as the XLS and see if that works. If not, could you please provide a copy of the spreadsheet you are trying to import?
Tried saving as XLSX, and same issue. As far as the content, could there be an issue with carriage returns within a cell, for paragraph-form answers?
I’d be happy to provide a copy. Do you have a private method I can send it?
Of course, please send it to [email protected]. Make sure to reference this thread.
Thank you
Thanks for the help. For those wondering, the issue was not having the php zip extension enabled. Turned on debug and saw an error about “ZipArchive,” so I went to my host’s site and into the PHP settings and enable the zip extension. Re-ran import and it worked perfectly. Thanks!
