Sometimes, when you save a file from .xlsx to .csv in your Microsoft Excel it will add random numbers of blank columns to the file and our system will return you the error message.
If that happens there are two ways to properly save your Excel file as a Comma Separated Value (.CSV) to avoid running into any hurdles along the way:
2. In case you don't want to use Google Spreadsheet, we have a bit more complex solution with step by step instructions (please do not hesitate to message us, too, we would be happy to help! 😊):
- In your Excel worksheet, go to File > Save As.
- Name the file and choose Unicode Text (*.txt) from the drop-down list next to "Save as type", and
- then click Save.
- Open the unicode .txt file using your preferred text editor, for example Notepad ++.
- Since our unicode text file is a tab-delimited file and we want to convert Excel to CSV (comma-separated) file, we need to replace all tabs with commas.
- Select a tab character, right click it and choose Copy from the context menu, or simply press CTRL (command) + C.
- Press CTRL (command) + X to open the Replace dialog and paste the copied tab CTRL (command) + V in the Find what field.
- When you do this, the cursor will move rightwards indicating that the tab was pasted.
- Type a comma in the Replace with field and click Replace All.
- Click File > Save As, enter a file name and change it from .txt to .csv then change the encoding to UTF-8.
- Choose All files (*.*) next to Save as type, then click the Save button.
3. Please make sure to message us if this is too complex. Look for the chat on the bottom right. 😊