How To Use Google Sheets Importrange
This is the workbook key or the id that google spreadsheets use to identify the workbook.
How to use google sheets importrange. Instead of copying the complete url that has the data that you want to import you can simply use the spreadsheet key in google sheets instead. The spreadsheet key is a unique identifier that google sheets uses for each spreadsheet. You can copy the complete url that has the data you d like to import or if you d like the formula to be visually shorter you can copy just the spreadsheet key the unique identifier that google sheets uses for each spreadsheet. Either one is enough to identify the spreadsheet that you want to import from. The key or url of the source sheet.
There are two main components to importrange. The key or url of the source sheet. To specify the first parameter of the importrange function you can either use the full url of the spreadsheet or just the spreadsheet key.