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?
Reverse lookup from Google spreadsheet key
google spreadsheets
A Google spreadsheet URL looks like the followinghttps://docs.google.com/spreadsheets/d/1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y/editJust replace 1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y by your own spreadsheet-key.An alternative is to use https://drive.google.com/open?id=1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-YThe same apply, just replace the file id by your spreadsheet-key