IMPORTRANGE Function in Google Sheets | Multiple Sheets

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Want to pull data from multiple Google Sheets into one? This video is your ultimate guide to mastering the IMPORTRANGE function. It's perfect for Google Sheets users looking to streamline their data management.
✨ Key Highlights:
▪️ Using IMPORTRANGE: Learn the basics of the IMPORTRANGE function to import data from other Google Sheets.
▪️ Dynamic Data Import: Discover how to dynamically switch between tabs using data validation for interactive data import.
▪️ Combining Multiple Sheets: Find out how to append data from different tabs into one comprehensive list.
▪️ QUERY Function Integration: Get a sneak peek at combining IMPORTRANGE with the QUERY function for efficient data merging (more in the next video!).
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: courses.xelplus.com/p/google-...
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: www.xelplus.com/google-sheets...
More Google Sheets videos: • Google Sheets Tips, Tr...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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

[@LeilaGharani]

Get access to the full Google Sheets Masterclass here 👉 www.xelplus.com/course/google-sheets/

[@anishyadav4747]

Hello Mam, I want to import data from three sheet then what we be the formula ? plz help

[@cindybaxter4007]

You are the BEST teacher. I'm currently going through your Power Query course on Udemy, and I've already revamped a ton of my daily reports. Thanks so much for the great content!

[@mayurkhatri1048]

Thank you Leila for another informative session. Your way of presenting and facilitating the information is awesome 👍

[@michellepancho6369]

First time for me to watch Leila's video as I am searching for a way to transpose data of multiple sheet to just one and her explanation is SOOOO SIMPLE AND CLEAR!!! Thank you so much Leila!

[@LeilaGharani]

You're very welcome, Michelle!

[@emilykohmy]

Simply the best and most easy to be understood google sheet formula video on KZbin! Thank you very much!

[@patrykjankowski5095]

You can't imagine how much it was helpful for me. I'm so much grateful. Thank you!

[@MarcCastellsBallesta]

Awesome! Precisely what I need. I'll re-watch it when I'm in front of the spreadsheet to not miss anything. Thanks!

[@LeilaGharani]

You’re very welcome. Glad you found it useful.

[@brianmichaelmedia]

Excellent explanation. A teacher once told me, speak to your audience like they are intelligent but know nothing about the subjection you are teaching. You were perfect example of that.

[@DeniseL-yy7yj]

Thank you so much for sharing this! With your help, I was able to consolidate multiple google form fed spreadsheets into one sheet enabling my managers to get a quick overview of their entire team's performance matrix. On top of that, I used the consolidated information to create a graph page based on the total values. Since everything is auto updating as it goes along, I don't have to do anything else to make sure my team has current information, providing valuable insight in one location. Bravo!

[@neerajnandan3351]

You are the best! Loved it. Crisp and clear.

[@karenum9696]

Very clear, with added caveats. Thank you so much. So much better than the Goggle official documentation.

[@TylerStanczak]

This is so helpful. Thank you for sharing this Leila :)

[@kevinm.8682]

Mind=BLOWN! This is stuff I can use ASAP. Thanks you for this.

[@BeUCoach]

Very helpful. Was just what I needed for the task. Thank you for sharing this.

[@upahlokal469]

I have been following you for 4 years now and my skills of Microsoft Excel and Google Sheets from zero to hero. Now I am in intermediate level just by learning FREE from youtube. Thank you so much from Malaysia.

[@LeilaGharani]

That's awesome to hear, four years and counting! 🌟 Thank you for your continued support. Keep up the great work, and here's to even more learning ahead. 💪

[@VichiBala]

Thank you so much. I was struggling with this for a very long time 👍🏽

[@muhammadyoussef9138]

I love your videos Leila very informative. Thank you. and keep posting, you can't imagine how many people are benefiting from you videos, I, personally, learnt a lot from them, you helped me a lot in: - getting things faster. - acquiring many more skills - I'm never overwhelmed & stressed with the reports & work load. - being the smartest person in the room. - and tripled my salary because of such skills. Thank you so much, this comment, is never enough for how much I'm grateful, to your content. Keep posting. :)

[@camillesanjose7723]

Thanks so much, Leila. Been watching your tutorials and these are so helpful. 👏🙂

[@LeilaGharani]

You are so welcome!

[@agnesrambling]

Your video help me a ton and I learned more than I did when I use excel. Thanks a million

[@apinyaw1331]

Thank you for an amazing video❤ Just what i'm looking for. I love your explanation it is easy to understand.

[@wowhallo]

My solution for the empty rows would be to wrap each importrange function with array_constrain and do a counta of one of the columns in the data. But I guess query can be better, especially if you add even more functions to the array elements.

[@sc100200090]

Thanks Leila! Source worth enough for sure!

[@diegofreitas4850]

I wish I had seen this video before. It would have made things so much easier for me in a project I was working on. I'll definitely use it in the future.

[@LeilaGharani]

Hope it will come in handy.

[@EanLee]

Can't wait for the next video!

[@Ivanslav1]

You just made my life a lot easier!!!! THANK YOU!

[@LeilaGharani]

Happy to help!

[@ranjannair3053]

Thank you for sharing this. It was much needed

[@patrickschardt7724]

If Excel doesn’t have something like this, they definitely need to make one. Great video

[@panosrozos3341]

Well done! Thanks!

[@jgproductdesign]

This is so great!

[@AccountingandQuickbooks]

Yes it's very useful especially when doing accounting work thanks for sharing 👍

[@EKHeatingAir]

You kilt this tutorial!!! I watched a few and you got it. the only thing i needed to add as SUM as i needed a total amount of data. Thank you so much!!!

[@LeilaGharani]

Glad it was helpful!

[@markseguin2544]

This will be very useful. Thank you again 😊

[@MaxTheDog167]

You just made my day. I just need to import one cell that is counting a # of devices being issued for multiple locations in our organization. You got a like from me and a new subscriber!!

[@chefjamz]

Thank you so much for sharing this video. I was working on a project and this condensed things so much for me. Mucho thanks.

[@LeilaGharani]

Glad it was helpful!

[@ainulmard]

thank you. it helps a lot for my intern task ^^

[@touslesjours3242]

😍 You're the best! Thank you!

[@irenesantos9737]

Thank you for this video, you don't have any idea how you helped me Leila 😭❤❤❤❤❤

[@Avi8053]

You are honestly the best!

[@mariagratielaifrim3859]

Great, thanks!

[@chaddemeuse6760]

Leila - do you have any recommendations for importing larger datasets inside of the query function? I keep getting #error, results too large.

[@user-mi5ge9go9l]

Thank alot, I am excited for Query function

[@mayank265memories]

Leila You are an inspiration!

[@JohnFPederson]

I love your channel!

[@FinalSalvation1]

Practical. Thank you.

[@MrBluebirds22]

This was very helpful. Thanks a lot.

[@voiladisiotso]

Just exaclty what I needed for my reports ❤️

[@MrMosoani]

Aside from this what other functions or formulas do you use for reports?

[@kaunaszalvaris8929]

Is there a difference between the original table (with formulas vlookup, sums, data validations) and the weight of the imported table? Thank you

[@halfmehalfyou3565]

You are amazing! Thank you.

[@christophepotin8175]

Thanks a lot for your video. it was very helpful to progress in my work.

[@MichaelSmith-hf2kh]

Thank you Leila, great tutorial, to the point *****

[@vinvoxhobbies5055]

This is amazing!

[@mounir9311]

For those with a parsing error, even though everything seems correct. Make sure you use the good parameters separator symbol. For me, instead of being a " , " I have to use a " ; " (google sheet URL;nameOfTheSheet!zone to import). It depends on your Google Sheets regional settings. Also, if the name of your sheet has space in it, make sure to surround it with ' '

[@beatriztercero7706]

Thank you so much!

[@AlexAryaBali]

Thank you!!!!!!!!!!!!!!!!!!

[@MasterpisopArtZ]

thanks a lot

[@marekbuzarewicz4465]

It's exactly what I need!

[@sarahzulfa]

Thank you very much!

[@user-ey8vg4bo6r]

Thanks, that's what I need to do what I wanted.

[@giorgiomath]

Very Helpful Video. Thank you very much

[@sivasankarshakthivel5852]

Thank you so much for the detailed explanation.👍

[@LeilaGharani]

Glad it was helpful!

[@anmol971]

Really a very helpful information is provided in a very simple way .

[@Billetus]

THANK you Leila!

[@MarwanAShareef]

Special thanks to you for your hard work.... Please go ahead

[@FoxyArcher17]

Leila, thank you for the great tips. It saves me a lot of hours.

[@a1wsq]

Thanks, excellent tutorial.

[@kellyehlers]

You are amazing! You just saved me hours of work in he future

[@NIJHUMNILOY]

Thanks for your Video.

[@HusseinKorish]

Thanks Leila ... this is very usefull.

[@DaveStewartLondon]

Holy sheet! That's great.

[@marksilen2652]

Hi @Leila. Fantastic video !!! Is there a way to import cell formatting using importrange?

[@faisalrafique2336]

Amazing method to teach. thank you

[@chrism9037]

Thanks Leila, this was great!

[@LeilaGharani]

Thank you, Chris! I hope it will come in handy :)

[@Sapporo979]

oh my god. very helpful. thanks a lot leila!

[@user-sk3km8ps5o]

Thanks a lot.

[@farhanabid5438]

Your videos are 200% helpful. Anyone can easily master in excel and google sheets after just following you only. From Pakistan 💗

[@LeilaGharani]

Glad to hear that 😊

[@matrixsecurityandautomatio427]

Very informative. Thanks dear for posting such an information

[@RolisKK]

Thanks Leila, amazing video tutorial. I have a question: do the imported data and the data in the original file take up the same space? I mean, does this data load my computer equally (when there will be a lot of data)

[@drbahsha]

Tq so much.....really appreciated!!! I learn a lot from your KZbin Videos....

[@nithyananthan_s09]

Really useful!!

[@go2mac]

I love it, solved the problem thanks thanks

[@LeilaGharani]

Glad to hear it!

[@kagawad_pimienta]

Hey Leila, as always thanks for the help. However, I'm still having issues when making the file dynamic.

[@charlesmurray3255]

Another great video . I'm looking forward to the promised query video now.

[@LeilaGharani]

Coming soon!

[@Ibranars]

I like it after hard work , now it became easy

[@gandhicardworld933]

Thanks to you very very much for this very very helpful video

[@Norlen94]

Hi Great tutorial and many thanks for the info. I have followed your dependent drop down list and incorporated it in my workflow. Is it possible to include both a dependent drop down list and make it searchable as well? For context, I have 1 column which is the Type and another column next to it will be the dependent list based on the type choose. But the issue here is that some list are really long and users have to scroll a lot to find the right drop down. The data validation for the Type and the dependent list applies for both columns and not single cell. I have already added the dependent list based on your videos (Thanks 😀) but I now want to make the list searchable.

[@ahmedabbas802]

Thankyou so much Leila for making this video. You just saved me from embarrassment

[@LeilaGharani]

Glad I could help!

[@marianogreco6687]

Thanksss!!!

[@bristolzoo845]

Genius! True experience)))

[@dovids.greenberger435]

You can also wrap each imported range in a filter function that filters blank rows. Works like a charm 😊 ={filter(IMPORTRANGE(F1,"A1:D5"),IMPORTRANGE(F1,"A1:A5") "");filter(IMPORTRANGE(F1,"sheet2!A1:D10"),IMPORTRANGE(F1,"sheet2!A1:A10") "")}

[@AmeenaAbubakr]

love your video

[@mathhelperka7687]

This is brilliant! I am extremely thankful for this video!

[@LeilaGharani]

Glad it was helpful!

[@isaganiaguinaldo6785]

This is so helpful, may I ask if I can get the sum of multiple IMPORTRANGE into a cell of another google sheet? thanks a lot

[@tedsterrett7204]

Your videos are captivating and very interesting, thank you!

[@LeilaGharani]

Glad you like them, Ted!

[@LeilaGharani]

Glad you like them!

[@skyblue2394]

Thank you so much. As I would like cells to be appear as image (i.e., same as camera tool function in Excel), may I know how can I do that?)

[@nadeemmalik8031]

Fantastic Leila. Have a Merry XMAS and Happy New Year.

[@LeilaGharani]

Thank you! You too!

[@BACMANPIRRO]

Hi there! Is it possible to apply Importrange in order to import a single cell-value from a file to another? Many thanks!

[@Augusto_SilvaN]

You are incredible

[@IbongAdarnaKaEchosan]

Hello its my first time and your Tutorial is very straightforward, just 1 question please where did you get the A1:D10 range? is it from the sheets you're trying to import or the Range where you want to have Data on?

[@mohammadashiq9996]

this is a magic as usual an other surprise thank you leila.

[@LeilaGharani]

Glad you like it!

[@liamaduma2519]

Hi! do you know how to count specific text from other worksheets that the column fill by import range data?

[@mmkh_art]

Thanks. :)

[@tylermoml2214]

I love this!!

[@LeilaGharani]

Glad to hear that :)

[@Augusto_SilvaN]

Thanks 🇧🇷