DATA CLEANING
Remove Duplicates by Column
Deduplicate Excel or CSV records using the columns that actually define identity — such as email, customer ID or a combination of fields — without uploading your file.
The first matching row is kept. Rows where every selected key column is blank are preserved instead of being collapsed into one record.
How to remove duplicates using selected columns
- Select an Excel or CSV file.
- If needed, choose the Excel worksheet to clean.
- Select one or more duplicate key columns.
- Choose whether text matching should ignore case and surrounding spaces.
- Select Remove duplicates and download the cleaned file.
Choose the columns that define the same record
A complete row does not need to be identical for two records to refer to the same person, order or item. For example, two customer rows may have the same email address but different update dates. Selecting only Email lets you keep the first record for each email while removing later matches.
Use multiple columns for composite keys
Sometimes one column is not unique enough. You can select a combination such as Customer ID + Product, First Name + Last Name + Date of Birth, or Order Number + Line Number. Utilumi only treats rows as duplicates when the selected key values match as a group.
Blank identifiers are handled conservatively
Rows with no value in any selected key column are preserved. This prevents unrelated incomplete records from being removed merely because they share missing identifiers.
Private browser-based spreadsheet cleanup
The spreadsheet is processed in the browser session. For regulated, confidential or mission-critical data, follow your organization's approved data-handling requirements and keep the original file as your source copy.
Frequently asked questions
Can I remove duplicates using only one column?
Yes. Select one column such as Email, ID or Customer Number. Rows with the same selected value are treated as duplicates and the first matching row is kept.
Can I use multiple columns as the duplicate key?
Yes. Select two or more columns when a record should only be considered a duplicate when the combination of those values matches.
What happens if all columns are selected?
Selecting every column performs whole-row deduplication. A row is removed only when all selected values match an earlier row.
What happens to blank key values?
Rows where every selected duplicate-key column is blank are preserved. This avoids accidentally collapsing unrelated records simply because their identifier is missing.
Are text matches case sensitive?
By default the tool ignores uppercase versus lowercase and surrounding spaces for text values. You can turn that option off when exact text matching is required.
Are my files uploaded?
No. The selected Excel or CSV file is read and cleaned inside your browser. Utilumi does not need to upload it to a file-processing server for this tool.