Skip to content
Try free

Free tool

Merge Excel files into one table.

Combine several workbooks, or several sheets from one workbook, into a single table you can check before you download it. XLSX, XLSM and XLS, up to 20 files at 100 MB each.
Merge Excel files

Merging CSVs instead? Use the CSV merger.

What you get

Free, and it deletes your files.

This tool is the front door to Mammoth. Use it on its own, or record the mapping once and have next month's files land in the same table.

  • Workbooks or sheets, either way

    Upload several workbooks, or one workbook whose sheets belong in the same table. Sheets are picked on the first step, so the summary tab can be left out before any column question comes up.

  • It survives a renamed column

    Combine & Load matches on the column name it finds, so a renamed column arrives as a new one with half the rows empty and nothing says so. This reads what each workbook has, matches the same column under a different name, and shows you what does not line up before it writes anything.

  • Free, and your files are deleted

    There is no account to create and no payment. Your uploads are deleted within the hour. An email address is asked for at the last step, once the merge has run and you have seen the result, and it is used for that file and nothing else unless you tick the box.

Try it on last month's workbooks

Drop the workbooks in, pick the sheets that belong together, and see which columns line up before anything is written.

Merge Excel files

Doing this every month? Turn it into a pipeline that runs itself.

How to merge Excel files into one table

If every workbook holds the same columns in the same order, Excel does this without leaving Excel: Data > Get Data > From File > From Folder, then Combine & Load, and press refresh next month. These five steps are for the case that one does badly, which is the month a column gets renamed, added or reordered and half the rows arrive empty with nothing saying why.

  1. 1

    Add the workbooks

    Drop in the files you want stacked, up to 20 at 100 MB each and 400 MB in total. XLSX, XLSM and XLS, and CSVs can go in the same merge.

  2. 2

    Pick the sheets

    Where a workbook holds several sheets, the first step lists them so you can select the ones that belong in the same table and leave the summary tab out. Files that look like the same export twice are flagged here too.

  3. 3

    Read the grid

    The second step is one grid: a row for every column of the table being built, a column for every workbook, and a mark in each cell for filled, matched under another name, empty, or holding a different kind of value.

  4. 4

    Settle what is flagged

    Click a flagged cell and the fix opens under it, so three problems across twelve workbooks are three clicks rather than three screens. Click a workbook heading to make its shape the model for the table, or to leave that workbook out.

  5. 5

    Check the seam, then download

    The preview shows where one file stops and the next begins, which is where a bad match shows first. The result downloads as a CSV that Excel opens directly, and an email address is asked for at that last step.

Questions people ask

Should I just use Power Query instead?
Often, and it is already on your machine. Data > Get Data > From File > From Folder, then Combine & Load, and next month you press refresh. It is the right answer for a folder of workbooks that hold the same shape every time. Where it struggles is the month somebody renames a column, adds one, or reorders them: Combine & Load matches on the name it finds, so a renamed column arrives as a new column with half the rows empty and nothing tells you it happened.
My workbooks stopped matching. What happens?
You see it before anything is written. The setup step is a grid: one row per column of the table being built, one column per workbook, and a mark in each cell for filled, matched under another name, empty, or a different kind of value. Clicking a flagged cell opens the fix under it, so three problems across twelve workbooks are three clicks.
Do I get an Excel file back, or a CSV?
A CSV. Excel opens it directly, double-click and it lands in a sheet, and CSV is what most other tools want on import. If you need an .xlsx workbook, Save As once it is open gives you one. This page says Excel because that is the file you start with; the file you get back is a CSV.
It is one workbook with twelve sheets, not twelve files.
That works the same way. Upload the workbook and the first step lists its sheets so you can pick the ones that belong in the same table and leave the summary tab out.
How many files can I merge at once?
Up to 20 files, 100 MB each and 400 MB in total. Past four workbooks the ones that need no attention collapse into a single column in the grid, so twelve still fit on one screen.
Do I have to give an email address?
Yes, at the last step, after the merge has run and you have seen the result. The address is where a copy of the finished file is sent as the download opens, and it is used for that file and nothing else unless you tick the box. Your uploads are deleted within the hour either way.
This is a monthly job across three teams.
That is the point at which a merger stops being the answer. Mammoth is the platform underneath this tool: the same merge, plus the column mapping recorded once and replayed, so next month's workbooks land in the same table. Uploading each new file and replaying that recipe works on every plan; having Mammoth collect the files and run it on a schedule is a Pro feature.

Merging once is useful. Merging every month is the point.

Bring the files into Mammoth to record the column mapping once, join the result to everything else, and have it delivered on a schedule.

Try freeBook a demo
  • 21-day Pro trial
  • No credit card
  • Viewers always free

Keep reading

Use the CSV mergerStack two or more CSV files into a single table, including the month somebody renamed a column.Free toolsThe rest of the ungated tools.PricingWhat the platform costs once you want it on a schedule.