3

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.

0
9

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.

2
  • 1
    Even more: I'm quite sure Excel warns about that when saving...? – Arjan Dec 25 '09 at 11:22
  • Oddly (and unfortunately) not anymore for me. Is there a setting? – zylstra Aug 14 '18 at 0:47
3

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

3

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.

0

CSV files contain only data.

You can ensure Excel helps prevent formatting loss with its automatic Save As dialogue box. You can disable/re-enable the Save As box by going to File-->Options-->Save-->'Show data loss warning when editing comma delimited files'.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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