Skip to content

Merge Excel Files

Merge Excel files online: combine several XLSX, XLS or CSV files into one Excel workbook — each file as its own sheet, or all rows stacked in one sheet with columns matched by heading — in your browser.

In-browser · no upload XLSX, XLS, CSV → XLSX, CSV

3 merges free every day, then 1 credit per merge.

Runs entirely in your browser. Your files and text are not uploaded to our servers.

To merge Excel files, choose two or more files, put them in the order you want and pick how to merge them. Each file as its own sheet keeps every sheet with its formatting and formulas in one workbook. All rows in one sheet stacks the data of every file into a single list, matching columns by their heading even when they are in a different order.

The files are merged on your device and never uploaded.

How to use the Merge Excel Files

  1. 1

    Choose the files

    Two or more XLSX, XLS or CSV files (up to 20). Reorder them with the arrows.

  2. 2

    Pick how to merge

    A sheet per file, or all rows in one sheet with an optional “Source file” column.

  3. 3

    Merge and download

    Download one Excel file (or a CSV when the rows are stacked).

How it works

Each file is opened in your browser. In sheet mode its sheets are copied into a new workbook as they are, and sheet names come from the file names (with the sheet name added when a file has several). In row mode the first row of each sheet is read as its heading, the data rows are placed under the matching headings, and formulas are replaced by their results.

Features

  • Two ways to merge

    Keep each file as a tab, or combine the data into one list.

  • Formatting kept

    In sheet mode, fonts, colours, borders, number formats, column widths, merged cells and formulas are kept.

  • Columns matched by heading

    “Name, Amount” and “Amount, Name” line up correctly; new columns are added at the end.

  • Mix formats

    Combine XLSX, XLS and CSV files in one go.

  • Know where each row came from

    An optional “Source file” column shows the file (and sheet) of every row.

  • Private

    Everything happens in your browser; nothing is uploaded.

When to use it

  • Combining monthly sales or expense sheets into one file.
  • Joining attendance or stock lists from several branches into one list.
  • Collecting form responses exported as separate CSV files.
  • Putting several reports into one workbook to send by email or WhatsApp.

Privacy and file handling

Where it runs
Runs in your browser
File size limit
20 MB per file, up to 20 files

Runs entirely in your browser. Your files and text are not uploaded to our servers.

Limitations

  • Charts, pictures, pivot tables and macros are not copied.
  • In row mode, headings must be spelled the same to be matched (spaces and capitals are ignored).
  • Up to 20 files of up to 20 MB each; very large files need a desktop browser.

Frequently asked questions

Is it free?

You can merge 3 times a day for free. After that, each merge uses 1 credit.

Are my files uploaded?

No. The files are merged in your browser and never leave your device.

What if the columns are in a different order?

Choose “All rows in one sheet”: columns are matched by their heading, so the order in each file doesn’t matter.

Can I merge CSV and Excel files together?

Yes. XLSX, XLS and CSV files can be merged in one go.

What are the new sheets called?

Each sheet is named after its file, with the sheet name added when a file has several sheets. You can rename them in the Excel Editor.

Was this tool helpful?

Thanks for the feedback.

Last reviewed