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?
YellowCylinder It shouldn't be this hard though, do you agree?
On mac I use CSV editor (small fee) solves all the CSV manipulation. On Windows is a freeware tool called: Ron’s Editor.
To me it’s unbelievable that Excel can’t handle this in a user friendly way. I live in The Netherlands and CSV’s are exported with a semi colon (;) so we need to replace that too.
To me it’s unbelievable that Excel can’t handle this in a user friendly way. I live in The Netherlands and CSV’s are exported with a semi colon (;) so we need to replace that too.