IMPORTRANGE Function in Google Sheets | Multiple Sheets

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

[@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.

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

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

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

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

[@DevanshuJain-n4n]

A great teacher, with fantastic teaching skills. Respect from INDIA. 🙂

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

[@paulahierzi2911]

Helped me out a lot!!!

[@emilykohmy]

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

[@Ivanslav1]

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

[@LeilaGharani]

Happy to help!

[@edcooper1471]

Thanks!

[@LeilaGharani]

Thank you!

[@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 😊

[@JoshAllen-l8u]

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 KZbin! I'm so freakin happy right now.

[@LeilaGharani]

Glad it was helpful!

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

[@karenum9696]

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

[@ahmedabbas802]

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

[@LeilaGharani]

Glad I could help!

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

[@patrykjankowski5095]

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

[@mayurkhatri1048]

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

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

[@HG-pp4jg]

Thanks!

[@LeilaGharani]

Thank you! Glad you found this helpful.

[@vivigr92]

Thanks

[@LeilaGharani]

Thank you, James!

[@RachelWonnacott]

I watched so many videos, your formula worked!

[@TylerStanczak]

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

[@neerajnandan3351]

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

[@irenesantos9737]

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

[@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.

[@bob.bobman]

Exactly what I was looking for! Thank you!

[@MCS-b9b]

I love your tutorials, I'm learning so much from your channel, thank you so much for sharing. I like the way you explain things, very simple to understand, direct, and concise. Your voice is also very soothing! You enunciate the words so well, which makes the lessons easy to understand. The color theme and visuals also make the videos very easy on the eyes.

[@LeilaGharani]

Thank you so much!

[@agnesrambling]

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

[@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.

[@drbahsha]

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

[@kevinm.8682]

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

[@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.

[@kellyehlers]

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

[@VichiBala]

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

[@anmol971]

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

[@ranjannair3053]

Thank you for sharing this. It was much needed

[@touslesjours3242]

😍 You're the best! Thank you!

[@najmehnazari-h2y]

problem solved, thank you very much. you made it sound so simple

[@najmehnazari-h2y]

Looking forward for your next video on Query

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

[@mathhelperka7687]

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

[@LeilaGharani]

Glad it was helpful!

[@joaoluna8980]

Is this the only Google sheets video from you? There's no playlist for Google Sheets on your channel, one microsoft. I am asking because you're one of the best instructors I found so far, congrats and Thank you!

[@LeilaGharani]

Probably have too many playlists already :) Here is the link: kzbin.info/aero/PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu

[@joaoluna8980]

@@LeilaGharani Thank you :)

[@Ibranars]

I like it after hard work , now it became easy

[@BeUCoach]

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

[@Tunakens]

Great video! I needed to do exactly this and this is the only video with a solutión.

[@sivasankarshakthivel5852]

Thank you so much for the detailed explanation.👍

[@LeilaGharani]

Glad it was helpful!

[@marksawesomeadventures]

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

[@LeilaGharani]

Oh thank you!

[@mayank265memories]

Leila You are an inspiration!

[@Sapporo979]

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

[@matrixsecurityandautomatio427]

Very informative. Thanks dear for posting such an information

[@AccountingandQuickbooks]

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

[@مهندمواس-ه6س]

Thank alot, I am excited for Query function

[@MrBluebirds22]

This was very helpful. Thanks a lot.

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

[@MichaelSmith-hf2kh]

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

[@giorgiomath]

Very Helpful Video. Thank you very much

[@ainulmard]

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

[@faisalrafique2336]

Amazing method to teach. thank you

[@Avi8053]

You are honestly the best!

[@faraz-online]

Thanks Leila! Source worth enough for sure!

[@sokinmusiqa]

Uzbekistandan alangali salomlar, sizga rahmat menga katta yordam bo'ldi video

[@JohnFPederson]

I love your channel!

[@gandhicardworld933]

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

[@chrism9037]

Thanks Leila, this was great!

[@LeilaGharani]

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

[@charlesmurray3255]

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

[@LeilaGharani]

Coming soon!

[@HusseinKorish]

Thanks Leila ... this is very usefull.

[@a1wsq]

Thanks, excellent tutorial.

[@MaiAsianboxThaiFood]

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

[@tedsterrett7204]

Your videos are captivating and very interesting, thank you!

[@LeilaGharani]

Glad you like them, Ted!

[@LeilaGharani]

Glad you like them!

[@patrickschardt7724]

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

[@christophepotin8175]

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

[@go2mac]

I love it, solved the problem thanks thanks

[@LeilaGharani]

Glad to hear it!

[@mohammadashiq9996]

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

[@LeilaGharani]

Glad you like it!

[@camillesanjose7723]

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

[@LeilaGharani]

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.

[@AnalyticsWithAhmed]

Thank you for sharing!!

[@LeilaGharani]

Our pleasure :)

[@halfmehalfyou3565]

You are amazing! Thank you.

[@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.

[@Hey_Delight]

Merry Christmas Ms Leila, and your fam and friends!!! 💗💖🎄🎁❄☃️✨🇱🇷❤💙💚 From the 🇵🇭

[@LeilaGharani]

Thank you! Same to you!

[@markseguin2544]

This will be very useful. Thank you again 😊

[@jgproductdesign]

This is so great!

[@marekbuzarewicz4465]

It's exactly what I need!

[@sergheyzaporojanu6872]

Hey! thank you so much for the deepdive about this beautiful function. I am curios if it is possible crosslink 2 files between eachother in the same table. I hope I'm not confusing you too much. Basically I have 2 tables: Questions and Answers. And I just want to connect them together. But the challenge is when the row is inserted in Questions table, I am have misaligned response rows from Question table. I'm really curious about this idea since it would allow me a data exchange without oversharing the file where the Experts are answering the questions. I really appreciate your support!

[@nnkaz1k856]

Excellent. Thank you. I think I'll move to Google spreadsheet from ms excel with your tutorials :)

[@LeilaGharani]

👍

[@DaveStewartLondon]

Holy sheet! That's great.

[@panosrozos3341]

Well done! Thanks!

[@Augusto_SilvaN]

You are incredible

[@FinalSalvation1]

Practical. Thank you.

[@voiladisiotso]

Just exaclty what I needed for my reports ❤️

[@MrMosoani]

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

[@NIJHUMNILOY]

Thanks for your Video.

[@vinvoxhobbies5055]

This is amazing!

[@nadeemmalik8031]

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

[@LeilaGharani]

Thank you! You too!

[@Billetus]

THANK you Leila!

[@nemeraboraya1890]

Hello Id like to see custom pivot table fields and what I can do with it , thanks alot being part of my life you really did help me with my job 😃

[@LeilaGharani]

Thanks for the idea!

[@LeilaGharani]

Noted! I cover this in detail in my course, but I've noted to make a video for YT as well. Thank you.

[@EanLee]

Can't wait for the next video!

[@cavatina82]

Thanks for the great video! I am wondering if you know a way or command to import the entire content of a tab , without using the manual process of "right click > Copy to > ..." Using Record Macro option I would like to "design" a button in my sheet that, when pressed, it would automatically generate a new tab with the content being identical to an external master spreadsheet, but using "Importrange" brings over only the "values" of the original sheet (i.e. no formatting, no formulas, etc.)

[@sarahzulfa]

Thank you very much!

[@serdargn3873]

Hi. Super, as usual.