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

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