Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
Even more: I'm quite sure Excel warns about that when saving...? – Arjan Dec 25 '09 at 11:22

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

share|improve this answer

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

Your Answer


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.