curl / Mailing Lists / curl-users / Single Mail
Buy commercial curl support from WolfSSL. We help you work out your issues, debug your libcurl applications, use the API, port to new platforms, add new features and more. With a team lead by the curl founder himself.

Problem with published google sheet

From: Boyd Kelly via curl-users <>
Date: Mon, 16 Sep 2019 08:14:55 +0000


I have not been able to download a publicly published google sheet in tsv
with curl. (There is no authorization here) The problem seems to stem
from the gid that identifies the particular tab/sheet that is published.
Here is a sample url:

If I simply click on this link in a browser I am prompted with a filename
to save this as tsv and it works. With curl I just get a bunch of script
that downloads. I've tried various options (-O -J -L etc)

One thing I notice is that if there is only *ONE* sheet in the workbook
that is published and then I remove the gid=number and single=true parts of
the url I can download the file.

This is the same sheet as above but 'published' from a workbook where there
it is the only sheet:

Even in this case, I need to modify the url as follows to download the file:


However I need to download two sheets, so this is not ideal for me. Any
ideas as to why this is happening? It does appear to be some issue where
the gid selects the sheet to download. But why does it work fine in a
browser but not with curl? Is this a pure Google problem? Or is there
some curl magic that can deal with this?

Thanks for any help!

Boyd Kelly <>
Tel: +1 604 837-0765

Received on 2019-09-16