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.

pnuts
  • 17,883
  • 5
  • 55
  • 103
user88105
  • 41
  • 1
  • 2

1 Answers1

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

Jacob Jan
  • 23,322
  • 16
  • 106
  • 195