Remove Duplicates¶

The Remove Duplicates tool identifies and removes rows that have identical values in selected columns.

Remove Duplicates

Opening¶

Select the data range, then open Data > Remove Duplicates.

Configuration¶

Data Has Headers¶

Enable the Data has headers checkbox (on by default) to treat the first row as column headers rather than data. Header names are displayed in the column list for easier identification.

Column Selection¶

A scrollable list shows all columns in the data range. Check the columns you want to compare when identifying duplicates. Only rows with identical values across all checked columns are considered duplicates.

Use Select All or Deselect All to quickly toggle all columns.

Preview¶

A live preview shows how many duplicate rows were found based on the current column selection, letting you verify before committing.

Applying¶

Click OK to remove the duplicate rows. The first occurrence of each unique combination is kept; subsequent duplicates are deleted. A result dialog reports how many rows were removed and how many unique rows remain.