合并 Excel 文件

把多个 Excel 工作簿合并为一个文件,保留全部工作表、样式与公式。免费用户:每次最多合并 2 个文件。Pro 用户:无限制。

点击或拖拽文件到此处(.xlsx、.xls、.csv、.tsv)

如何合并 Excel 文件

  1. 点击拖放区,或直接把两个及以上工作簿拖进来。
  2. 检查文件列表,移除不需要的文件。
  3. 点击合并——每个工作簿的 sheet 都会追加到一个新的 .xlsx 中,并立即下载。

什么时候需要合并

月度汇总 — 把十二个月的报表合并成一个年度工作簿,每个来源文件各占一个 sheet。

收集分支数据 — 各地分公司提交相同模板,合并后即可并排对比结果。

归档 — 把相关的工作簿打包成一个文件,而不是保留几十个小附件。

Which tool do you need?

Merging is easy to confuse with a few related jobs, so pick the right tool before you upload:

  • Merge Excel files (this page) — combines several workbooks into one workbook where every original sheet stays its own tab. Nothing is stacked or joined: a sheet named January in file A remains a separate sheet next to a sheet named January in file B, renamed automatically if the names collide.
  • Merge sheets into one — the opposite direction: it takes the many sheets inside a single workbook and stacks them vertically into one flat table, aligning headers and optionally adding a source-sheet column.
  • Join Excel tables — a database-style left join that enriches one table with columns looked up from another table by a shared key column, instead of collecting whole sheets.
  • Compare Excel files — highlights the cells that differ between two versions of a workbook rather than combining them.
  • Remove duplicates from Excel — merged archives often contain repeated rows; this tool deduplicates a sheet by the columns you choose.

What happens to your data

Everything runs locally in your browser. The files are parsed in memory, combined into a new workbook structure, and written back as a single .xlsx download — nothing is uploaded to a server. That makes the tool suitable for payroll exports, financial statements, or client data that should never leave your machine.

Sheets keep their original names whenever possible. When two incoming files contain a sheet with the same name, the later one is prefixed with its file name so you can still tell them apart. Internal metadata sheets created by the editor are skipped automatically. Cell values, dates, and number formats survive the merge; highly specific styling such as conditional formatting rules may be simplified in the output.

Tips for a clean merge

常见问题

样式和公式会保留吗?

会。sheet 连同单元格样式、数字格式、数据验证、表格、图片和公式一起复制。合并后公式仍引用其自身所在的 sheet。

两个文件里有同名 sheet 会怎样?

每个 sheet 尽量保留原名;重名的会自动加上数字后缀,确保不丢失任何内容。

我的文件会离开我的电脑吗?

不会。文件完全在你的浏览器中解析与合并,结果也在本地生成,不会有任何上传。

Is there a file or size limit?

Free users can merge up to two files per run, and upgrading removes that limit. In practice the ceiling is your device's memory — a few hundred megabytes of spreadsheets merge comfortably in a modern browser.

Will my formulas still work after merging?

Formulas that reference cells within the same sheet keep working. Formulas pointing at a sheet in another file are replaced by their last calculated values, because that external workbook does not exist inside the merged file.

How is this better than copy-pasting sheets in Excel?

Manually copying sheets between workbooks often breaks named ranges, chart references, and formatting. This tool rebuilds the workbook structure programmatically, so every sheet lands intact with a predictable name.

想看完整教程?阅读 多个 Excel 文件合并成一个工作簿的方法 —— 分步说明、Excel 手动操作方法和常见问题。