Import from .csv

358 views
Skip to first unread message

PeterScopely

unread,
Sep 11, 2012, 5:28:37 PM9/11/12
to google-api-p...@googlegroups.com
I have a google spreadsheet that I periodically want to update from a local .csv file. I want to append the rows in the .csv to the spreadsheet (similar to how File --> Import --> Append Rows works in the google GUI). I can't find a method that would accomplish this easily, and was wondering how to go about doing it. I'm hoping I don't have to read in the .csv and then add it row by row, but that may be the only option. Any help would be greatly appreciated.

Thanks

Joe Gregorio

unread,
Sep 11, 2012, 8:11:48 PM9/11/12
to google-api-p...@googlegroups.com
You would be looking for the spreadsheets API which is covered by this
library:

http://code.google.com/p/gdata-python-client/

And this discussion group:

https://groups.google.com/group/gdata-python-client-library-contributors

-joe

Ali Afshar

unread,
Sep 11, 2012, 8:58:30 PM9/11/12
to google-api-p...@googlegroups.com
Another (probably worse) option would be to upload the spreadsheet each time to Google Drive, using the Google Drive API which is covered in this library.
--
Ali Afshar | www.googplus.org/ali | Google Developer Relations

PeterScopely

unread,
Sep 12, 2012, 4:55:02 PM9/12/12
to google-api-p...@googlegroups.com
Thanks!
Reply all
Reply to author
Forward
0 new messages