This website uses necessary cookies to ensure that our website is ideally usable. We do not use cookies that process personal data without your prior consent. Read our Cookie Policy Ok

1 Minute
share fb

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.

Last update 4 months ago