How to: open your CSV file inside Excel


A few of you had trouble exporting the CSV file to excel properly, hence we though a quick tutorial could be useful. We also provide guidance for those of you using non-latin characters, such as Chinese or Arabic. 

CSV means Comma-Separated-Value and it's great value is that it is in plain-text form. As such, a CSV is a simple file format that is widely supported by consumer, business, and scientific applications. CSV is also an open standard that can be independently open with Microsoft Excel,  Apple Number or Google Spreadsheet. 

However, when you import a CSV file into Excel, there's sometimes issues with the rows and columns. Also, Excel has some issues regarding non-latin characters in CSV files.

Please follow this procedure to import your CSV file to Excel correctly. 

1 - From a new or from an existing document,  go to the menu "Data", click the button "From text".

 

2 - In the  "Import Text File" dialog, select the .csv file you want to open, and click the button "Open". 

3 - A new window "Text import wizard" appears. Make sure that you select the option "Delimited" and "Unicode - UTF 8" in "file origin".


 

In the preview area at the bottom, you will see the text as it will appear in your document. If some text is unreadable (something such as   "毚覩䤎㠜む ã «ã"), it probably means you have selected the wrong encoding in "File origin".

4. Click Next, and Excel will ask you to select the delimiter. For our CSV file, the delimiter is the comma ",". keep the other options at their default value :

 

The preview area should show the columns separated correctly.

5. Click Finish, your data will be imported correctly. Select the document sheet you want to have the text in.


Remember to save your document in xls or xlsx format.

Note that screenshots come from Microsoft Excel 2010 for windows and the process may be slightly different if you are using a different version. Free software alternatives to excel include LibreOffice or Google documents. 



Feedback and Knowledge Base