IMPORTRANGE Function in Google Sheets | Multiple Sheets

Подписаться 2,6 млн

Просмотров 354 тыс.

50% 1

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

Опубликовано:

10 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 312

@LeilaGharani 5 месяцев назад

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

@anishyadav4747 4 месяца назад

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

@cindybaxter4007 2 года назад

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 3 года назад

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

@michellepancho6369 3 года назад

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 3 года назад

You're very welcome, Michelle!

@emilykohmy 2 года назад

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

@brianmichaelmedia 5 месяцев назад

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.

@patrykjankowski5095 Год назад

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

@neerajnandan3351 2 года назад

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

@TylerStanczak 3 года назад

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

@karenum9696 Год назад

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

@MarcCastellsBallesta 3 года назад

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

@LeilaGharani 3 года назад

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

@kevinm.8682 2 года назад

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

@DeniseL-yy7yj 3 месяца назад

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!

@sc100200090 3 года назад

Thanks Leila! Source worth enough for sure!

@VichiBala 2 года назад

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

@EanLee 3 года назад

Can't wait for the next video!

@BeUCoach 2 года назад

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

@panosrozos3341 Год назад

Well done! Thanks!

@Avi8053 3 года назад

You are honestly the best!

@ranjannair3053 2 года назад

Thank you for sharing this. It was much needed

@muhammadyoussef9138 3 года назад

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. :)

@agnesrambling 3 года назад

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

@touslesjours3242 2 года назад

😍 You're the best! Thank you!

@camillesanjose7723 3 года назад

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

@LeilaGharani 3 года назад

You are so welcome!

@apinyaw1331 Год назад

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

@AccountingandQuickbooks 3 года назад

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

@markseguin2544 3 года назад

This will be very useful. Thank you again 😊

@jgproductdesign 2 месяца назад

This is so great!

@user-mi5ge9go9l 3 года назад

Thank alot, I am excited for Query function

@FinalSalvation1 Год назад

Practical. Thank you.

@mariagratielaifrim3859 5 месяцев назад

Great, thanks!

@mayank265memories 3 года назад

Leila You are an inspiration!

@ainulmard 2 месяца назад

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

@MichaelSmith-hf2kh 2 года назад

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

@sarahzulfa 3 года назад

Thank you very much!

@halfmehalfyou3565 3 года назад

You are amazing! Thank you.

@MrBluebirds22 Год назад

This was very helpful. Thanks a lot.

@Ivanslav1 2 года назад

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

@LeilaGharani 2 года назад

Happy to help!

@irenesantos9737 Год назад

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

@MarwanAShareef 3 года назад

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

@Billetus Год назад

THANK you Leila!

@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!

@upahlokal469 9 месяцев назад

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 9 месяцев назад

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. 💪

@patrickschardt7724 3 года назад

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

@marekbuzarewicz4465 2 года назад

It's exactly what I need!

@giorgiomath 2 года назад

Very Helpful Video. Thank you very much

@drbahsha 2 года назад

Tq so much.....really appreciated!!! I learn a lot from your RU-vid Videos....

@Sapporo979 11 месяцев назад

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

@a1wsq 2 года назад

Thanks, excellent tutorial.

@HusseinKorish 3 года назад

Thanks Leila ... this is very usefull.

@NIJHUMNILOY 3 года назад

Thanks for your Video.

@vinvoxhobbies5055 Год назад

This is amazing!

@christophepotin8175 3 года назад

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

@voiladisiotso 3 года назад

Just exaclty what I needed for my reports ❤️

@MrMosoani 3 года назад

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

@kellyehlers Год назад

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

@user-ey8vg4bo6r 11 месяцев назад

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

@MaxTheDog167 2 года назад

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!!

@go2mac 3 месяца назад

I love it, solved the problem thanks thanks

@LeilaGharani 3 месяца назад

Glad to hear it!

@DaveStewartLondon 2 месяца назад

Holy sheet! That's great.

@chrism9037 3 года назад

Thanks Leila, this was great!

@LeilaGharani 3 года назад

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

@user-sk3km8ps5o 5 месяцев назад

Thanks a lot.

@JohnFPederson 6 дней назад

I love your channel!

@gandhicardworld933 2 года назад

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

@matrixsecurityandautomatio427 Год назад

Very informative. Thanks dear for posting such an information

@nithyananthan_s09 3 года назад

Really useful!!

@EKHeatingAir 7 месяцев назад

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 7 месяцев назад

Glad it was helpful!

@sivasankarshakthivel5852 5 месяцев назад

Thank you so much for the detailed explanation.👍

@LeilaGharani 5 месяцев назад

Glad it was helpful!

@FoxyArcher17 Год назад

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

@faisalrafique2336 Год назад

Amazing method to teach. thank you

@diegofreitas4850 3 года назад

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 3 года назад

Hope it will come in handy.

@anmol971 Год назад

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

@charlesmurray3255 3 года назад

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

@LeilaGharani 3 года назад

Coming soon!

@mathhelperka7687 9 месяцев назад

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

@LeilaGharani 9 месяцев назад

Glad it was helpful!

@Ibranars 8 месяцев назад

I like it after hard work , now it became easy

@marianogreco6687 2 года назад

Thanksss!!!

@bristolzoo845 3 года назад

Genius! True experience)))

@AmeenaAbubakr 10 месяцев назад

love your video

@wowhallo 3 года назад

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.

@dovids.greenberger435 3 года назад

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") "")}

@Augusto_SilvaN 2 года назад

You are incredible

@ahmedabbas802 Год назад

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

@LeilaGharani Год назад

Glad I could help!

@marksawesomeadventures 2 года назад

I LOVE the way you Explain things you are SO Smooth :D

@LeilaGharani 2 года назад

Oh thank you!

@mmkh_art Год назад

Thanks. :)

@mohammadashiq9996 3 года назад

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

@LeilaGharani 3 года назад

Glad you like it!

@nadeemmalik8031 3 года назад

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

@LeilaGharani 3 года назад

Thank you! You too!

@michaellucas7177 3 года назад

You are awesome 🤗🎀❗❗

@tylermoml2214 3 года назад

I love this!!

@LeilaGharani 3 года назад

Glad to hear that :)

@edcooper1471 2 месяца назад

Thanks!

@LeilaGharani 2 месяца назад

Thank you!

@farhanabid5438 3 года назад

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

@LeilaGharani 3 года назад

Glad to hear that 😊

@tedsterrett7204 3 года назад

Your videos are captivating and very interesting, thank you!

@LeilaGharani 3 года назад

Glad you like them, Ted!

@LeilaGharani 3 года назад

Glad you like them!

@Augusto_SilvaN 2 года назад

Thanks 🇧🇷

@sathaasivamnandakumar7576 3 года назад

Thank you Leila

@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 11 месяцев назад

Thank you so much!

@AlexAryaBali 11 месяцев назад

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

@MasterpisopArtZ 11 месяцев назад

thanks a lot

@kurumitokisaki4844 Год назад

Omg thank you so much maam

@chaddemeuse6760 2 года назад

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

@marksilen2652 Год назад

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

@RolisKK 3 года назад

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)

@user-yb5od8sg6p 6 месяцев назад

Leila you rock...this video saved my day. No, it saved my month. I'm still working my way through your Udemy course, so I don't know if this topic is covered there, but thank you for also uploading free material to RU-vid! I'm so freakin happy right now.

@LeilaGharani 6 месяцев назад

Glad it was helpful!

@IbongAdarnaKaEchosan 2 года назад

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?