Save as: Windows Comma Separated (.csv) - Missing in new version of Excel
With the new update of Excel for Mac (ver.15 -> ver.16) we lost the ability to Save as: Windows Comma Separated (.csv)
It also lost the ability to read these files with foreign characters (my case Swedish). I have my system in English and Excel in English, but I do work with .csv files in Swedish from time to time.
Now I needed to downgrade my system to 15.32, and can't keep my Office 365 suit up to date before I know that this works again.
(Attached are a screenshot of the "Save as" option that we lost with the new version).
Thanks
Ola
Ola Nygards
shared this idea
14 comments
-
jlbr
commented
Use the Numbers application included in the MacOS applications folder. There you will be able to get the Windows csv in the export options when you go to file > export. It just worked for me after many attempts with the MS Excel 16 “save as” export that does not have the Windows csv option anymore.
-
ask
commented
I also NEED the Windows Comma Separated back. The MS-DOS-Comma-separated is not the same.
I would like to open a csv (ASCI=1252) without a workaround with the import.
And then I would like to save as CSV Windows comma separated as it was in the earlier versions.
When does this come back? Or how can I fix it? -
Caitlin
commented
If you have the latest excel 16.46 you can now simply save as "MS-DOS Comma-separated Values" and it will work when needing to upload CSV files from mac to a program that accepts windows CSV's only.
-
R
commented
a workaround i do is just save as "text tab separated", then open it in notepad++
I do CTRL+F (Search and replace), check "Extended (\n, \r, ...)" and do:
Find what: \t
Replace with: ,Important: Obviously the data must not have tabs already in it, otherwise it will be messed up.
-
Anonymous
commented
Still an issue, required for data export for program import
-
Anonymous
commented
HORRIBLE. WHY DONT THESE BASTARDS FIX IT AFTER SUCH A LONG TIME?
-
Annie Turner
commented
a disaster I have just lost a load of work when I saved the file - how can you let us pull a CSV file into Excel to work on it then not save it as Excel?! GRRRRRRRR
-
Cecile
commented
Same issue here, please bring Windows CSV options back!
Otherwise on Mac if I open a CSV with Excel the characters are all messed up and it's not readable! I have to open CSV only with text editors now!
Can someone from Excel team update us on when this will be fixed?
It's just a total deal breaker for me in the use of Excel... Thanks
Cecile from France -
Roger van Erven
commented
Does anybody have a solution for this yet? Causing big problems here not having this anymore... probably downgrading then.
-
Ola Nygards
commented
Here is a help page to down grade your apps. (I only needed to down grade Excel, and it worked with this version as well). https://support.office.com/en-us/article/how-to-go-back-to-office-2016-for-mac-15-xx-versions-from-16-xx-e88ed6c8-6fb4-40a1-9540-529000d3d20f
-
Anonymous
commented
try to export in .csv via OpenOffice
-
Caitlin
commented
We need this ASAP. Use it everyday!
-
Anonymous
commented
This does not make sense at all... So frustrating!
-
Anonymous
commented
This is so silly - it doesn't cost Microsoft a penny to leave this CSV option in, but for our business we now cannot import German Umlaute anymore and cannot use the direct mail programme anymore to target our customers. Now we need to invest hug time to find a way around it.