I can't figure out where the data in an IMPORTRANGE function is coming from.
How can I use the spreadsheet key to find the the original spreadsheet IMPORTRANGE is pulling from?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityA Google spreadsheet URL looks like the following
https://docs.google.com/spreadsheets/d/1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y/edit
Just replace 1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y
by your own spreadsheet-key.
An alternative is to use
https://drive.google.com/open?id=1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y
The same apply, just replace the file id by your spreadsheet-key