Broken CSV file: How To Fix That?
Sometimes you try to open your CSV file and it looks like this:
This is due to the fact that Excel didn't read & understood the file properly in the first place.
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:
Download the CSV file from Evaboot
Import it on Google Sheet
Export the imported file from Google Sheet
Open the Google Sheet exported file in Excel
Click on File > Import
Click on "Upload" and choose your CSV
``
Click on File > Download > Excel
You can now open your .xlsx file with Excel.
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:
Download the CSV file from Evaboot
Import it on Google Sheet
Export the imported file from Google Sheet
Open the Google Sheet exported file in Excel
1. Download the CSV and import it on Google Sheet
Click on File > Import
Click on "Upload" and choose your CSV
``2. Download file as Excel
Click on File > Download > Excel
You can now open your .xlsx file with Excel.
Updated on: 09/02/2024