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 first or last duplicates
Check any combination of columns in your table for duplicated records to highlight or remove them even when you're offline. Alternatively, combine duplicate rows or compare columns in two or more sheets. Store repeated actions as reusable scenarios to share with your team or keep backups on your local or Google Drive.
Compare columns and sheets for dupes and differences
Use 3 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 and more Google spreadsheets
Follow five simple steps to pull missing information from as many lookup tables as you need into your main sheet. The add-on will scan all sheets and find the same records to update your main table. Save your favorite settings into reusable scenarios that you can share with your teammates and other Google accounts who also use Merge Sheets.
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. In addition, sum or count different colors at once. 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.
Filter Google Sheets by multiple criteria and extract results
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. Choose columns to combine, and the add-on will identify their 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.
Process multiple text strings in one go
In bulk – add, replace, remove or extract multiple specific text strings from the designated range.
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 different 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 either on the common records in columns or the number of the desired rows in the result. Get the data grouped for you in the current or new spreadsheets preserving the source table. Opt for formulas for the results so split sheets auto-update with the original 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, errors, values, by formatting
Effortlessly search, navigate, and replace data across your Google Sheets. Explore advanced search options like multi-word search, fuzzy search, regex, search by formatting. Quickly locate matches grouped by sheet and take action with ease. Replace, format, export, and delete selected values or all matches in a snap.
Mail merge from Google Sheets
A powerful yet easy email tool for personalized mass emailing with attachments directly through Gmail.
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.
