up vote 2 down vote favorite
share [g+] share [fb]

Why are the changes that I made in a CSV file not saved? For example, I change the style of a cell to "Numbers". I save the file, but when I open the file again, the changes aren't saved.

link|improve this question

67% accept rate
feedback

3 Answers

up vote 8 down vote accepted

CSV files contain only data, as comma-separated values. If you want to keep your formatting changes, save the file as an Excel file (i.e. myfile.xls), using the 'save as' file menu option.

link|improve this answer
1  
Even more: I'm quite sure Excel warns about that when saving...? – Arjan Dec 25 '09 at 11:22
feedback

Because csv only contains data, not style. If you want to save style save as .xls.

link|improve this answer
feedback

CSV files can't contain styling. Any styling you apply will only exist for that editing session.

If you want to preserve styling, save in a different format, such as XLS.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.