Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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

23 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Ola Nygards shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

13 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • ask commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Annie Turner commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Does anybody have a solution for this yet? Causing big problems here not having this anymore... probably downgrading then.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

Excel for Mac: Opening and Saving Files

Categories

Feedback and Knowledge Base

(thinking…)