30+ simple features will help you organize and unify data in your spreadsheets. Save time on such daily operations as removing duplicates, merging and splitting data, counting by color, modifying text, and many others. Learn more…
One-time payment Volume discounts Free support 30-day money-back guarantee
The user-proven #1 solution for managing duplicates and uniques across your spreadsheets: find, highlight, combine, and remove duplicates in Google Sheets. Learn more…
Follow five simple steps to join data from two tables. You no longer need to waste your time on building complex VLOOKUP or INDEX/MATCH formulas or copy-pasting data manually to join two sheets. Learn more…
User-friendly tool to look up values based on criteria and return ALL matching data. Copies and inserts found matches as values or creates formulas. Learn more…
Take all the data you have in many sheets and bring everything to one spreadsheet, sheet or custom location. Identify column headers and save initial formatting if necessary. Learn more…
Combine data from multiple sheets while consolidating numeric records from the same rows, columns, or position in tables. Learn more…
Take values from each row, column, or range into one cell. The add-on offers several additional settings in the sidebar to make the merge as flexible as it can be. Learn more…
Separate the name in a cell into multiple cells and auto-detect its parts. It doesn't matter how these parts are arranged – Split Names pulls correct units from any name combinations. Learn more…
Divide your Google sheet into separate sheets based on the common records in one or more columns. Get the data grouped for you in the current or a new spreadsheet preserving the source table. Learn more…
Fill the selected range in your sheet with dates and numbers from a set at random, create strong passwords and generate other strings using the characters and mask you specify. Learn more…
Search in values, formulas, notes, hyperlinks, errors in all sheets at once. Get the list with the found entries and replace or extract them in a click. Learn more…
Create IF-THEN formulas of any complexity in small parts. Don't worry about the proper syntax, extra formulas for dates/time or wildcard characters. Just enter the values, pick comparison operators from the list, and enjoy a ready-made formula. Learn more…