Skip to main content

I am opening my .CSV file with Excel, and it is unreadable, what is the problem?

Written by Lucien Berkani

The issue is likely in the formatting of the file during its opening with Excel. In this case, we suggest you follow the below steps:

  • Click on "Data".

  • Select "Get Data", "From File" -> "From Text/CSV."

  • Choose your file and click "Import."

  • Verify that the file origin is UTF-8 and the delimiter is a semicolon, then click "Load."

  • Et voila!

Keywords: .CSV file, Excel, unreadable, formatting



Did this answer your question?