How to correctly open exported CSV files in Excel

If the CSV file contains special characters (e.g. æ,ö,å) Microsoft Excel will change the characters if you open the CSV file directly with Excel. 

Example: 

Before opening in Excel: Allan Mørch 

After opening in Excel: Allan Mørch 

 

To avoid this you must first open a blank sheet in Excel. Then click the Data tab at the top of the ribbon and select From Text/CSV. 

tempsnip.png

Now, select the CSV file you want to open and select None as the File Origin. Finaly, click Load.  

Capture.PNG

 

Now all the columns should appear in the Excel sheet including all the special characters originally in the CSV file. 

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.