Skip to content

Broken CSV File: How to Fix It?

Nothing is wrong with the file — Excel imported it with the wrong separator. Your export opens with every field crammed into the first column, commas and all:

An Evaboot CSV opened in Excel with every field crammed into a single column

Quickest fix: download XLSX instead

Section titled “Quickest fix: download XLSX instead”

Every Evaboot export can be downloaded as XLSX as well as CSV, from the download menu on the export’s row. XLSX carries its own column structure, so Excel has nothing to guess.

Second fix: let Excel open the CSV itself

Section titled “Second fix: let Excel open the CSV itself”

Double-click the downloaded CSV instead of importing it through Data > From Text/CSV. Excel applies its default separator handling, which is usually right.

Third fix: through Google Sheets

Section titled “Third fix: through Google Sheets”

  1. In Google Sheets, click File > Import.

    The File menu open in Google Sheets with Import highlighted

  2. Choose Upload and select your CSV.

    The Google Sheets import dialog on the Upload tab

  3. Click File > Download > Microsoft Excel (.xlsx).

    The Google Sheets download menu with Microsoft Excel selected

  4. Open the downloaded .xlsx in Excel.

Section titled “Related articles”