Forum Discussion
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?
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
The format in the file should end up like this:
"product no","description","quantity"
"1254A","Green bucket","10"