Skip to main content

I can’t open my CSV file properly

Cécile de Gayardon avatar
Written by Cécile de Gayardon
Updated over 3 months ago

If all the data appears in a single column, Excel likely isn’t recognizing the correct delimiter.

How to fix it:

👉 Try opening the file via Data > From Text/CSV in Excel.
When prompted, select the correct delimiter (; or ,).

Alternatively:

  • Go to File > Options > Advanced

  • Uncheck “Use system separators”

  • Then try using a different delimiter manually (; or ,, depending on your system settings)

📌 The file is a standard CSV format, but Excel may behave differently depending on your language and regional settings.

Did this answer your question?