Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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
1  
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .