Google sheet add-on that highlights or removes duplicate data from Google Sheet.

Removes or highlights duplicate rows or columns from Google Sheet.

It can find duplicates on single or multiple selected columns.

Generates output data on the same sheet replacing your existing data or populating on a new sheet.

Sorts your output data so that all duplicate rows can come together. Get It Free For 7 days.

How to use Data Splitter Addon

1

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.

2

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

3

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.

4

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

5

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

screenshots