Skip to main content

Broken CSV File: How to Fix It?

Sometimes you try to open your CSV file and it looks like this:
​
​

excel-problem-evaboot


​
This is due to the fact that Excel didn't read & understood the file properly in the first place.
​
​

How to fix this?

A first quick fix is to open the CSV without manually importing it to Excel.

This means just double click the CSV file from Evaboot & let Excel open it automatically for you.


A second way to fix the issue involves 4 steps:

  1. Download the CSV file from Evaboot

  2. Import it on Google Sheet

  3. Export the imported file from Google Sheet

  4. Open the Google Sheet exported file in Excel
    ​
    ​

1. Download the CSV and import it on Google Sheet


​
Click on File > Import
​
​

google-sheet-import


​
​
Click on "Upload" and choose your CSV
​
​

upload-csv-google-sheet

``
​
​
​

2. Download file as Excel


​
Click on File > Download > Excel
​
​
​

download-file-google-sheet


​
You can now open your .xlsx file with Excel.
​

Did this answer your question?