Export google document as csv without quotation marks

csvdocumentsgoogle-workspace

I have a google document spreadsheet that I want to export as csv. The problem is, that some cell get their content included on quotation marks:

1,1,"I don't want quote",Mee too but I'm lucky,1

To avoid this issue, I usually re-edit the field on google document until the export excludes the quotation marks (I don't know why or when they are included).

I've tried with format but apparently it doesn't help. What should I do?

Best Answer

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.

Related Question