How to correctly display CSV files (Excel 2013)

Share on facebook
Facebook
Share on google
Google+
Share on twitter
Twitter
Share on linkedin
LinkedIn

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:

sep=,

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:

More to explorer

how i started being a minimalist

How I Started Being A Minimalist

Once, I thought that all that mattered in life were the things that you possessed. Things like your car, house, watch, clothes.

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *