Merge Duplicate Rows by Key
Consolidate duplicate records by key while filling complementary blank values and reporting conflicts.
Choose one or more key columns, detect duplicate records, fill complementary blank values, review conflicts, then merge records as one reversible step.
Paste Data
Copy cells from Excel or Google Sheets and paste them here.
Import a spreadsheet file
Import CSV or XLSX data into the current dotXLS workspace. Files are processed in your browser.
Tools
The first row is protected as the header. Rows sharing the selected key are consolidated; conflicting nonblank values are reported before you apply.
Undo and Redo controls are available with the current grid.
Duplicate record merge analysis
Merged record preview
Preview only. The current worksheet is unchanged.
Paste spreadsheet data to create your workspace.
Name Department Amount Ahmed Sales 1200 Maria HR 950
Your data stays in this browser tab and is not sent to WordPress.
Export result
Download the current workspace data after editing or cleaning.