拆分你的 Excel 文件。免费。保留公式、格式、数据透视表完整无损。
最多 100 MB。按工作表、行数、列值或筛选条件拆分。浏览器侧拆分工具会丢失你的公式 — 我们不会。
基于企业级电子表格技术构建 — 与 Fortune 100 财务团队使用的同等引擎。免费提供，保真度与每月 99 美元的商业工具相同。
每个工作表生成独立的 .xlsx 文件。适合一份工作簿分发给多个收件人。
将你的 .xlsx / .xlsm / .xls / .xlsb / .ods 文件拖到这里拆分
或点击浏览 — 每个文件最大 100 MB
为什么拆分 Excel 比看起来更难 — 以及为什么大多数免费工具会悄悄破坏你的数据
拆分 Excel 文件本应是 5 秒钟的工作。但实际上，免费在线拆分工具一旦接触文件就会丢失你的公式。浏览器侧工具（SplitForge、xlstools、Switch Labs）明确警告数据透视表、图表、条件格式和数组公式「可能不会被保留」— 这是「会被破坏」的礼貌说法。桌面插件（Kutools、ASAP Utilities）每年收费 39–59 美元。Aspose / GroupDocs SaaS 工具使用与我们相同的引擎，但免费上传限制为 5MB 且需要注册。ExcelMaster 的 Splitter 是首个免费、可在浏览器中使用、能在每个输出文件中实际保留公式、合并单元格、数据透视缓存和图表的 Excel 拆分工具。
每次拆分你都能获得
Formulas survive intact
Standard, array, dynamic-spill, and cross-sheet formulas are preserved with relative references re-anchored. Every output workbook recalculates as if it were the only file in the world.
Pivot tables, charts, conditional formats
Embedded pivot caches, charts, conditional formatting rules, slicers, and data validations come along for the ride. Browser-side splitters cannot do this — they can only see cell values.
Merged cells & frozen panes
Layout-critical structures like merged headers, frozen rows, and grouped columns are kept in every chunk so each file is presentation-ready.
Header row replication (rows / column-value / filter)
When you split by rows, group, or filter, the header row is automatically copied to every output file — every chunk reads as a complete dataset on its own.
Streaming for files up to 1 GB+
Our streaming pipeline switches on automatically for large workbooks (>5 MB) so you can split spreadsheets that crash desktop Excel. Most competitors cap at 100 MB or refuse outright.
Transparency manifest in every zip
Every download includes a manifest.json listing each output file's row count, column count, byte size, and source group — auditable, scriptable, and complete. Industry first.
工作原理
- 1Drop your .xlsx / .xlsm / .xls / .xlsb / .ods file (up to 100 MB).
- 2Pick a split mode: By sheet · By rows · By column value · By filter. Each mode shows its own configuration panel.
- 3Optionally click "Preview split" first — we count exactly how many output files would be produced, show you the top groups, and warn you before you accidentally split by an ID column with 100,000 unique values.
- 4Click "Split now". Our streaming engine produces a zip containing every output workbook plus a manifest.json transparency report.
- 5Download the zip. Each output file is a complete, independently-usable workbook with formulas, pivot tables, charts, and formatting preserved.
为什么这是网上最强大的免费 Excel 拆分工具
Keeps formulas — the others don't
Browser-side splitters explicitly drop formulas because JavaScript spreadsheet libraries can't recompute external references. We run a commercial-grade engine server-side that re-anchors every formula in every chunk.
Five split modes (industry's most complete)
By sheet, by rows, by column value, by filter (with 12 operators including regex / gt / lt / contains / starts-with). Every paid competitor offers at most three; the free ones rarely offer two.
Pre-flight preview to prevent disasters
We tell you up front how many files would be produced — so you don't accidentally split by a customer-ID column and get 47,000 zip entries. Industry: nobody does this.
Per-file transparency manifest
Every zip includes manifest.json with each output file's row, column, byte, and group key. You see exactly what you got — the paid tools just hand you a zip and let you find out the next morning that 8 sheets were silently dropped.
Streaming engine for files up to 1 GB
Most browser splitters cap at 100 MB; SplitForge crashes around 50 MB; Gigasheet requires sign-up over 100 MB. Ours streams 1 GB+ workbooks because the engine was built for enterprise data.
No signup, no email gate, no preview-then-paywall
We're not a splitter company — ExcelMaster.ai is an AI Excel agent. This tool exists to introduce you to that. There's no email capture, no "preview the result then pay $19" trick. The split runs end-to-end every time.
常见问题
Is it really free? What's the catch?
Genuinely free. No signup, no credit card, no per-day limit, no preview-then-paywall trick. Our business is the optional ExcelMaster AI add-in for Excel; this Splitter exists to introduce you to that. If you never install the add-in, the splitter is still free.
What's the maximum file size?
100 MB per upload. The streaming engine handles much larger workbooks server-side, so if you have a >100 MB file, contact [email protected] and we'll lift the cap on a case-by-case basis.
Does splitting really keep all my formulas, pivots, and charts?
Yes — and this is our biggest differentiator. Browser-side splitters (SplitForge, xlstools) cannot preserve formulas, pivot caches, or charts because the JavaScript spreadsheet engines they use can't compute external references. Our server-side commercial-grade engine re-anchors every formula and copies the pivot cache + chart binaries to each output file. Verify it: split a file, open any output workbook, and check that =SUM, =VLOOKUP, pivots, conditional formatting all behave exactly as in the original.
What's the difference between the four split modes?
By sheet: each worksheet becomes its own .xlsx (use this for one-workbook-many-recipients delivery). By rows: every N rows become one file (chunk for upload limits or per-day reporting). By column value: group rows by unique values of a column — one file per region, customer, category, sales rep (this is the killer mode for distribution). By filter: rows matching a condition (Region='East', Sales>1000, regex match) go to one file; non-matching to another. Pick by use case, not by sophistication.
Is it safe to upload financial / sensitive data?
Yes. Files are uploaded over TLS 1.3, processed in an isolated container, and auto-deleted within 1 hour. We don't view, store, share, or train AI models on your file content. Your enterprise / financial / personal data is yours alone.
Why do I need to upload my file at all? Can't this run in the browser?
Browser-only splitters exist (SplitForge, xlstools), but they trade fidelity for privacy: they all explicitly drop formulas, pivots, charts, and conditional formatting because JavaScript spreadsheet engines can't compute external references the way Excel does. Our server-side engine is the only way to get a faithful split — and we offset the privacy concern with TLS, container isolation, and 1-hour auto-deletion.
What output formats are supported?
Each output file inside the zip can be xlsx (default), xlsm (preserve macros), xls (legacy), xlsb (binary, smaller), csv (text), or ods (OpenDocument). The zip itself is always .zip and includes a manifest.json transparency report.
What if my source has 100k unique values in the split column? Won't I get 100k files?
We catch this in the preview step: click "Preview split" first and we'll show "would produce 100,000 files — exceeds limit". You then refine your column choice, increase the cap, or switch to a different mode. The hard ceiling is 2,000 output files per request — beyond that, we recommend the by-rows mode or contacting support for batch processing.
Does it work for password-protected files?
Yes — provide the open password and we'll split the workbook keeping the protection metadata intact (each output file inherits the same password). We don't crack passwords (that's a separate Excel Unlock tool). We never brute-force, never store, never log passwords.
What's the largest file you've successfully split?
Internal benchmark: a 487 MB / 12-sheet financial reporting workbook split by-column-value into 213 files in 28 seconds, with all 47,000 formulas, 11 pivot tables, and 38 charts preserved. The streaming pipeline switches on automatically for files >5 MB.
Can I integrate this into my workflow / pipeline / automation?
Yes — POST to https://tools-api.excelmaster.ai/v1/excel/split with input_path (from /upload), mode, and mode-specific parameters. No API key for the free tier. For high-volume / programmatic use, reach out for batch limits.
How long does splitting take?
Most files split in under 5 seconds. Files with thousands of pivot tables or 100k+ rows can take up to 60 seconds. We'll show you a live progress indicator (Upload → Preview → Split) so you know what's happening.