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