How to correctly display .csv files within Excel 2013?
csv, excel, office-2013
Solution
Open the CSV file with a decent text editor like Notepad++ and add the following text in the first line:
sep=,
Now open it with excel again.
This will set the separator as a comma, or you can change it to whatever you need.
Problem
It seems Excel 2013 doesn't read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are displayed in the first column. I know I can go to `DATA`, `Convert`, and then choose `commas`, but this set up is not saved, and I am fed up doing this every time I open this kind of file. How can I set Excel 2013, once and for all, to display CSV files (comma separated) prettily?