Add-ons for Google Sheets
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
Power Tools add-on for Google Sheets
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
Remove Duplicates add-on for Google Sheets
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.
Merge two sheets
Merge Sheets add-on for Google 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
Function by Color for Google Sheets
С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.
Vlookup multiple matches based on multiple criteria
Multiple Vlookup Matches add-on for Google Sheets
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
Combine Sheets add-on for Google Sheets
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
Consolidate Sheets for Google Sheets
Combine data from multiple sheets while consolidating numeric records from the same rows, columns, or position in tables.
Merge values from adjacent cells
Merge Values add-on for Google Sheets
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
Split Names add-on for Google Sheets
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
Split Sheet add-on for Google 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 for Google Sheets
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
Random Generator add-on for Google Sheets
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
Advanced Find & Replace add-on for Google Sheets
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
IF Formula Builder add-on for Google Sheets
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
Table Styles add-on for Google Sheets
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
Find Fuzzy Matches add-on for Google Sheets
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.
