Google Sheets - Import Data from Another Sheet - Tutorial Part 1

In this video tutorial learn how to import data from another sheet (file, workbook) or multiple sheets in Google Sheets.

[NJHeartHeart]

What makes this so useful is that you go through the simplest formula, then go over issues with the "easy way" and explain how to make the formula better.

[arielmora]

Well presented, well illustrated. I like the approach of starting vanilla and then "What could go wrong?"

[BrayannMota]

Genius. I appreciate the video! Literally just saved me hours.

[camilaliege]

Incredible. Very well explicatory and easy to understand for a newbie like me. Thank you so much

[lluiszardoyaVLOGS]

I love your tutorials man. They are so incredibly helpful!

[brand-image]

Thank you for uploading, very helpful.

[rhionysmael]

This is so helpful and explanation is comprehensive, so easy to understand and follow.

[davidcastaldo]

Thank you for this! Incredibly clear and easy to follow

[maryamahmad]

Phenomenal. You resolved my problem so quickly and easily. Great instructor. Thank you!

[arunarajeev]

Very well explained, solved one of my major issues . Thanks you so much

[MarkGarrettBusinessCoach]

This is such a great video! Thank you for the level of detail you show in building up the formula. Amazing stuff.

I am trying to solve two problems:

Background - I have an order detail sheet that is appended every hour and I have the Date:Time field when it was appended in ISO format 2022-01-20T20:01:57Z

What I need to do is group and sum order data of the last update. The first part I have successfully done but, I am unable to extract ONLY the most recent update.

The second issue, I am running into 1, 000, 000 cells when I make these summary tables in my original API export data table. Is it best to use the ImportRange formula to extract the data into a new sheet and then play with it there?

Happy to hire you if this is a bigger question than I have the ability to answer in the chat.

Thanks for your videos!

[yomsha]

Thanks a lot <3 you have just saved my task :D

[ytonaona]

Excellent tutorial. Thank you very much!

[sivakumarjagadhesan]

Thank You Sir, the video was very helpful.

[eadvm]

I enjoy taking in your videos. Wish I were still living in Chicago to take part in some live events. Any future plans to take these day courses and make them live and interactive so people from outside of the city could take part in learning from you?

[alvarogs]

Hi! First of all, thank you for this video! Following your example, how can I import the specific sales for a matching Sales_rep? For instance, if I have a larger list of sales_rep in my deestination worksheet but I only want to import the specific sales for those who match my criteria in the origin's sheet, is that possible? Thank you

[Anzeljaeg]

As always, you just make my day, thank you so much

[caseylavalle]

Is there a way for the import range function to auto update when data is changed on the originating sheet?

[thomasentena]

This is super awesome man! Appreciate your help! :)

[FaizanKhan-yqkr]

❤️❤️❤️❤️ thanks alot keep sharing updated stufff