Skip to main content
All CollectionsBug Fixing
Broken CSV File: How To Fix That?
Broken CSV File: How To Fix That?
Updated over 5 months ago

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?