Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to filter importrange data in Google Sheets.
How to Filter IMPORTRANGE Data in Google Sheets
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.
First, head to the spreadsheet you want to copy data from. Click on the Share button on the upper right.
Click on the Copy link button to copy the URL into your clipboard.
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.
Next, fill in the URL parameter and the sheet range parameter.
Hit the Enter key to evaluate the function.
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”.
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.
More ways to import in Google Sheets:
- Fix IMPORTRANGE Internal Error
- IMPORTRANGE From Another Tab
- IMPORTRANGE With Conditions
- IMPORTRANGE With Formatting
- VLOOKUP + IMPORTRANGE
- IMPORTRANGE Multiple Ranges
- Fix IMPORTRANGE Error Loading Data
- Fix IMPORTRANGE Formula Parse Error
- Open CSV File
- Create A CSV File
- Import Data Into Google Sheets
- Import Spreadsheet Into Google Sheets
- Export Google Sheets To Excel
- Download Google Sheets
- How To Use Importrange
- Import CSV
- Import Excel
- Save as a CSV
- Import Data From Another Sheet
- Import Google Sheets To Excel
- Import PDF
- Export a Google Sheet into Different Formats
- Pull Data From Multiple Tabs
- Connect Google Forms To Google Sheets
- Open Excel In Google Sheets