Google Sheets Import Range | Multiple Sheets | Import Data | With Query Function

Learn to use the Import Range and the Query function simultaneously while importing multiple Ranges. The import Range function in Google Sheets is a powerful tool that doesn't exist in Microsoft Excel. It allows you to import a range of cells from one Google Spreadsheet into the spreadsheet you are currently working on. The Query function allows you to filter through that information so that you have a nice clean looking spreadsheet when you are all done.
Here are some other videos you might like:
• Google Sheets Query Function | Powerful | No Experience Necessary: • Google Sheets Query Fu...
• Conditional Formatting based on another cell | Google Sheets: • Conditional Formatting...
• VLOOKUP In Google Sheets: Tutorial: • VLOOKUP In Google Shee...
Thanks again for watching. If you found this video useful, please consider supporting my channel by subscribing, and sharing my content. Doing both will get it out there for more folks to learn from.

[@RHSNicholson]

This was exactly what I needed! I was able to use your tutorial and combine it with a previous trick I learned to get data and display it in the order I needed. Now it will take me seconds to update info each week rather than half a day!

[@kaylone.7366]

I landed here after watching some of your budgeting videos. You get right to the point, explain things well, and make it easy to follow along. I have no idea how I might use this, but I thought it would be useful to know about the functionality of the query function since you use it in those other video. Thank you so much for helping us work smarter not harder.

[@dawnonanian9886]

This is excellent. I watched the first few minutes and found exactly what I needed to do to track changes in payments for items I am trying to get paid off. My brain was thinking about ranges and dynamic links, and not sure where to start, but this was so much easier! Now I can enter the payment in my check register tab and won't have to adjust the payment in my loan tracking tab each time I make an additional payment or change the amount. Thank you!

[@rodtompkins]

Great tutorial! Your delivery is direct and relaxed at the same time. I came looking for an importrange refresher and you covered the importrange/query combo which I'd not previously done. I'm a big fan of using the Where parameter in the query to get rid of those blanks rows instead of specifying a range in the import function. That way you're covered if there are any changes in the imported data sets.

[@salmanbinabduljabbar3651]

I am tired of comment bad on KZbin, Coz most youtubers have no idea how to solve actual problem of viewer. But hats off to this man. Amazing knowledge and very nice Video. Thank for it.

[@ChaosBarnaby]

Excellent video, and the way you progressively laid out the steps so that they built on the preceding knowledge of the last step was masterful. Great teaching method. Extremely helpful!

[@tcallantine9944]

THANK YOU! I created several sheets (with Date/Time macro & Vlookup student info) for scanner stations to scan High School and Middle School student id's (barcodes) as they come to school, then your ImportRange and Query functions helped me establish a Master Sheet for a full attendance listing. - you made a secondary school secretary's job much easier. I'm a subscriber now :)

[@whyworksmarternotharder]

This makes me so happy! It’s why I do it! Sorry for the delay in response!

[@andrewnelson2603]

This was tremendously helpful. In addition to the value of the content, your manner and way of explaining is concise and relevant. Thanks for this!

[@JSark-by2ts]

Excellent job - I was specifically looking for a concise method for the import range function. Thank you!

[@summer7859]

Superb explanation and demo of both QUERY and IMPORTRANGE functions. Appreciated!

[@renelangarica5898]

I really like your tone and flow of your voice, makes understanding the process easier... not boring, yet had my attention. Can you show how to use Vlookup up and how to compare two lists and update the new data from another into one updated sheet. I see a lot of simplified Vlookup up, yet in the real world... I find myself doing things the long way and realizing when i'm almost done that I could of done it easier and quicker!

[@grandmaraps]

I'm trying to teach myself Google sheets but I think this was way above my head. I might have to come back to it down the road when I get to that level. But I will subscribe to your channel, you have great other videos that I can currently learn from.

[@ryanmalec3119]

Thank you! After hours of looking around, this is what I needed!

[@user-ij8bp4ke4d]

I'm making an inventory management spreadsheet. Your tutorial has helped me a lot, thank you! Keep it up!!

[@kayleeluft3621]

You're a great teacher! Thank you for your time invested to help us all :)

[@lluiszardoya]

Dude, this was the best google docs tutorial I've ever seen. I'm making some SICK accounting spreadsheet...!!!!!!!

[@whyworksmarternotharder]

Awesome

[@InspiringThings101]

Good stuff my man! Basically my data teacher here. Thanks a bunch!

[@roxannarivera2608]

Just start learning about all formulas. This contents is very helpful. Still have room to growth💪🏽. Going for more.

[@administracionbienba8820]

Very coool!!!!!!! and you explained it very clearly. Im gonna start using IMPORTRANGE right away! Thank you!

[@keabogada]

You're an awesome tutor! I hope you'll have time exploring the mobile app version of the Google sheet and share us some tips how to effectively use it and maybe some tricks

[@cindyfillhart6197]

Loved this explanation! It was easy to follow! Please keep them coming!

[@christianpreciado74]

exactly what is needed in the world of spreadsheets TY!

[@GilAnspacher-Faria]

Brilliant! This was so helpful for combing data from multiple sheets.

[@user-nf3es2ei8f]

Excellent Tutorial on both Query and importrange, Thanks :)

[@rutvikpatel7640]

Thank you, I was looking for these exact formulas!

[@samcasey6661]

Hey! Love the Vid! Could you explain how to complete more complex query functions? For example, import based on a pre selected factor (location), a pre determined number of rows and ranked by cell value? Thanks!

[@dreeeaaamiiing]

hey, thanks for this. i'm doing a trial run for a job application and this is helpful.

[@damongonzaga658]

I wathced several videos and yours is giving the best info for me today. Thanks

[@whyworksmarternotharder]

Awesome glad to hear

[@jamesng5781]

A great video this is! Just want to ask whether it is possible to make import range more dynamic by importing only certain rows if only that rows contain certain data ?

[@joniwittwer7195]

This was great! Easy to follow. I will be referring back to this! Subscribed!

[@anamariabazzani69]

This video is amazing, thank you for taking the time to explain!

[@mikekimmel9744]

This was right at my level. Thank you!

[@maggieyap763]

Thank you! I got the data I wanted to because of your easy steps guide.

[@gigsconnect8517]

Simple and clear explanation. Sweet

[@dakshbhatnagar]

I worked with these two functions but never did I joined two ranges from different sheets in 1. Good stuff !

[@danlightfoot6592]

Thank you for this! Helped me out massively 🙂

[@sonamdorji8812]

Thank you, it helped me alot. God bless ya. Love from Bhutan

[@davidbennett4199]

Thank you. other tutorials left me short of successfully using importrange fn. Now I can do it.

[@whyworksmarternotharder]

Awesome! That’s why I do what I do.

[@trixieayuco8103]

Great vid! Excited to apply this at work 😊

[@jilchurchaust8776]

You explained this very well and clear. You're a great teacher... Thank you for this video

[@whyworksmarternotharder]

Wow! Thanks for the kind words!!

[@Lynda525]

Thank you for simply this formula👍👍 Good job.

[@manasbanerjee4462]

Great work. I was trying the same thing without success. Thanks for the video.

[@ReR7474]

That’s impressive. I have a soccer ranking table, and as it’s dynamic as each team moves up or down according to their wins/loses/draws. Will *query* be my ally if I want to sort each’s team points on a column or row after watch match for the season the dynamic ranking table on page 1? Or is there another filter be better? Thanks in advance

[@aivarsnorenbergs477]

Very good video! A solid cornerstone for further development!

[@alvinwong9161]

Hi, your video is really useful. I got a question, when I upload the excel files from the PC to the google drive, is it possible to transfer the data of the excel file in the drive (xlsx) that I have uploaded to the Google Sheets. Technically, the progress seems like PC excel files xlsx > Google Drive excel files > Google Sheets. I would like to use the formula to get the data from the excel file to the Google sheets, thank you.

[@Mrswatkins2u2]

I am building a timelog and billing application for my niece's service based business, it will build client invoices and payroll estimates. What I've learned here will enhance the program. Thank you.

[@whyworksmarternotharder]

Love hearing it!

[@jenniaguirre499]

Thanks for sharing your knowledge, and helping me Work Smarter Not Harder

[@jeffreytonacao6571]

Thank you for this video! This is just exactly what I want to know.

[@paritoshmkverma7061]

Thank you It's very helpful Save my time

[@panchalchirag22]

Hi, Thanks for the import range function specifically, I'm looking to put script with trigger in master file and take input via another file with people having edit access to prevent copying. I was worrying about how powerful and frequent is import range? Does it require me to open file to update the changes? I'm looking for data of not more than 30 row by 15 columns

[@user-nc9ix1xz1e]

Great information easy to understand as it was clearly explained. This will be useful for me to use.

[@nilyumtextile3530]

Thanks for the video! Quick question! How can i exclude some of the coloumns when doing importrange ? for example i want to export coloumn A - D and F and don't want to export column B-C and E ? When i put ',' between columns instead of ':' I get an error. :/

[@benzerfernando5543]

Great video and very easy to follow, do you have one to create a form to enter data into a database sheet and import the records in a row based on a word entered into a cell on another sheet?

[@TomCure]

Thanks for the video! Question... Once you have everything imported and you make a change to the 2019 and/or 2020 spreadsheet will the change show up in the master sheet? Thanks again!

[@JohnMacKayschool]

great lesson! i want to create dynamic atendants lists to diff workshops and days based on bookings

[@muhammadaliraja6930]

Worked well for me Thank You!!

[@pablougalde3564]

Thanks a lot! Great tutorial, really solved my needs :)

[@emurrayjr]

Exactly what I needed! Thank you! Subscribed and watching other videos now!

[@whyworksmarternotharder]

Awesome to hear! Let me know if you have any questions!

[@pini5076]

Thank you! very clear explanation.

[@ishrathyarkhan9946]

Thank you, that really saved lot of time. I have a question, the sheets from where I am importing Data have some formatting (for eg. some cells are highlighted with colors). I am unable to get that formatting after importing. Could you please help.😊

[@prahlad8]

Thank you I was looking for adding two or more importranges as one is not enough when you have huge data 50k+ rows

[@derek032784]

Great Tutorial. Good job.

[@MarcoReyes-zb7xl]

Thanks for this awesome guide!

[@jessecruz7072]

Awesome tutorial!

[@cherrycruz597]

Is there a query function/formula that immediately consolidates new sheets (and previously existing sheets) into the masterlist? Or does the formula need to be tweaked every time a new sheet is made?

[@elisehill992]

I appreciate your excellent delivery of information, thank you. This video was very helpful in introducing me to queries. It also helped me with importrange. I do however still have a need to find a solution for vlookup for multiple worksheet-tabs inside a different sheet. The option to combine tabs into one isn't quite suitable and so I will continue searching for an answer, it is possible I will go with your combine option if i cant find something else since it would likely work. Thanks for an excellent video, you made it very clear and easy to remember.

[@RolisKK]

Not quite what i am looking for but i hope you will help me to solve my problem. I need to import a dynamic table. Depth this table varies from a few to a few tens of rows, and there is another text at the bottom of the table. How to make that text rise (if the table is small) or descend (if the table is larger) at the bottom.

[@SumitKumar-eh4hz]

Awsome man you have actually saved my time.. God bless you❤

[@anmolagnihotri3130]

Brilliant video man. Loved it!!

[@GermanLarez]

very good tutorial my friend, thanks!

[@aliemmanuel8233]

This video was very helpful thank you

[@samiulsami5280]

I definitely learned something from the video.

[@ultimatespectator137]

Awesome Vid. Make some full course on Excel power query and Google Sheets Query Functions.

[@alexkrem9067]

Great job! Very helpful! Good luck!

[@HussainAbdullahTofa]

Amazing video. Thanks from Bangladesh.

[@johneze3409]

Very helpful. I really love it. Thank you

[@liamaduma2519]

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

[@jamesstaring7051]

Great video, thank you. How can I create an query/importrange that updates to the next empty row? I want to create an import function that doesn't overwrite previous data...thanks for any help you can provide!

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

[@Ivanslav1]

Great video! Thank you for the information

[@cavatina82]

Thanks for the great video! I am wondering if you know a way or command to import the entire content of a tab, with the same original formatting & formulas maintained, 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 cells (i.e. no formatting, no formulas, etc.)

[@howdid]

Great Video. I want to import rows from multiple sheets to a summary sheet, but do not know how many rows will be in each sheet as they are developed. Is there some way you can write into the formula to only import rows (or parts of rows) that have data in them? need to avoid all of those blank rows in the summary sheet. Hope this makes sense. Thanks.

[@ithelpdeskparker7907]

Thanks For This. Please advise, how to remove blank rows after set query function with importrange.

[@ArifHussain-le8gh]

Thank you very much, I followed the same and it worked

[@whyworksmarternotharder]

Awesome! Love it!

[@melissacoconut]

Such a relaxing voice 🙂

[@jeetu-personal3684]

Great tutorial.

[@harrychhina8336]

Great Video. Thank you

[@UGAly08]

New Subscriber as of today. Your video may be 2 years old, but I happen to find it and loved your simplicity approach. QUICK question, I was looking for how to import from multiple "web sheets" or maybe "web tables". Meaning a sight may have a table of 50 rows of data, but then will have 20 or more links to show "next page of 50 rows" What is the most efficient way to import that much information? The site i want o pull from has 98 "pages" a grand total of 4857 rows of information. 🙂

[@jackiehall3167]

Thanks for your help!

[@krishnasadasivan4011]

Thanks for the great video. Quick question, why do we add a 1 in the last query you wrote?

[@dannyd7947]

Can you sum entire row column b with same value on column a using vlookup importrange?

[@user-kv8pf4fp3i]

Merci , ce tips m'est très utile !!

[@guspreci4283]

Great Work

[@Xrplaws]

Hi, is it possible to sum numerical data only, using the import range formula using different work sheets? Like (importrange +importrange)

[@glorielenacr]

Loved it! thanks!

[@DiegoVasquez-mt4dw]

Super easy to understand

[@briansaizi1984]

Super helpful, thanks man

[@tristanturner]

Learned a ton!

[@gamexiscrest1481]

Hi. thanks for this tutuorial. can you please explain more for import range formula which import formating too. In some sheets its working fine but in some sheets its giving an error "Array result was not expanded because it would overwrite data in B1." as i have erased all data from B1 column but not solved the problem , then same error occurs for column C1.

[@user-xb3cs4iw7t]

Amazing video! huge help thanks