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;


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 Feb 21, 2015 at 20:55
  • And if you're using the new Google Spreadsheets, you use the entire link. Feb 21, 2015 at 20:56
  • @Punchlinern In combination with IMPORTRANGE()? Feb 21, 2015 at 20:58
  • 2
    @JacobJanTuinstra Yes, from docs for IMPORTRANGE: In the new Google Sheets, use the entire URL. Feb 21, 2015 at 21:00

1 Answer 1


This is your key:


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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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