Skip to main content
All CollectionsFAQ
When I upload a .CSV file to Autoklose I get an error message.
When I upload a .CSV file to Autoklose I get an error message.

Blank columns error message when uploading a .CSV file to Autoklose.

Written by Bergen Wilde
Updated over a week ago

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:

1. Import your Microsoft Excel file to Google Spreadsheet and download it as Comma Separated Value (.CSV). Click here to get Google's guide on how to do it.

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. Duplication error message:
If you didn't map any of the column fields from your .CSV file with Autoklose fields. tokens this message will pop up.
In tis case please go back and re-upload the file and make sure to map the fields correctly.ย 

Please make sure to message us if this is too complex. Look for the chat on the bottom right. ๐Ÿ˜Š

If you have any questions do not hesitate to initiate a live chat.ย 

Happy klosing! :)
Your team!

โ€” โ€” โ€”

To learn about sales, customer acquisition, business strategy, and more, read our 50,000 subscribers strong blog.

Join over 10,000 followers on LinkedIn, to learn just released success stories from around the world of business.

Did this answer your question?