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?
Where is this mythical file type csv (utf8)? I only have csv, csv (dos), and csv (mac). I really need Excel to stop screwing up the foreign language characters when saving as csv. What is it that Excel actually saves them as that they don't work in my other apps?
thanx,
clarence
clarence potter
If you "Save As" → "CSV (Comma Delimited)" and then click "Tools" → "Web Options" → "Encoding" , you can choose UTF=8 ... see screen shot below.