4

I have found many posts from awhile ago that talk about the key in the URL. Problem is when I am trying to input the key, there is none. Well at least I cannot determine what the key is.

This is the URL I get;

https://docs.google.com/spreadsheets/d/11jp7-1POyw_cunE1imQ80Bqxj8U93a4hvHmKpWLY5K8/edit#gid=0.

As you can see, there is no key= so I am at a lost. I have tried trial and error with no success.

Improve this question
4
  • This is your key: 11jp7-1POyw_cunE1imQ80Bqxj8U93a4hvHmKpWLY5K8
    – Jacob Jan
    Commented Feb 21, 2015 at 20:55
  • And if you're using the new Google Spreadsheets, you use the entire link.
    – Punchlinern
    Commented Feb 21, 2015 at 20:56
  • @Punchlinern In combination with IMPORTRANGE()?
    – Jacob Jan
    Commented Feb 21, 2015 at 20:58
  • 2
    @JacobJanTuinstra Yes, from docs for IMPORTRANGE: In the new Google Sheets, use the entire URL.
    – Punchlinern
    Commented Feb 21, 2015 at 21:00

1 Answer 1

Reset to default
3

This is your key:

11jp7-1POyw_cunE1imQ80Bqxj8U93a4hvHmKpWLY5K8

As @Punchlinern mentioned in his comments, with the new Google Sheets you can use the entire URL in combination with the IMPORTRANGE() formula. Using the above-mentioned key, the old style, works as well.

enter image description here

Reference: IMPORTRANGE

Improve this answer

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.