40+ 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.
The user-proven #1 solution for managing duplicates and uniques across your spreadsheets. Find, highlight, combine, and remove first or last duplicates in Google Sheets. Save repeated actions into reusable scenarios and share them with your spreadsheet collaborators, or just make their backups on your computer or Drive. Read more…
2 tools to compare your data in Google Sheets. 1: scan multiple Google sheets cell by cell for differences in values or entire rows. 2: compare two or more columns or Google sheets for duplicate or unique rows. Read more…
Retrieve missing data from multiple lookup tables in just 5 simple steps. Forget about building complex VLOOKUP or INDEX/MATCH formulas or copy-pasting data manually. The tool will match all records between the sheets and update your main table accordingly. Save your preferred settings as reusable scenarios and easily share them with teammates or other Google accounts using Merge Sheets. Read more…
User-friendly tool to filter a table by multiple criteria and return ALL matching data. Copies and exports found matches as values or creates formulas. Read more…
If pulling data from other documents is not enough and you'd rather do some math with all those records, Consolidate Sheets is the add-on to go with. It not only merges multiple Google sheets but also calculates numbers at the same time. Read more…
This add-on offers a great opportunity to combine data from many spreadsheets into one. Even if your tables differ in formatting, column order, or content, Combine Sheets will perfectly join everything you have in one table using the column headers. Read more…
Combine columns, rows, or ranges of data and preserve original values. Three simple settings let you decide if you want to combine multiple columns or rows, pick the delimiter for the records, and choose a place for the results. Read 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. Read more…
Split your Google sheet into separate sheets based on common column records or desired row counts. Your source table remains intact while the data is neatly organized in new or existing sheets. With optional formula-based updates linked to the original table, your split sheets will always reflect the latest data. Read more…
Search in values, formatting, formulas, hyperlinks, notes, errors in all sheets at once. Get the list with the found entries grouped by sheet and replace, format, extract or delete them in a click. Read more…
Generate random passwords, numbers, custom values, booleans or dates according to your criteria. Read 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. Read more…
The easiest way to handle multiple Google sheets in one go: protect/unprotect, hide/unhide sheets, change color, rename, reorder, duplicate, copy, move, delete. Read more…
Sum and count colored cells in Google Sheets by the fill and/or font hues, calculate their average, find the max or min number, and more. Read more…
Table Styles lets you quickly apply a professional look to your tables in Google Sheets. Apply a uniform style to your tables in one click or add your own custom style templates. Read more…
Designed for Google Docs & Google Sheets, this add-on lets you effortlessly merge info from Google Sheets to your email template, to create and send customized emails via Gmail. Read more…
The collection includes Doc Tools for quick text formatting, Styles for creating or applying professional designs to your documents, Easy Mail Merge for sending personalized emails from your Gmail, and Search & Navigate for easy document navigation and search. Read more…
Create your own reusable styles for Google Docs or apply one of 20 professional sets in just a few clicks. Read more…