Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

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.

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

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

share|improve this answer
add comment

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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