Skip to content
Try free
FreeNo account needed

Merge Excel files into one table.

Combine several workbooks, or several sheets from one workbook, into one table.

Merge Excel files

Merging CSVs instead? Use the CSV merger.

  • Workbooks or sheets
  • Up to 50 files
  • Mismatched columns fixed
  • Excel or CSV back
mammoth.io/tools/merge-csv-files
  1. 1Files
  2. 2The table
  3. 3Preview
  4. 4Your file

3 tables read

Their columns don't all match. The next step sorts that out.

✓sales-jan.csv4 columns
✓sales-feb.csv4 columns
✓sales-mar.csv4 columns

Drawn from a real run of the merge tool on three CSV files. To try a workbook, download our sample with three month sheets and a summary tab: regional-sales.xlsx.

  • Arla Foods logo
  • Bacardi logo
  • British American Tobacco logo
  • Everest Detection logo
  • Golden Acre logo
  • Handlangers logo
  • Inspired Learning Group logo
  • Kantar logo
  • MUFG logo
  • NielsenIQ logo
  • PTI Digital logo
  • RethinkFirst logo
  • Starbucks logo
  • The Specialist Works logo
What you get

One table from many workbooks

Use it on its own, or have Mammoth merge next month's files for you.

  • Workbooks or sheets

    Merge several workbooks, or pick sheets from one. Leave the summary tab out.

  • Fixes columns that don't match

    Power Query misses a renamed column. This shows you, and you fix it with one click.

  • Free, and your files are deleted

    No account. Your uploads are deleted within the hour.

How it works

How to merge Excel files into one table

If every workbook has the same columns, Excel's Power Query does this: Data > Get Data > From Folder, then Combine. These steps are for when the columns don't match.

  1. north.xlsx
    south.xlsx
    west.xlsx
    1

    Add the workbooks

    Up to 50 files, 100 MB each and 400 MB in total. CSVs can go in too.

  2. Jan
    Feb
    Mar
    Summary
    2

    Pick the sheets

    Each sheet is read as its own table. A summary tab that doesn't match is left out for you.

  3. JanFebMar
    Date●●●
    Amount●●●
    Region●●?
    3

    Read the grid

    Each column gets a row and each workbook gets a column. Dots show what's filled.

  4. JanFebMar
    Date●●●
    Amount●●●
    Region●●?

    Mar: Sales Region fills Region

    4

    Fix what doesn't match

    Click a cell and pick which column fills it. It shows you sample values.

  5. Jan12,400
    Jan9,870
    Feb11,020
    Feb13,550
    XLSXCSV
    5

    Check the join, get the file

    The preview shows where each workbook starts. Pick Excel or CSV and we email it to you.

Try it on last month's workbooks

Drop the workbooks in, pick the sheets, and get one table by email.

Merge Excel files
Your options

Other ways to do it

Excel's Power Query may be all you need.

  • Power Query

    Workbooks that always match

    • Free: Partly
    • Refreshes next month by itself: Yes
    • Handles renamed columns: No
    • No email needed: Yes

  • Copy and paste

    A few small sheets

    • Free: Partly
    • Refreshes next month by itself: No
    • Handles renamed columns: Partly
    • No email needed: Yes

  • This merger

    Workbooks whose columns drifted

    • Free: Yes
    • Refreshes next month by itself: No
    • Handles renamed columns: Yes
    • No email needed: No
Every month

Merging workbooks every month?

Mammoth can do it for you. Put the workbooks in a folder and each one is added to the same table automatically.

Try Mammoth free

Regional reports

Northnorth.xlsx
Southsouth.xlsx
Westwest.xlsx
DriveDropboxOneDriveSFTP
All regionsUp to date
SepHardware48,200
SepHardware39,750
SepHardware27,300
SepServices18,900
SepServices22,410

Illustration. Every new file in the folder is added to the same table.

Set it up yourself in three steps, or reply to the tool's email and we'll help.

  1. 1

    Put the files in a folder

    Upload them to a folder in Mammoth, or collect them from Google Drive, Dropbox, OneDrive or SFTP on a schedule.

  2. 2

    Add them to one table

    Add a Data Consolidation step on that folder and set it to Combine. Each new file is added to the same table.

  3. 3

    Set the column matching once

    Mammoth remembers which column goes where. A file that doesn't match is held back, and you get a notification.

Your files stay private

Your uploads are deleted within the hour. The merged file is sent to the email address you enter.

  • SOC 2 Type II
  • ISO/IEC 27001:2022
  • HIPAA
  • GDPR

How we handle your data

Merge Excel files

  1. You upload

    north.xlsx and 2 more

  2. You check the merge

    No account needed

  3. File emailed to you

    To the address you enter

  4. Uploads deleted

    Within the hour

    < 1 hour

You'll also get the occasional email about working with files like these. Unsubscribe in one click.

FAQ

Questions people ask

Still not sure? Try it with your own file.

Merge Excel files
Should I just use Power Query?
Often, yes. It's already in Excel, and next month you press refresh. It struggles when a column is renamed: the renamed column arrives empty and nothing tells you.
My workbooks stopped matching. What happens?
You see it before anything is written. The grid marks each column as matched, renamed, missing or a different type, and you fix each one with a click.
Do I get an Excel file back, or a CSV?
Either. Pick Excel if you'll work in Excel: its number columns are already numbers, so SUM works. Pick CSV to import it somewhere else.
It's one workbook with twelve sheets.
That works too. Each sheet is read as its own table. A sheet that doesn't match, like a summary tab, is left out, and you can tick it back in.
Can I merge Excel files and CSV files together?
Yes. XLSX, XLSM, XLS, CSV and TSV files can all go into the same merge.
Do I need Excel installed?
No. It runs in your web browser. You only need Excel to open the result.
Can I merge Google Sheets?
Download each one first: in Google Sheets, choose File, then Download, then Microsoft Excel. Then upload those files.
I only want all my sheets in one workbook, not one table.
Then you don't need a merger. In Excel, right-click a sheet tab, choose Move or Copy, and pick the other workbook.
Can I see which workbook each row came from?
Yes. Tick Add a Source file column on the preview step.
How many files can I merge?
Up to 50 files, 100 MB each and 400 MB in total. The 400 MB is the ceiling that binds first: fifty files only fit if they average 8 MB. In the grid, files that need no attention collapse into a single column, so what takes up the screen is how many files deviate, not how many you uploaded.
Do I have to give an email address?
Yes, at the last step, after you've seen the result. We send the file there, plus the occasional note about this kind of work. Unsubscribe in one click. Your uploads are deleted within the hour either way.
This is a monthly job across several teams.
Mammoth can do it for you. It remembers how your columns match and adds each new workbook to the same table.

Merging files every month?

Mammoth remembers how your columns match and merges each new file for you.

Try freeBook a demo
  • Free trial
  • No credit card
  • Viewers always free

Keep reading

Use the CSV mergerStack two or more CSV files into one table, even when the columns don't quite match.Free toolsThe rest of the free tools.PricingWhat the platform costs once you want it on a schedule.