# Merge Excel workbooks into one spreadsheet

Source: https://mergevanta.com/merge-excel
Updated: 2026-10-21

> Merge Excel files online free. Combine .xlsx, .xlsm, .csv and .tsv files into one workbook — every sheet kept, duplicate names renamed, no watermark.

Bring every sheet from every workbook into one tidy file. Sheet names are de-duplicated automatically and each sheet can be tagged with its source, so nothing is silently overwritten.

## How do I combine multiple Excel files into one workbook?

Add your .xlsx, .xlsm, .csv or .tsv files to Mergevanta's Merge Excel tool and press Merge. Every sheet from every file is copied into one new workbook, and duplicate sheet names get a numeric suffix so nothing is overwritten. It's free and needs no sign-up.

## Key facts

- **Price:** Free
- **Watermark:** None
- **Sign-up:** Not required
- **Accepts:** .xls, .xlsx, .xlsm, .csv, .tsv
- **You get:** One combined .xlsx workbook
- **Processing:** Encrypted server for files up to 4 MB, your browser for larger ones
- **Files stored:** Never
- **Works on:** Windows, macOS, Linux, iPhone, iPad and Android

## Why use Mergevanta

- **Nobody gets overwritten:** When two workbooks share a sheet name, Mergevanta suffixes the duplicate instead of replacing your data.
- **Cells and formulas intact:** Values, formulas, formatting and column widths are read and re-emitted by a full spreadsheet engine.
- **CSV and TSV welcome:** Mix spreadsheets with comma- or tab-separated data files in the same merge.
- **Tag the source sheet:** Add a column that records which file each sheet came from, so auditing a combined workbook is effortless.

## How to use it

1. Add your .xlsx, .xlsm, .csv or .tsv files to the studio.
2. Turn on source tagging if you want each sheet labelled with its origin.
3. Press Merge to collect every sheet into one workbook.
4. Download the combined .xlsx and open it in Excel, Numbers or Sheets.

## Frequently asked questions

### What spreadsheet formats can I merge?

Old .xls (Excel 97–2003) and modern .xlsx/.xlsm workbooks, plus .csv and .tsv text files. Old .xls files are converted automatically — their formulas come through as calculated values.

### What happens to duplicate sheet names?

The first sheet keeps its name and later duplicates get a numeric suffix, so the workbook stays valid and no data is lost.

### Are formulas and formatting preserved?

Values, formulas and most formatting are carried through by the spreadsheet engine. Extremely intricate conditional formatting may simplify.

### Can I combine several CSV files into one Excel file?

Yes. Add the .csv files (and any .xlsx workbooks) together and press Merge — each file becomes its own sheet in one .xlsx.

### Can I merge sheets into an existing workbook?

Mergevanta builds a brand-new combined workbook from your selected files rather than editing a file in place, which keeps your original untouched.

## Related tools

- [Excel to PDF](https://mergevanta.com/excel-to-pdf)
- [PDF to Excel](https://mergevanta.com/pdf-to-excel)
- [Merge PDF](https://mergevanta.com/merge-pdf)