When I try to import a CSV file I get the following error "Error Importing Row: 1 - Incorrect number of columns. Make sure you Have 18+ Columns". I have tried to update the file putting quotes on every single entry but that doesn't work either. I have attached a file so that you can see how it looks.
I have tried to export it from excel both as comma separated CSV, and comma separated CSV (UTF-8) but regardless I get the same result.
Any idea what it is I'm doing wrong?
Store Locator: 126.96.36.199
Last edit: 4 years 3 months ago by carramone. Reason: typos
Hi, thank you.
When I exported to Windows CSV it worked. It did however only import empty rows and it also said that there were a lot of errors. But that problem was easy to fix. The problem was the CSV export from excel that didn't work as I expected it to do. Excel added " around every cell by itself, it also used ; instead of , to seperate cells. This gave me a file that looked like this:
When I batch replaced """ with " and ; to , the file worked.