Warn users when they will lose formatting saving to CSV
I know a lot of people hated the warning when saving a workbook as CSV. Now that the warning has been removed, if you open a CSV file, make formatting changes and save the file - the formatting is lost with no warning at all.
As mentioned in one of the comments, you can get a warning when working with CSV files. Just go to Excel Options > Save > under the Save Workbooks section, enable the option to “Show data loss warning when editing comma delimited files”.
Thanks – Steve [Microsoft Excel]
32 commentsComments are closed
Troy Roach commented
I feel everyone's pain here. I just lost 9 hours of work editing a file I did not know was .csv and no warning from Excel. What's worse is that it only saved the summary tab I created from the data tab I manipulated. Guess it saves whatever tab is displayed at time of exiting. Would not have been so bad losing the summary tab as it would not take near as long to re-create. Nearly four years of reports on this feed and no response or fix from Microsoft. Sheesh!
******** Microsoft is all I have to say about this **** design
Just got burned as well... I totally forgot I was even working in .csv when I just quickly saved and closed the file :( please help us with a revert option or smth... it (really) hurts to lose hours of work and then have to redo everything from scraaaaatch 😖😖😖😖
Just got burned as well... I totally forgot I was even working in .csv when I just quickly saved and closed the file :( please help us with a revert option or smth... it (really) hurts to lose hours of work and then have to redo everything from scaaaatch 😖😖😖😖
Just got burned by this. Spent several hours formatting a 3 tab worksheet, even printed it out, then hit save and closed. It's just gone. It's so so so frustrating.
Just lost three days of data because I opened a new tab and saved without knowing I was still in .csv. And inexplicably the new tab overwrote the original tab...Microsoft, why? Either put up an alert or don't let users open new tabs when working in csv (!!!). This is terrible.
Anders Harrison commented
Thank you Anonymous. I didn't realise I could turn the message back on. Problem mostly solved for me then. I just need to resist clicking that "Don't show again" button.
There's an option for a yellow warning bar. Excel Options > Save > Save Workbooks > Show data loss warning when editing comma delimited files. Unfortunately the yellow bar is very easy to dismiss and then never see again... Maybe should have been dismiss of this file rather than every csv? But still doesn't give a warning on save.
Adding a pivot table and save. Close and rename the file.... Heckkkkkkkkk only Pivot table sheet is available, remaining all sheets data is lost.
Kindly look into this serious issue.
Liam Wheldon commented
Just got caught out by this! Luckily only 10minutes work.. Deffo need this back in.. that fact it even says "saved" in the title is very very miss leading and incorrect..
just lost a days work and didn't know why until now............no profanity I an think of is enough!
Excel is dumbfuck commented
The formatting? Fuckign whole sheets get removed
Four hours of work lost.
MS Hater (as of now) commented
Microsoft- what the ? I just lost 4 hours because of this stunt. What the **** were you thinking?
Excel supports opening csv.
Excel supports making changes to csv.
Excel saves csv.
Excel closes csv.
Excel loses all changes without any hint.
See the problem?
Unbelievable...I've worked for many years in Excel, the warning was always there. Lost an hour this morning doing a really boring lot of work in a multi-sheet workbook. Opened as a csv, worked for an hour (completely forgetting it was a csv file I was working in, as Excel behaviour is exactly the same as for an xlsx file.) Saved it. Lost it all.....
Great work Microsoft. One wonders if you ever have any REAL people testing this stuff....oh yes, you sacked a lot of your testing team, didn't you....
I've just lost almost a days worth of tax workings. What the ****!
Adam Randall commented
Here is an idea.
If you cannot save extra tabs in csv files then maybe prevent the function when working in them. At the very least give people a warning they are about to lose all of their work. Cannot believe the warning got taken away.
Ignacio Ortiz commented
The solution given to COMPLETELY remove warnings is sub-optimal. Bring back the dialogs, or at least your yellow notification bar that tells: Btw, none of your formatting is truly being saved.
Dave Miner commented
I would just like an option that I could turn on that if I have made changes to a file that I opened as a CSV, it would default to just saving that file as an .xlsx.
That way if I just opened a CSV and changed some data, but didn't add tabs or pivot tables, it would default to saving as the original CSV.
If I've added tables and formatting and tabs, it would default to saving at the same locationas the .csv, just with the .xlsx format.