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]
That feature would save me at least 10 minutes over my life time. I would really like to have those 10 minutes back. Please?!
Chris P commented
For the love of all that is holy please do this. Even if you can give us the registry key so that we can manually change the flag... please.
I'm begging here.
Yes, must be mac too, don't make us suffer. If I could put all my votes into this one I would. It's what I run into the most, and is very annoying.
Nicholas Johnson commented
Oh please please please do this. I deal with csv's a lot and so hate that popup...
James Paden commented
Mac application too.
it's also the number 1 upvoted suggestion on the thread. I can't see their next AMA going well at all if ignored.
For reference. This entire thread is relative. Option for removing CSV warning, and option to parse all CSV fields as string fields.