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.

Read more

Power Tools add-on for Google Sheets

Find and remove duplicates

Compare columns and sheets for dupes and differences

Compare Sheets add-on for Google Sheets

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.

Read more

Compare Sheets add-on for Google Sheets

Merge two and more Google spreadsheets

Merge Sheets add-on for Google Sheets

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.

Read more

Merge Sheets add-on for Google Sheets

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. In addition, sum or count different colors at once. The tool also recognizes existing formulas so you could edit them quickly.

Read more

Function by Color for Google Sheets

Sort colored cells

Sort by Color for Google Sheets

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.

Read more

Function Sort by Color for Google Sheets

Vlookup multiple matches based on multiple criteria

Combine multiple spreadsheets into one

Merge and calculate data from multiple sheets

Process multiple text strings in one go

Manage multiple Google sheets

Sheets Manager for 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.

Read more

Sheets Manager for Google Sheets

Merge values from different cells

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.

Read more

Split Sheet add-on for Google Sheets

Split one Google sheet into multiple sheets

Split Sheet add-on for Google 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 a new spreadsheet preserving the source table.

Read more

Split Sheet add-on for Google Sheets

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.

Read more

Combine Duplicate Rows for Google Sheets

Generate random values

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.

Read more

Advanced Find & Replace  add-on for Google Sheets

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.

Read more

IF Formula Builder add-on for Google Sheets

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.

Read more

Table Styles add-on for Google Sheets

Find fuzzy matches and correct typos in your sheet