Get your favorite Ablebits tools to carry out daily tasks in spreadsheets with ease
What you want to do
Get all time-savers in one place
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.
Find and remove duplicates
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.
Compare columns and sheets for dupes and differences
Use 2 add-ons from the toolset to compare your data in Google Sheets. Deal with duplicate rows in 2 or more columns or sheets based on the specific columns, or find and color differences cell by cell in as many sheets as you need.
Merge two 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.
Sum and count colored cells
С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.
Sort colored cells
Organize your selection or whole rows by the font or fill colors they contain. Choose a sorting direction &, if necessary, specify a column to sort the selection based on its colors.
Vlookup multiple matches based on multiple criteria
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.
Combine multiple spreadsheets into one
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.
Merge and calculate data from multiple sheets
Combine data from multiple sheets while consolidating numeric records from the same rows, columns, or position in tables.
Manage multiple Google sheets
The tool offers the easiest way to handle multiple Google sheets. See them all in the add-on pane, select those you want to manage, and click one of the action buttons: (un)lock & (un)hide sheets, duplicate, reorder, copy or move sheets to an existing / new / multiple new spreadsheets, change color, delete, rename.
Merge values from adjacent cells
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.
Split full names into different columns
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.
Split one Google sheet into multiple sheets
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
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.
Generate random values
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.
Find & replace data in notes, links, formulas, and values
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.
Build new or edit existing Google Sheets IF formulas
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.
Change table style
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.
Find fuzzy matches and correct typos in your sheet
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.
