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).
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.
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?
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.
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.
Still an issue, required for data export for program import
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
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
try to export in .csv via OpenOffice
We need this ASAP. Use it everyday!
This does not make sense at all... So frustrating!
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.