I recently came across a Google Sheets that had a slightly different syntax in the URL. I found these tags after the Spreadsheet Key:


I experimented by putting each of these at the end of one of my docs and discovered some things changed as a result:

&single=true &gid=0 &range=B5%3AB5 &output=html

I was particularly interested in &range=. When I chose a regular range such as A1:B2 it also worked.

But why &range=B5%3AB5?

What does it mean and how do I use it?

  • 1
    &range=B5%3AB5 is the same as &range=B5:B5 (url encoding) – neo Jul 4 '11 at 15:59
  • &output=pdf generates the sheet as a PDF. – bleater Dec 7 '15 at 5:05

This link has a few of the ones you mentioned and some you didn't

Reference Guide - Google Spreadsheets API - Google Code

some of the page is irrelevant to the question.


The special characters are encoded using URL encoding. If you have to use special characters in the URL, you will need to encode them. You can use a web app such as this for doing the same.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.