Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


My question is what are these and where do I find a list of all the options???

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





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?

Does anyone have documentation about what other display options exist?

share|improve this question
&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.

share|improve this answer

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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