How to correctly display CSV files (Excel 2013)

//How to correctly display CSV files (Excel 2013)

How to correctly display CSV files (Excel 2013)

Excel 2013 has an issue displaying files in CSV format that other versions of Excel doesn’t seem to have. To fix this, you’ll just need to open the CSV file with any text editor (like Notepad), and add the following as the first line:


This sets the comma (or any other character that you need) as the separator. Now just save and close the file from your text editor, and then open it with Excel 2013.

Similar Posts:

By |2015-08-25T03:34:06+00:00August 25th, 2015|Programming & Code|1 Comment

About the Author:

Alvin Poh lives in Singapore, and is interested in marketing, techy stuff, and likes to just figure out how the two can work with each other. He can also be found on Google+.

One Comment

  1. sally January 29, 2016 at 7:22 am - Reply

    I was facing so difficulty with ms office 2013. Glad that i found this site.

Leave A Comment