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

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.