Forum Discussion

Peter Snabe's avatar
Peter Snabe
Copper Contributor
Aug 03, 2018

Save as CSV file (UTF-8) with double quotes - how?

Hi   I often need to save data as a CSV file (UTF-8) where all cells are surrounded by double quotes. I cannot find any way to do that in Excel - can it be true? Any idea how to do that?
Excel
Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Aug 03, 2018

Hi Peter

 

Sorry I am not quite following what you are asking for.

 

I have saved cells with double quotes in them and they save fine in CSV file (UTF-8) in Office 365.

 

Can you please give an example of what type of data you have in " " and what version of Office you are using?

 

We can hopefully sort it out from there.

 

Thanks and have a great weekend.

 

Cheers

Damien

  • Peter Snabe's avatar
    Peter Snabe
    Copper Contributor
    Aug 03, 2018

    The format in the file should end up like this:

     

    "product no","description","quantity"
    "1254A","Green bucket","10"

    • Philip101's avatar
      Philip101
      Copper Contributor
      Apr 10, 2020

      I got round this by replacing the double quotes in Excel with a character that I did not use in the spreadsheet (£ worked for me), exporting as a .csv file, and then, having opened the file in Notepad, replacing the £ with the double quotes. 

      Peter Snabe 

    • richmontsy's avatar
      richmontsy
      Copper Contributor
      Jan 21, 2020

      Peter Snabe- hi Peter, were u able to get a workable solution to this problem? I've been trying to find an easy solution but none so far. I wonder why the save to CVS (UTF-8) doesn't work even when cells redefined as "text"-

Resources