This blog talks about how you can use a little known Google Docs Sheets API to download spreadsheets as a CSV.
Obtaining the documents Sheet ID
Before the spreadsheet can be downloaded you will first need to find the Sheet ID. This is a string made up of letters and numbers that uniquely identifies the spreadsheet.
For a Google Docs Spreadsheet the URL will be in the form:
You will need to take the ID from this to use it with the download API.
For example, the Pokemon Go Nesting data spreadsheet has the following URL
From this we can obtain the sheet ID which is
The second piece of information that is needed is the name of the sheet you want to download. Since CSV can only hold a single page at a time you need to get the name of the Sheet. This is the name at the bottom of the page.
Now we are able to construct the download link
Constructing the CSV download link
Taking the Sheet ID above, we can enter it into the download link below
This means that if I wish to export the above spreadsheet as CSV, downloading the “Nest” sheet I can create the following URL.
Some of the formatting will be lost when the CSV is exported but this allows programmatic conversion of the Google Docs Sheets spreadsheet to CSV.