Filter values by multiple criteria and extract ALL matching data. Copies and inserts found matches as values or creates formulas.
Listing updated:October 17, 2024
Works with:
290K+
Overview
Filter and Extract Data for Google Sheets™ is an advanced alternative to the VLOOKUP and INDEX & MATCH functions. The add-on doesn't simply fetch a record for a criterion as the function does. It returns multiple matches based on multiple conditions. What's more, you can change the criteria on the go and preview the new result before pasting it to your spreadsheet. 

The drill is quick and easy and takes ONLY 3 STEPS: 

  1. pick the table you want to process
  2. set as many conditions as you need
  3. specify if you want to get all or only a number of matches

The add-on then scans your data and builds a new dataset in a place of your choice based on your requirements. 

SET CONDITIONS ON THE FLY

With the intuitive interface of the tool, there's no need to learn how to properly enter dates and time in Google Sheets™ anymore. Built-in operators will help you set your criteria on the fly. They adapt to your spreadsheet locale so you could enter dates and time as you do in daily life. The add-on will scan your data for exact or partial matches, compare values, or find records belonging to a certain period of time. 

SEARCH IN ALL DIRECTIONS

While the standard VLOOKUP cannot look at its left, our tool retrieves records from all directions. Simply select those columns you want to see in the resulting table. At your option, Filter and Extract Data will present everything as pure values or as the QUERY formula that you'll be able to use and edit later.

The add-on also serves as a standard FILTER REPLACEMENT. Instead of jumping from column to column creating conditions, you can arrange everything within one window. Our tool will find all matches and copy them outside of your table without modifying it.

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions please post them here:
https://www.ablebits.com/docs/google-sheets-filter-extract-data/ 
We'll be happy to assist!

Filter and Extract Data (formerly Multiple VLOOKUP Matches) is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace™. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
–––––––––––––––––––––––––––––––––––––
WHAT'S NEW:
***** V1.6 (16 November 2023) *****
Fixed: 
- Couldn't insert formulas to the sheet different from the source sheet.
- Built incorrect formulas if a cell reference was used as an argument for the 'equal to' operator.
- Processed data with formulas incorrectly for 'is error' and 'is not error' arguments.
- UX fixes.

***** V1.5 (23 December 2022) *****
Improved:
- It's now possible to copy-paste a list of words into the add-on so they turn to multiple conditions.
- Text operators (starts/ends with, contains/ doesn't contain) now recognize cell references so you could refer to cell values instead of entering them directly to the add-on.
- The limit for total cells in a spreadsheet is expanded to 10 million cells.
- Performance improvements for previewing and pasting 5k+ found records.
- Minor UX and UI improvements.

Fixed:
- The add-on couldn't paste data into the file without a set time zone.

***** V1.4 (18 October 2021) *****
Fixed:
- Formulas returned 'PARSE ERROR' whenever the records to look for contained a single quote, i.e. it's.
- Fields of the 'is between' criteria couldn't accept formulas in some cases.

***** V1.3 (5 May 2021) *****
★ New features ★
- 2 new operators added. You can now look for cells that 'start with' or 'end with' particular characters or strings.
Improved:
- If there are no matches to your conditions, the preview field will say 'No matches found' instead of remaining completely empty.

Fixed:
- The formula missed the final argument making headers merge with data from the 1st row.
- The formula didn't return results for 'Date time' cells if conditions were built for dates only.
- The formula didn't work with big ranges that contained column BY.
- Errored if your 'Data validation' rules prevented the tool from displaying the result.
- Didn't work if you run it from a Chart sheet.

***** V1.2 *****
★ New features ★
- AND/OR logic is supported: decide if all or some of the built conditions should be met to get a match.

Improved:
- UI for 4K monitors.

Fixed:
- Keyboard navigation skipped the icon to open/close format suggestions.

***** V1.1 *****
★ New features ★
- The add-on checks and warns you if the destination range for the resulting formula contains data.

Improved:
- Time zones processing: to ensure correct matches for dates and times.
- Keyboard navigation: the focus is added to all icons and options in the drop-down lists.

Fixed:
- The add-on didn't accept ranges from sheets with spaces and quotes in their names.
- New columns added with the add-on running didn't appear in the tool.
- The error appeared after changing the source range and trying to preview the result right away.
- The preview didn't work if the last column in the table contained all number formats but Automatic.
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Filter & Extract Data will ask for the permissions shown below. Learn more
Filter & Extract Data will need access to your Google account
This will allow Filter & Extract Data to :
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
popa 311
April 5, 2024
This was the first time paying for this service and I was very happy with the customer support even When I messed up and purchased it on the wrong account, they quickly got back to me and helped me merge my accounts, and I will definitely think of recommending this product to my co-workers because It saved me so much time on making formulas. Amazing app and will truly revolutionize the Google Sheets setups.
Is this review helpful?
Yes
No
Profile Picture
Madison Ferguson
October 9, 2023
I love this tool! I have been tasked with filtering a large number of spreadsheets and this tool turned a 10 min (per sheet) job into a 1 min job! The only thing that would help even more is if I could save the lookup criteria so I wouldn't have to type it in for each sheet. But all in all, this is an incredibly helpful tool that I highly recommend.
Is this review helpful?
Yes
No
Profile Picture
Theo Mackey
June 19, 2024
Easy to use! Amazingly Accurate! Reduce my work time on a project by over 75%!
Is this review helpful?
Yes
No
Profile Picture
Eric Gehringer
June 24, 2022
This is not only an amazing tool that allows to you to put query formulas into your spreadsheet without having to learn that language, but the customer service is AMAZING! I was having issues with getting a particular outcome with my formula, and their team was responsive within a day or two and either had a solution within the add-on, or a great work-around to make everything work the way I needed. SUPER GREAT!
Is this review helpful?
Yes
No
Profile Picture
Paulina Jurmile
June 7, 2023
Simply didn't work. The tool generated incorrect formulas that returned null result. Uninstalling immediately.
Is this review helpful?
Yes
No
Profile Picture
Yahya Ibrahim
May 7, 2022
Love it. Together with the youtube tutorial it works really well. So much easier than fiddling with code until it works.
Is this review helpful?
Yes
No
Profile Picture
Louis Meletiou
September 18, 2020
A brilliant tool that allowed me to do far more with Google Sheets than I've ever been able to before, which will save me hours of manual data entry going forwards. A big thanks to Katerina and the team too who were also unbelievably helpful and responsive with my annoying questions. Would recommend to anyone
Is this review helpful?
Yes
No
Profile Picture
Aster Niel Abellano
June 28, 2021
The add-on is very useful and easy. I would like to know if the effect of the add-on is still on effect when my trial period is done?
Is this review helpful?
Yes
No
Profile Picture
A User of Filter & Extract Data
October 14, 2019
Easy! The best way to save time for creating a loooooong formula. Thanks guys.
Is this review helpful?
Yes
No
Profile Picture
A User of Filter & Extract Data
October 14, 2019
Thanks! Using the add-on is much more convenient and faster than creating complex formulas manually!
Is this review helpful?
Yes
No
1-10 of 20
Search
Clear search
Close search
Google apps
Main menu