I am tired of comment bad on TH-cam, 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.
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 :)
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!
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.
This is probably, if not the most, useful google sheets tool that I'll be using from now on for report-building. Somehow, managers don't love pivot-table based reports. So this is a pretty handy idea when combined with the "unique" function to bring rows from a flatfile and process accounting reports.
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!
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!
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.
Where have you been all my day today? Been struggling with this all day and you literally solved it for me within minutes. I've spent hours watching unhelpful videos in every language under the sun (smh). Thanks man.
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!
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.
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.
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 ?
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.
Thank you very much! This is very helpful. I was able to resolved my concern. Can you use this if the data that I will import comes from a merged cells?
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!
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
Thank you, but I have some questions want to ask you, is that available for formatting syncing between Second sheet to main sheet 😅, kindly make a tutorial for that yet, I don’t know how 😅
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
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!
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
Good tutorial, thanks! Is there a way to query dynamically from an imported list of URL's vs going to cut and paste from each source worksheet that needs to be queried? I have a script that imports the URLs of reports generated in a given year. Can that list of URLs be queried dynamically to obtain information from the same sheet in each worksheet? Thanks in advance.
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.😊
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.
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.)
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!
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. 🙂
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.
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.
I am tired of comment bad on TH-cam, 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.
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 :)
This makes me so happy! It’s why I do it! Sorry for the delay in response!
Dude, this was the best google docs tutorial I've ever seen. I'm making some SICK accounting spreadsheet...!!!!!!!
Awesome
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!
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.
This is probably, if not the most, useful google sheets tool that I'll be using from now on for report-building. Somehow, managers don't love pivot-table based reports. So this is a pretty handy idea when combined with the "unique" function to bring rows from a flatfile and process accounting reports.
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!
I have been looking for 2 days for this exact information! Thank you so much! This is a huge help!!!!
Awesome!
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!
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.
Where have you been all my day today? Been struggling with this all day and you literally solved it for me within minutes. I've spent hours watching unhelpful videos in every language under the sun (smh). Thanks man.
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!
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.
Just start learning about all formulas. This contents is very helpful. Still have room to growth💪🏽. Going for more.
I'm making an inventory management spreadsheet. Your tutorial has helped me a lot, thank you! Keep it up!!
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.
Love hearing it!
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!
This was absolutely amazing and well explained in a way I haven't seen (or heard) before 👍🏼👍🏼 great job!!! 👏🏼👏🏼
Thank you! After hours of looking around, this is what I needed!
Brilliant! This was so helpful for combing data from multiple sheets.
Couldn't hit subscribe quick enough! Great tutorial!
Very coool!!!!!!! and you explained it very clearly. Im gonna start using IMPORTRANGE right away! Thank you!
Excellent job - I was specifically looking for a concise method for the import range function. Thank you!
I wathced several videos and yours is giving the best info for me today.
Thanks
Awesome glad to hear
Loved this explanation! It was easy to follow! Please keep them coming!
exactly what is needed in the world of spreadsheets TY!
Superb explanation and demo of both QUERY and IMPORTRANGE functions. Appreciated!
You explained this very well and clear. You're a great teacher... Thank you for this video
Wow! Thanks for the kind words!!
Good stuff my man! Basically my data teacher here.
Thanks a bunch!
Thanks for sharing your knowledge, and helping me Work Smarter Not Harder
Thank you, I was looking for these exact formulas!
This was great! Easy to follow. I will be referring back to this! Subscribed!
Exactly what I needed! Thank you! Subscribed and watching other videos now!
Awesome to hear! Let me know if you have any questions!
hey, thanks for this. i'm doing a trial run for a job application and this is helpful.
Thank you! I got the data I wanted to because of your easy steps guide.
Excellent Tutorial on both Query and importrange, Thanks :)
You're a great teacher! Thank you for your time invested to help us all :)
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 ?
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.
Awesome tutorial!
Thank you very much! This is very helpful. I was able to resolved my concern. Can you use this if the data that I will import comes from a merged cells?
Thank you, it helped me alot. God bless ya. Love from Bhutan
This video is amazing, thank you for taking the time to explain!
This was right at my level. Thank you!
Very good video! A solid cornerstone for further development!
Thank you for simply this formula👍👍 Good job.
Great information easy to understand as it was clearly explained. This will be useful for me to use.
Simple and clear explanation. Sweet
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!
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
Thank you. other tutorials left me short of successfully using importrange fn. Now I can do it.
Awesome! That’s why I do what I do.
Thank you for this video! This is just exactly what I want to know.
Great work. I was trying the same thing without success. Thanks for the video.
Awsome man you have actually saved my time.. God bless you❤
Merci , ce tips m'est très utile !!
Thank you, but I have some questions want to ask you, is that available for formatting syncing between Second sheet to main sheet 😅, kindly make a tutorial for that yet, I don’t know how 😅
I worked with these two functions but never did I joined two ranges from different sheets in 1. Good stuff !
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
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!
Thank you for this! Helped me out massively 🙂
I definitely learned something from the video.
Amazing video. Thanks from Bangladesh.
Brilliant video man. Loved it!!
Amazing details! Thank you!
Thanks a lot! Great tutorial, really solved my needs :)
Great job! Very helpful! Good luck!
Thank you! very clear explanation.
Great vid! Excited to apply this at work 😊
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
Thank you
It's very helpful
Save my time
Worked well for me Thank You!!
Great video! Thank you for the information
Good tutorial, thanks! Is there a way to query dynamically from an imported list of URL's vs going to cut and paste from each source worksheet that needs to be queried? I have a script that imports the URLs of reports generated in a given year. Can that list of URLs be queried dynamically to obtain information from the same sheet in each worksheet? Thanks in advance.
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.😊
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.
Thank you! I'm going to use this to create a budget for the League of Women Voters in my area.
Very useful video! Thanks!
Learned a ton!
Thanks alot for your great great explanation
Very helpful. I really love it. Thank you
Thank you I was looking for adding two or more importranges as one is not enough when you have huge data 50k+ rows
Thanks for this awesome guide!
great lesson! i want to create dynamic atendants lists to diff workshops and days based on bookings
This video was very helpful thank you
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.)
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!
Such a relaxing voice 🙂
very good tutorial my friend, thanks!
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. 🙂
Super easy to understand
Your awesome thank you for sharing your knowledge 🤓😎
Thanks for the great video. Quick question, why do we add a 1 in the last query you wrote?
Thanks for your help!
Great video, thanks!
Thank you very much, I followed the same and it worked
Awesome! Love it!
thanks man! this is helpful, can you let me know if I can edit from the result of the query so the original would be updated as well?
Unfortunately it is not possible to edit the cells within a query. There might be another way though. What is it that you need to accomplish?
You can always change the original data to get the changes done.
@@whyworksmarternotharder Hi, this is related to his question. How to trace back the source of the data found after import+query?
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.
Thanks For This. Please advise, how to remove blank rows after set query function with importrange.
Great Tutorial. Good job.
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.