The add-on offers simple and quick features that help you organize and unify data in your spreadsheets. Save time on such daily operations as changing case, removing data by type, adding or deleting text by position, converting data format, and many others.
Check any combination of columns in your table for duplicated records to highlight or remove them. Use a special wizard to compare columns in two different sheets.
Follow five simple steps to pull missing information from a lookup table into your main sheet. The add-on will scan two sheets and find the same records to update your main table.
Сheck cell colors in Google Sheets and calculate cells based on the font or background hue only, or both at the same time. To sum or count different colors at once, just combine several valuesByColor formulas into one. The tool also recognizes existing formulas so you could edit them quickly.
Filter your table by several conditions set for as many columns as you need. Have the tool pull a number of matches from specified columns and return them to you as text or a QUERY function.
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.
Combine data from multiple sheets while consolidating numeric records from the same rows, columns, or position in tables.
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.
Pull out different name parts to the designated columns and insert them next to full names in your table. The add-on will recognize name units even if their order is different throughout the column.
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.
Combine duplicate rows and pull all information from other corresponding columns. Either merge these records and separate them with delimiters, or concatenate numbers using the most commonly used functions.
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.
This tool gives you the possibility to specify the type of data and sheets to search in. It will display a full list of found records and let you easily navigate or export it. After you review the search results, you can replace all or the needed entries.
Create IF-THEN formulas of any complexity in small parts. Don't worry about the proper syntax, extra formulas for dates and time or wildcard characters. The add-on will recognize the format of your data, let you pick comparison operators, and provide you with a ready-made formula.
Save your company style and apply it to any spreadsheet. Make use of the background color and other standard formatting options for your headers and totals, left and right columns, and row stripes.
Check the selected range for misprints and see them listed in groups by value. Tick off or enter the correct word and apply the corrections to your sheet.