Why are the changes that I made in a CSV file not saved?

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

4 Answers

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

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

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.

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

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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