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?
Google Sheets – How to Perform a Reverse Lookup Using a Spreadsheet Key
google sheetsimportrange
Related Topic
- Google Sheets – How to Work Around the IMPORTRANGE Error: ‘Results Too Large’
- Google Sheets – How to Use IMPORTRANGE with a Variable Range-String
- Google Sheets SORT Formula – How to Handle Null Cells
- Google-sheets – Using FILTER or IMPORTRANGE to bring in and filter data from another spreadsheet with a keyword instead of exact match
- Google-sheets – What spreadsheets import from the spreadsheet
Best Answer
A Google spreadsheet URL looks like the following
Just replace
1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Yby your own spreadsheet-key.An alternative is to use
The same apply, just replace the file id by your spreadsheet-key