Merge Excel files into one
Branch reports, monthly exports, the sheets of one workbook: drop them in, check how the columns match up, and get a single table.
What this tool does
- XLSX, CSV and ODS files mixed, with all their sheets or only the ones you tick.
- Columns matched by name, ignoring case, accents and spaces; the matching is shown and can be corrected.
- A "Source" column that tells which file and sheet each row came from.
- The result as XLSX (dates and numbers kept) or CSV.
What it does not do: Values are carried over, not formulas or formatting: the merged table is a data table. Beyond 1,048,576 rows, the XLSX continues on a second sheet; CSV has no limit.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Look up between two files : VLOOKUP between files, without a formula, and the list of what found nothing.
- Reconcile two lists : Statement and ledger, file and export: what matches, and the differences.
- Split a file : One file per branch, per sales rep, or per batch of rows, header repeated.
- Compare two Excel files : Two versions of the same table: added rows, removed rows, changed cells.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.