IMPORTRANGE Function in Google Sheets | Multiple Sheets

Leila Gharani

2 followers

50 Video Views·Aug 14, 2023 #googlesheets #importrange

Google Sheets IMPORTRANGE Function tutorial. With IMPORTRANGE function you can import data from other spreadsheets. All you need is the spreadsheet URL and the range you'd like to import. You can use IMPORTRANGE to create dynamic reports and also append data from multiple sheets.

In this video I first show you to use the IMPORTRANGE Function and then how you can use QUERY function together with IMPORTRANGE to combine multiple tabs - you'll be using column number syntax like Col1 when using IMPORTRANGE inside the QUERY function.

To master the IMPORTRANGE and QUERY functions check out my complete Google Sheets course: https://courses.xelplus.com/p/google-sheets

Time Stamps
00:00 How To Import Data From Another Google Sheet with IMPORTRANGE
00:55 IMPORTRANGE function
03:27 How To Use a Drop Down to Interactively Select IMPORTRANGE
05:11 IMPORTRANGE to combine multiple sheets
07:17 QUERY with IMPORTRANGE to properly combine multiple tabs

⯆ Blog article is here: https://www.xelplus.com/google-sheets-importrange

More Google Sheets videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets #importrange