I’m trying to import a CSV file but it reads everything as one column

CSV files are like spreadsheets, they are made of columns and rows.

Our plugin detects the columns separator automatically when the file uses any of these separators: , ; | (tab).

But sometimes our plugin is not able to detect the separator for several reasons (maybe your file uses a different character as separator or the columns contain , as part of the name, which breaks our detection).

In that case, the solution is the following:

  • Open the file in the notepad
  • Read the first line and see which character is used for separating the column names
  • Open our importer tool, activate the “advanced options”, and enter the separator character in the “separator” option

Do you need help?

You can receive instant help in the live chat during business hours, or you can contact us and we will help you via email.