I have utf-8 data which I would like to save as CSV.
My old version of Excel mangles utf-8, so I have to resort to using google's spreadsheet which handles utf-8 beautifully.
Some of my data have commas in them, so I must wrap every field of data in thCSVsv with double quotes. I have hundreds of lines, so it would take some time to do it manually and without error.
How can I accomplish this in google docs spreadsheet?
Updated answer for 2021: At this time, when downloading a CSV, Google Sheets wraps any cells containing commas with quotes. Some persnickety CSV readers may not like having records with quotes and others without, but Excel handles it fine.
Another way to do wrap all in quotes is by using a custom Format.
Format --> Number --> More Formats --> Custom number format
Enter "@" This will wrap all fields in quotes.
Download the CSV and use find/replace to reduce the triple quotes """ to "
