Merge Excel files
by drag and drop
No formulas, no Power Query. Drop several files in, pick a merge mode and download the result.
Drop files here
.xlsx · .xls · .csv · multiple files at once
- 1Drop files
- 2Pick a mode
- 3Preview
- 4Download
Your data stays with you
Everything runs in your browser. File contents are never sent to a server.
Mismatched columns? Handled.
Columns are matched by name, missing cells stay empty and get flagged before download.
Merge, then verify
Preview the data and cross-check row counts before you trust the result.
How to merge multiple Excel files into one
Combine reports from several branches, join sheets month by month or collect files into one workbook — right in your browser.
- 1. Pick files and sheets
Drop your Excel or CSV files, select the sheets to merge and adjust the header row when your data does not start on row 1.
- 2. Choose merge and cleaning options
Append into one sheet, one sheet per file, merge sheets within a file or group sheets by name. Enable trimming, blank-row removal or deduplication as needed.
- 3. Preview and reconcile
Check the first 100 rows of every sheet, flagged missing columns and the row reconciliation report across the whole dataset.
- 4. Download the result
Name and download the XLSX file with its reconciliation report, or export a single sheet as CSV with your preferred delimiter.
Frequently asked questions about merging Excel files
Does SheetDrop upload my Excel files to a server?
No. Your files are read, merged and written entirely in your browser. SheetDrop never sends file contents to a server and never modifies the original files.
Which formats can I merge?
You can combine multiple .xlsx, .xls and .csv files, up to 50 MB each. The result downloads as an Excel (.xlsx) file, or a single sheet as UTF-8 CSV with BOM to keep Vietnamese diacritics intact.
Can I merge files with different or missing columns?
Yes. Columns are matched by header name, regardless of order. Columns that exist in only some sources are kept, missing cells stay empty and are flagged in the preview. You can also adjust the header row per sheet.
Can it remove duplicates and keep leading zeros?
You can enable blank-row removal, keep the first or last duplicate and choose the columns used for comparison. Codes and phone numbers stored as text keep their leading zeros. Preview the data and check the reconciliation counts before downloading.
Does the result keep colors, charts and formulas from the originals?
The current version exports data and stored formula values. Original colors, charts and formatting are not preserved. If a formula has no stored value or contains an error, SheetDrop warns you to recalculate and save in Excel first.