Why does my exported .csv file look broken in Excel?

book reader icon
1 Minute
facebook logo gray
linkedin logo gray
mail logo gray

The exported csv file uses a semicolon ; as a column separator. If your Excel uses a comma , as a default separator when opening a csv file, all data will show up in one column.

You can overcome this problem by opening Excel, go to the Data menu and click on From Text. Then select your csv file and choose the file type delimited and select the semicolon ; as a column separator.

Last update 1 year ago