Forum Discussion
Peter Snabe
Aug 03, 2018Copper Contributor
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?
Peter Snabe
Aug 03, 2018Copper Contributor
The format in the file should end up like this:
"product no","description","quantity"
"1254A","Green bucket","10"
richmontsy
Jan 21, 2020Copper Contributor
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"-