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?
If the cells contain number, you can apply custom \"#\" format.
cantikaliem_ Thanks, but that doesn't work if there is a mix of text and numbers.
I figure out this customer formula which will work for all scenarios.
\"#\";\"#\";\"#\";\"@\"
This works because you can have multiple custom formula's separated by ; for different data types.
<Format for POSITIVE Numer>;<Format for NEGATIVE Numer>;<Format for ZERO>;<Format for TEXT>
YellowCylinder It shouldn't be this hard though, do you agree?
- Actually, I just did some testing and ended up not using my new custom format. As far as I can see Excel adds quotes if needed when a cell contains a comma whether you save it as UTF-8 or normal CSV, this is the latest Excel 2016. For my use case that is fine, although I can understand why someone people would want it fully on or fully off.
- All these replies and torture that people have just shows how retarded microsoft developers are. You cant paste data properly between two microsoft products. Their developers should be used only for transcribing from pdf to word and nothing else. Trashbags
- 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.
