Wednesday 17 September 2014

Google Sheets - How to grab the sheet as a CSV

                                                    Google Spreadsheets




Very quick tip to get the url for a google spreadsheet in csv format is easy.


when you are in sheets click file and then publish to the web.

copy and paste the URL given and then add /export?format=csv


Example:

https://docs.google.com/spreadsheets/d/1_svvemcpnvbsWolXs3KR0A3in8zf9U3xI6Ms9Pq_vHs/

becomes

https://docs.google.com/spreadsheets/d/1_svvemcpnvbsWolXs3KR0A3in8zf9U3xI6Ms9Pq_vHs/export?format=csv


now it's ready to be downloaded and imported in to a mysql database :)





Amazon

Donate

Donate Towards More Raspberry PI's for Projects