LOAD CSV - Google Spreadsheet csv download link works only once

Since a few days Google Spreadsheet csv download link works only once. Does anyone know if this will last for longer ?

Do you mean the url to use with LOAD CSV?

Yes, until last week you could choose download-as-csv and that download-url.

We need more details.

  • What download url?
  • How are you downloading it?
  • What error are you getting?

Ok, in my projects i use google spreadsheet to manage data and then i use the download-As-Function to get a link to a csv-Version of every table of the spreadsheet. It is explained here: https://kuczera.github.io/Graphentechnologien/20_Regestenmodellierung-im-Graphen.html#google-docs-für-den-csv-download
The csv-Link is then used for LOAD CSV but since a few days the links only work once. When you try to download the csv for a second time the link is not valid any more.

The link you shared suggests a unsupported method of downloading a GoogleSheet as csv. You might try checking that the sheet is shared as "anyone with the link can view," but it also may be that Google has changed the behavior of the download-as-csv link.

The Google Supported Way: Chart Tools API

  1. Find your document key
    • https://docs.google.com/spreadsheets/d/{YOUR-KEY}/edit?usp=sharing
  2. Make sure link sharing is turned on
  3. Create your csv download link
    • You'll also need your sheet-name, which on new sheets defaults to "Sheet1".
    • https://docs.google.com/spreadsheets/d/{YOUR-KEY}/gviz/tq?tqx=out:csv&sheet=Sheet1

From:

Now you can get a csv download link from "publish n web" in the file menu.

2 Likes