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]
John Kowalke commented
Thank you for working on this - it will be a huge convenience for me.
Great to hear. Thank you for listening!
Herman Fossum Sorgendal commented
[–]MicrosoftExcelTeam[S] 1976 poeng 7 måneder siden
When we load any file type from disk we load it into the same set of data structures in memory. When you go to save it we have to translate it back to whatever file format you want and don't re-open it. Since we don't guard the user from doing things that might not be compatible with the destination file format (like font changes, charts, colors, etc.) we pop that warning as a courtesy to make sure you are aware that something might have gotten lost even though you might still see it on your screen. -- Kevin
This is the answer to why this isn't solved from an askreddit thread, however I beleive a viable solution is to have a option to turn it off for superusers. This thing bugs me every single day.
Has any decision been made? It's been 8 months.
When you are at it, it will be nice to have an option to save either with a comma or with the local separator.
Will avoid launching OpenOffice to do the job.
Furthermore could it remember you have saved the file, it asks again when you close it to save again. I know the format of file cannot change but maybe create a temporary file when a csv is open in excel to track when it is saved if that helps?
Stephen Williams commented
This should be an easy fix. Please end our frustration!
Chad Keck commented
This has been an incredibly frustrating experience over the years. How many prompts to save a CSV? 4-5...plus 2 save dialog boxes? C'mon.
Ben Wilson commented
Please do this
PLEASE can you implement this suggestion! Bain of my life.
Kevin Marquette commented
I would even be happy if it was a registry key that I could set to disable it.
please god yes
I hate Excel so much for this, please fix it.
Chris Barnes commented
This would be incredibly helpful for anyone who does serious work in scripting and programming.
The number of times a day I use a CSV to automate something that would take ages is ridiculous, it'd be much faster if I didn't have to click the button in the box the several hundred times a week I save a CSV.
Whether it's changing column order in a CSV to translate data from one application to another, to creating batch scripts to run similar actions on files that don't cohabitate with one another, or using it to create data sets for PowerShell implementations of old bash scripts, Excel is a part of one, if not several of the steps required to make all of it work well.
Please implement this.
I think the easiest way to do this is to have a small checkbox saying "Do not warn me about this again."
great, I work a lot with csv files
I must hit this warning at least 15 times a day. Importing and exporting CSVs is a thing