Convert Excel to CSV file

It might happen that even though you save your Excel file as a CSV, not all the settings are correct. In this case, you can follow the steps underneath to successfully convert your Excel file to a CSV file. You can choose to use Microsoft Excel to convert your file, but you can also use other tools such as Google Drive or OpenOffice.


1   Microsoft Excel

Open your file and click the File menu.


Excel-to-csv-1


Click on Save As.


Excel-to-csv-2


When you name your file, click on Tools and choose Web Options.


Excel-to-csv-3


Go to the tab Encoding and choose to save the document as Unicode (UTF-8).


Excel-to-csv-4


Click OK and save your file.


2   OpenOffice

Open your file and open the File menu to choose Save As.


Excel-to-csv-5


Choose Save as Text CSV and indicate Edit filter settings.


Excel-to-csv-6


Choose Unicode (UTF-8) as Character set and click OK.


Excel-to-csv-7


Save your document.


3   Google Drive

Go to your Google Drive and upload your Excel document by clicking on NEW, File upload and selecting your file.


Excel-to-csv-8


Open your file by clicking the file and choose Open at the top of the page.


Excel-to-csv-9


When in your spreadsheet click on File to open the File menu. Choose Download as and CSV.


Excel-to-csv-10


Now you have downloaded your file as a CSV.