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.
Tell me more
×
Super User is a question and answer site for
computer enthusiasts and power users. It's 100% free, no registration required.
|
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. |
|||||
|
|
Because csv only contains data, not style. If you want to save style save as |
|||
|
|
|
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. |
|||
|
|