Remove Duplicate Excel Rows
Keep the first row for each matching set of selected columns.
Combine monthly reports or spreadsheet exports into one worksheet. Merge Excel appends rows from selected sheets in file and worksheet order, then exports a new XLSX workbook.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
Appends selected worksheets into one values-only sheet. Headers must match exactly when enabled; this is not a key-based data join.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
January.xlsx and February.xlsx each contain SKU and Qty columns. With headers enabled, the result has one header row followed by both records. Text SKU values retain their leading zeros.
January.xlsx: SKU | Qty
0012 | 2
February.xlsx: SKU | Qty
0034 | 3
Merged sheet: SKU | Qty
0012 | 2
0034 | 3Files are containers for worksheets. This tool takes the selected sheets and appends their rows into one output sheet; it does not keep each source as a separate tab, match records by ID, sum matching rows or remove duplicates. Use Find Matching & Missing Rows for key comparisons and Remove Duplicate Excel Rows for deduplication.
With headers enabled, names and order must match exactly. Without headers, every row is included and column counts must match. Excel inputs must be unencrypted XLSX, not XLS or XLSM. Up to 10 files, 25 MB each and 75 MB total are accepted, subject to 50,000 rows, 500 columns and 500,000 cells. Formulas use saved results; styles, charts and merged-cell layout are not preserved.
Yes. Select at least two sheets after automatic inspection. You can also select sheets from multiple workbooks.
A selected sheet has different header values or a different column order. Make them identical before merging; the tool does not automatically align columns by name.
No. Rows are appended, including duplicates. Use the related deduplication tool afterward if needed.
It exports saved formula results as values without recalculation. Recalculate and save the source in your spreadsheet application first.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Drop your .XLSX files here, or browse your device.
25 MB per file · up to 500,000 cells total · files stay on this deviceFiles are inspected automatically after selection.
Download before leaving. File contents are never saved in history.