Google Docs’ infamous “Moved Temporarily” error – fixed!

I store quite a lot of info in Google Spreadsheets, for the obvious reasons:

  • anyone can edit from any place, even at the same time
  • the servers are more reliable than a server at the office
  • I can use the info (with CSV/Excel export) in other programs through a web link

But there is a problem popping up at random moments with that last export or ‘publish’ functionality. Sometimes when you download the published link of a CSV export (through curl), you get an error ‘Moved Temporarily – The document has moved‘ with a redirect to a address. And if you don’t follow HTTP 302 redirects, you can’t get to the actual content. In the past I’ve always worked around it or waited until the error went away, but today I searched a bit further. So for those who have the same question: read and learn!

The redirect is actually for authentication. Although I publish without requiring signing in, so one would expect no authentication process, there actually is one. See what it does (I used wget in verbose mode to get the HTTP headers):

>:~$ wget -v ""
Location: (first redirect)
Location: (second redirect)
Saving to: ...

So what is the solution: just add “&ndplr=1” to your URL and you will skip the authentication redirect. I’m not sure what the NDPLR parameter name stands for, let’s just call it: “Never Do Published Link Redirection“.

6 thoughts on “Google Docs’ infamous “Moved Temporarily” error – fixed!”

  1. Hi there,

    Sadly, I tried what was recommended and it didn’t work.

    Are there any alternatives?


  2. Curl can be made to follow the redirect (just as wget does by default) with the -L or –location flag:

    curl –location ‘…’

  3. The fix described in the article doesn’t work, but in my case just following redirects fixed it. If you’re using curl, just add the -L parameter.

  4. So apparently this has been fixed. I can assure you that back in 2011, just adding the -L flag to curl didn’t work.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.