Project Name

Color Duplicates



Google Cloud, Google Apps Script, HTML, CSS, Google Sheet, Data Studio

Color Duplicates

Google sheet add-on that highlights or removes duplicate data from Google Sheet. It removes or highlights duplicate rows or columns from Google Sheet. It can find duplicates on single or multiple selected columns. It generates output data on the same sheet replacing your existing data or populating on a new sheet. It sorts your output data so that all duplicate rows can come together.

Guide to using Color Duplicates application consists of the following steps –

  • Step 1: Select the range with your table

It selects the used range on the sheet itself when opening the sidebar.
Or you can manually select the range on the sheet and click on the table icon in the sidebar.

  • Step 2: Select Columns

Select the single column or multiple columns here based on which duplicates need to be removed or highlighted.
All columns are selected by default.

  • Step 3: Select Options

This is where you can select whether you want to remove duplicate rows from your data or just want to see duplicate entries highlighted.
You can select a color to get your output data highlighted and formatted on the output generated.

  • Step 4: Sort Data

You can turn on/off the sort data option.
Select a column on which data requires to be sorted.

  • Step 5: Place Data In?

Select the option “New Sheet” to save the data in the new sheet or select “Existing Sheet” to save it in the current sheet.