Export google document as csv without quotation marks

I have a google document spreadsheet that I want to export as csv

It may be unpalateable but it seems you want to download it in a format that is not CSV but which is a bit like CSV yet incompatible with it. It is possible Google does not accomodate arbitrary user-defined formats.

I don't know why or when [quote-marks] are included

When the data value for a cell contains delimiter characters such as a comma.

What should I do?

Any of

  • Use CSV and use an appropriate CSV-parsing or CSV-reading library function in the programming language you are using.

  • Use CSV and pre-process the file using another language that has good CSV handling library functions (Perl springs to mind but there are many) then write the data in a format your program can cope with

  • Use "Text" (actually .TSV) which uses tabs as separators instead of commas and doesn't quote fields that contain commas. Change your program to split by tabs not commas. Hope that your program never encounters data values that contain tabs.


Update - it seems since this post Google Sheets now only exports CSV WITHOUT double quotes. That's too bad. I could really use quotes. Some basic export options would be nice.