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.

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

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

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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