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



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

No comments:

Post a Comment



Donate Towards More Raspberry PI's for Projects