Add-ons for Google Sheets

Some routine you have to follow when working with your spreadsheets is really not worth your time. Get your favorite Ablebits add-ons to carry out daily tasks 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 other.

Read more

Power Tools add-on for Google Sheets

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.

Read more

Remove Duplicates add-on for Google 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.

Read more

Merge Sheets add-on for Google Sheets

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.

Read more

Combine Sheets add-on for Google Sheets

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.

Read more

Merge Values add-on for Google Sheets

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 Names add-on for Google Sheets

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.

Read more

Random Generator add-on for Google Sheets

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 diplay 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

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

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.

Read more

Find Fuzzy Matches  add-on for Google Sheets