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?

1 Answer 1


A Google spreadsheet URL looks like the following


Just replace 1mPqoaJW75FlHI_nCIZ-O9MBaTQ5Y58HGf0bdzFMKd-Y by your own spreadsheet-key.

An alternative is to use


The same apply, just replace the file id by your spreadsheet-key

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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