Power Tools v1.17

Compare multiple sheets for duplicates

Remember Compare Columns or Sheets add-on? It compared just two sheets at a time. Well, we enhanced it and now it compares multiple sheets in one go! ;)

As you can see from this scheme, you will also be able to handle the found dupes (or uniques), e.g. color them or remove, in all sheets & not just the main one like it used to.

We've already updated the tutorial for the tool, so feel free to look through so you don't miss anything out.

Compare two columns on a sheet

Another legacy of the old Compare Columns or Sheets add-on.

Comparing columns from multiple Google sheets is half the job. But comparing two columns within the same Google sheet has proved to be just as important. That's why we singled out this little helper.

Here I'll only tell you that it's a one-step quickie now. So no need to go over the steps to compare just two columns on one Google sheet.

Check out this tutorial to learn what it has to offer.

Add, remove, extract, replace multiple text substrings at once

We haven't left our text tools behind. These new features have been brewed and polished for months till they're finally ready to meet you.

Substring Batch Toolkit will let you handle multiple substrings at a time. There are 4 tools for different actions:

• Add certain substrings before/after certain words in the selected cells:
  

• Replace multiple substrings. Find certain values in the selected range and replace them with other related records:
  

• Remove multiple substrings. Find & remove certain values from the selected range.
• Extract multiple substrings. Find & extract certain values from the selected cells.

Delete empty cells & shift data up/left

Power Tools already offers several ways to deal with blanks in your tables. It deletes empty & unused rows & columns, fills blank cells with the values from neighboring cells or with your custom ones.

But this new feature introduces yet another way. It removes those single empty cells from your tables while shifting the other data left or right: it's up to you.

You will find the tool as 2 simple checkboxes in the Clear group:

Copy the sheet(s) to multiple existing files in a go

As you may know, our Sheets Manager can copy & move multiple sheets to any other spreadsheet in your Drive:

We've improved it just a bit so you could copy those selected tabs to multiple different files at once :)

When you see the window where you are to select the spreadsheet, press and hold Ctrl (for non-adjacent) or Shift (for adjacent) on your keyboard to select multiple files:

Sort by color & skip empty cells

A new checkbox lets you not just sort all cells in the range by color, but only those with values:

It may seem like a small option but it makes a difference:

Generate only unique strings

Another small but mighty option was added to the String group of Random Generator: unique values. Make sure to tick it off if you'd rather avoid duplicates generated for your data set: