In this tutorial, you will learn how to filter importrange data in Google Sheets.
How to Filter IMPORTRANGE Data in Google Sheets
Quick Navigation
Google Sheets makes it easy to pull data from one spreadsheet and display it in another. This is done with the IMPORTRANGE function, which allows you to reference data from other spreadsheets.
However, sometimes you may want to filter the data imported from another spreadsheet. For example, you may want to display only certain rows where the value in the date field is within a certain month.
The quickest way to do this is by wrapping the IMPORTRANGE function with an additional FILTER function.
In this guide, we will show you how to filter IMPORTRANGE data in Google Sheets.
How to Filter IMPORTRANGE Results in Google Sheets
Here’s our step-by-step guide on how to filter the IMPORTRANGE result in Google Sheets.
Step 1
First, head to the spreadsheet you want to copy data from. Click on the Share button on the upper right.
Step 2
Click on the Copy link button to copy the URL into your clipboard.
Step 3
Next, head to the destination spreadsheet and select an empty cell. Type “=IMPORTRANGE(“ to start our IMPORTRANGE function.
Ensure that there are enough empty cells below and to the right of the cell to accommodate the imported data.
Step 4
Next, fill in the URL parameter and the sheet range parameter.
Hit the Enter key to evaluate the function.
Step 5
Once the IMPORTRANGE function is successful, we can now add a FILTER function around it.
Add the entire IMPORTRANGE function as the first argument of the FILTER function. Afterward, use the IMPORTRANGE function again to pull the specific column you want to check against the criteria.
In the example above, we were able to import all rows from another spreadsheet where the value in column C is equal to “mastercard”.
Summary
This guide should be everything you need to learn how to filter the output of the IMPORTRANGE function in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.