No more warnings about saving as CSV, especially when I didn't change anything
I don't know how many hundreds (thousands?) of times I've told Excel that, yes, I really truly do mean to save this file as a CSV. I recognize that not all users will understand that CSV doesn't do cool formulas or formatting, etc., but I do and I still want to do it. And I want to do it a lot. Please, give me a way to opt out of these useless warnings!
We’re done – you should no longer get a warning dialog about data loss when saving a file as CSV, as long as the file was originally opened as a CSV file.
Instead, we’ve added a non-intrusive business bar (that you can ignore if you choose) that let’s you quickly Save As the file if you have made changes that are not savable in CSV; if you ignore it and just Save, we’ll just save out the CSV values as you’d expect.
We actually rolled this out starting on August 13, 2016 with build 16.0.7167.2040 for O365 users. Later builds have this update as well of course.
Thanks for participating in UserVoice – we definitely value your input. You can now use whatever votes you’d allocated for this idea for other ideas.
= started status 2016-06-15 =
Great news – we’re working on this (for both Windows and Mac Excel)
Thanks for the suggestion Tom, and thanks to folks for voting! We’re listening to you all, and we’ll get someone to take a look at the flow here. We’ll loop back and update the status appropriately.
John [MS XL]
David Gatlin commented
Tom Campbell commented
After 30 years as a file format, I think CSV has proved itself useful enough to merit this attention...
Yes! *snaps fingers*
Shane Barbetta commented
What this guy said!
Stephen Brewster commented
Yes and YES!
Please make an option to get rid of this message!
please give us the option to disable this!!
I second this option.
I support the "Do not show this warning again" option
Upvote this one please!
Bob from Accounting commented
Please save me.
Pavels Nikolajevs commented
Joel McBeth commented
It should have better detection for incompatible changes to see if the warning even applies. If I open a CSV and I make 100% CSV compatible changes then the warning shouldn't show. If I add a chart the warning should show with a checkbox that says "Do not show this warning again".
And treat all fields on a CSV file as text
Oh for the love of god and all things holy yes!!!!