google-sheetsr-googlesheetsgoogle-sheets-api

How to export a csv from Google Sheet API?

I can't find any reference to an API to export an existing Google Sheet as a CSV file.

https://developers.google.com/sheets/

Solution

  • You can use the Drive API to do this today -- see https://developers.google.com/drive/v3/web/manage-downloads#downloading_google_documents, however that will limit you to the first sheet of the document. The Sheets API doesn't expose exporting as CSV today, but may offer it in the future.