Estimate the real workload
File size alone is misleading. Many styled cells, formulas, shared strings, and worksheets can require several times more memory after parsing. Start with a representative batch before loading every file.
Reduce the input surface
Select only required worksheets and columns. Remove blank formatted ranges in a copy of the source if a workbook reports an enormous used range despite containing little visible data.
Process files sequentially
Reading one file at a time limits peak memory. Keep other memory-heavy tabs and desktop applications closed, and avoid starting a second merge while the first export is being built.
Use deterministic rules
Save mappings, date normalization, duplicate keys, and conflict rules as a reusable template. Repeating the same rules is faster and prevents different batches from producing incompatible columns.
Validate in stages
Compare source and output row counts, inspect data types, and open the final workbook before deleting intermediate results. For very large jobs, merge smaller groups first and then consolidate those outputs.
QUICK WORKFLOW
Complete the task in four controlled steps
- Test a representative subset and note memory or format warnings.
- Select only required worksheets and save a rule template.
- Load and process files sequentially.
- Review counts and warnings, then export and validate the workbook.
COMMON QUESTIONS
Before you start
What is the maximum Excel file size?
There is no single safe limit because workbook complexity and device memory matter more than compressed file size. Test a representative batch first.
Does chunking mean the file is uploaded?
No. Chunked or sequential processing can happen entirely in the browser and is used to reduce interface blocking and peak memory.
简体中文
如何在浏览器中合并大量Excel并避免崩溃
大型工作簿任务失败通常是因为解析后的内存占用远高于文件体积。更安全的流程是先估算复杂度、减少无关工作表、顺序处理并分阶段核对。
估算真实工作量
压缩文件大小并不能代表解析后的内存。样式、公式、共享字符串和多个工作表都可能放大占用，应先用有代表性的小批次测试。
减少输入范围
只选择必要的工作表和字段。如果工作簿可见数据很少但使用范围巨大，可在副本中清理空白格式区域。
顺序处理文件
一次读取一个文件可以降低峰值内存。关闭其他占用较大的标签页和程序，导出完成前不要启动第二个合并任务。
固定处理规则
把列映射、日期标准化、重复主键和冲突规则保存为模板，避免不同批次产生不兼容的输出字段。
分阶段验证
比较输入和输出行数，检查数据类型并打开最终文件。任务特别大时，可先合并若干小批次，再汇总这些中间结果。
FIX IT IN YOUR BROWSER
Use the file on your device. Nothing gets uploaded.
Load a sample or choose your own files, confirm the result, and download a clean workbook.
Open the free tool