4

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

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

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?

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

2 Answers 2

4

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.

3

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 and acknowledge you have read our privacy policy.

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