none
Excel 2013 - Export CSV with comma delimiter

    Question

  • Hi

    How do you export a comma delimited file in Excel 2013 & Windows 8 using the "Save As"
    You would think that CSV (since its name says its comma separated values) would use a comma, but no, it uses semi-colons.
    I have tried changing the "list separator" value in my region settings to "," from ";" as suggested on some other forums but this does not help. Its still exports a COMMA separated file with a semi-colon separator. Ridiculous.
    I do not want to change my entire region to US, as that changes date & number formats, and that's not acceptable.

    Thanks

    Ty


    Thursday, June 20, 2013 1:07 PM

All replies

  • Hi,

    Since you have set the "list separator" in control panel, then try to check whether you have checked the option "Use system separators" in File -> Options -> Advanced.


    Jaynet Zhang
    TechNet Community Support

    Friday, June 21, 2013 3:43 AM
    Moderator
  • Hi

    Thanks for the reply.
    The "use system separators" is ticked, but it still uses semi-colons.
    Just to see, I unticked it and tried, but still semi-colons.

    Any other ideas?

    Ty

    Friday, June 21, 2013 6:44 AM