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?
On the Mac, I just set the column to TEXT, and then it will export properly (with quotes when necessary) using the UTF-8 CSV option.
Yes, this is the current behavior in Windows as well. Just set the column as TEXT and Excel will generate the enclosing double quotes in CSV if your column value has a comma in it. It will not generate the quotes in the rows that does not contains any comma.