How to import data from another Google Sheet and filter the data with the IMPORTRANGE function

You may be filtering and sorting a big dataset in a Google Sheet and want to see that dataset in another Google Sheet without having to copying and pasting the data each time the "source" data is updated. To solve this problem, you need to somehow import the data from the "source" worksheet to your "target" worksheet. When the source worksheet is updated with new sales or customers data, your target worksheet gets updated as well. On top of that, the data that shows up in your target worksheet should be filtered so you only see the data that you need and matters to you.


* Intro - 0:00
* Get Sheet ID from source Google Sheet - 2:46
* Write IMPORTRANGE function - 3:39
* Method 1: FILTER and INDEX function to filter data - 5:33
* Method 2: QUERY function to filter data - 13:08

[bunty]

Searching this video from so long. Thanks for support!

[KamanaPrakash]

Thank you. Easy to understand. I learnt a lot from your tutorials. Have incorporated to my work.

[FennySofyanti]

I followed your video, but getting a "result too large" error. How can I use IMPORTRANGE column by column with 2 filters?

[Sayurix]

Hi, is it possible to use filter for multiple criterion?
Like I want to importrange all the data of like 4-7 people (My Criterion) and put them in one sheet.

[CristinaCastellanos-qzkk]

What i have been looking for! The only cells that did not import for me was the very top frozen row with the column categories. Do you know why this happens? Thanks!

[walterwhitetailfeather]

Excellent information. Exactly what I needed. Clear and concise. Thanks!

[shubhamrawat]

Excellent tutorial. Can you tell me how can I link this dynamic data pulled from outside my current sheet with the static data that I am entering corresponding to it? So that when there is a new addition to the data there is no mismatch with the static rows.

[tylerdavenport]

Thank you for this video. I'm trying to use this same method using date range from multiple columns. I feel like I'm close but am getting parenthesis error.. Any ideas what I'm doing wrong? Thanks!

=QUERY(IMPORTRANGE("google_sheet_url/", "CLUBSMASTER!A:H"), "select Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8 where Col6 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col6 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col7 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col7 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col8 <= date '"&TEXT(C1, "yyyy-mm-dd")&"' and Col8 >= date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1)

[adaapaaja]

how to make exception filter, ex show data except graduate?

[TheXervex]

Good evening,

First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it.

I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible?

Thanks in advance!

[gobindersingh]

very very very useful video, Thanks a lot man !!

[bensanchez]

Brilliant!! After failing with so many other tutorial I get this to work following your video.
Now... How can I do this within the same file landing in a different tab(sheet). I would like Sheet1 to be SourceData and Sheet2 the Imported/Filtered Data

[TheRiyazSaiyed]

QUERY function wont pull text if columns contain numbers
any alternate solution ?

[anyabartlett]

I was having so much trouble finding a good tutorial for this- this video is great!

[jayprakash-zbgr]

Result too large error showing during running formulas pls resolve the issue

[hanishadua]

I was constantly getting the mismatched error before using INDEX in FILTER. Now when I am done sorting that, there is another error - "No matches are found in the filter evaluation". I have done multiple checks for the source data, my target sheet, column I am trying to pull. All seem to be fine but the function is not working again. Can you help here, please ! :|

[dyud]

Hi, is it possible to use the filter formula in one column only and filter more than one value? For example, in your video, you filtered "Graduate", is it possible to filter "Graduate" and "Uneducated"? Hope you'll respond to my question. Thanks!

[MrJordje]

Is it possible to make your filter variables ("Graduate") flexible? F.e. when filter variable = found in a list (with a VLOOKUP)? Great video btw!

[mohdaijaz]

Thanks for the video Work Perfectly, Looking forward For More videos

[ozliezz]

Hi...what the furmula is for more than 1 spreadsheet/file