Export google document as csv without quotation marks

Posted by michelemarcon on Super User See other posts from Super User or by michelemarcon
Published on 2012-01-18T14:43:38Z Indexed on 2012/06/28 9:18 UTC
Read the original article Hit count: 264

Filed under:

csv

|

documents

|

google-apps

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?

© Super User or respective owner

Related posts about csv

DBD::CSV: How can I generate different behavior with the two f_ext-options ".csv" and ".csv/r"?

as seen on Stack Overflow - Search for 'Stack Overflow'
This is from the DBD::File-documentation: f_ext This attribute is used for setting the file extension where (CSV) files are opened. There are several possibilities. DBI:CSV:f_dir=data;f_ext=.csv In this case, DBD::File will open only table.csv if both table.csv and table exist… >>> More
SUPER CSV write bean to CSV.

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is my class, public class FreebasePeopleResults { public String intendedSearch; public String weight; public Double heightMeters; public Integer age; public String type; public String parents; public String profession; public String alias; public String children; public String siblings; public… >>> More
export to csv using fastercsv and CSV::Writer (Ruby on Rails)

as seen on Stack Overflow - Search for 'Stack Overflow'
What am I trying to do: export data to csv. I have a form which allows user to select the format (from a drop down menu). So based on the selection of the format the ouput is displayed using a ajax call. Works fine for html but when I select the format as csv I don't see any pop up on the screen… >>> More
How can i make changes to this file Encoding?

as seen on Super User - Search for 'Super User'
I have these 3 files 21/08/2014 07:15 PM 122 Tw2AWK.csv 21/08/2014 07:15 PM 125 Tw2Notepad.csv 21/08/2014 07:15 PM 119 Tw2REPL.csv C:\myfilesfile Tw2AWK.csv TwREPL.csv Tw2Notepad.csv Tw2AWK.csv; UTF-8 Unicode text, with CRLF line terminators Tw2REPL… >>> More
Unix sort keys cause performance problems

as seen on Super User - Search for 'Super User'
My data: It's a 71 MB file with 1.5 million rows. It has 6 fields All six fields combine to form a unique key - so that's what I need to sort on. Sort statement: sort -t ',' -k1,1 -k2,2 -k3,3 -k4,4 -k5,5 -k6,6 -o output.csv input.csv The problem: If I sort without keys, it takes 30 seconds… >>> More

Related posts about documents

"My Documents" as the first class citizen in "Documents" in Windows 7

as seen on Super User - Search for 'Super User'
In windows 7, you can have a "Document" as a menu on the "Start Menu". However, it lead to sub-items "My Documents" and "Public Documents". As well as only me is using my notebook, "Public Documents" is useless and waste me for a click to the "My Documents". So, my question is -- how do I hack… >>> More
Server.transfer causing HttpException

as seen on Stack Overflow - Search for 'Stack Overflow'
I am developing a C#/SQL ASP.NET web application in VS 2008. Currently I am using the Server.Transfer method to transfer control from one ASPX.CS file to another ASPX file. The first time through, this works. But after control is transferred to this new file it encounters a condition: if (restart… >>> More
MS Word documents to rtf documents

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I've a problem: my application must convert ms word documents (imported from another system) into rtf documents, in order to be manipulated with OOo APIs and to be immune from mistakes (for coding incompatibility reasons). I ask you: how can I manipulate ms word documents directly from… >>> More
how to save ms office documents directly to google documents

as seen on Super User - Search for 'Super User'
I tried this program called office sync but it does not work on ms office 2003. It prompted me to input the username & password in google docs but when I try to look up the document that I save 20 minutes later nothing show up in the recent documents. >>> More
SQL SELECT: "Give me all documents where all of the documents procedures are 'work in progress'"

as seen on Stack Overflow - Search for 'Stack Overflow'
This one really has me stumped. I have a documents table which hold info about the documents, and a procedures table, which is kind of like a revisions table for each document. What I need to do is write a select statement which gives me all of the documents where all of the procedures have the… >>> More