Excel ファイルを分割。無料。数式・書式・ピボットを完全に保持。
100 MB まで。シート別、行数別、列の値別、フィルター別。ブラウザ系ツールは数式を失います — 当社は失いません。
Fortune 100 の財務チームが信頼するエンタープライズグレードの表計算技術で構築。月額 99 ドルの商用ツールと同じ忠実度を、無料で。
各ワークシートが独立した .xlsx ファイルになります。複数の宛先に配布する場合に最適。
.xlsx / .xlsm / .xls / .xlsb / .ods ファイルをここにドロップして分割
またはクリックで参照 — 1 ファイルあたり最大 100 MB
Excel 分割が見た目より難しい理由 — そしてなぜ無料ツールの多くがあなたのデータを密かに破壊するのか
Excel ファイルを分割するのは 5 秒で済む作業のはずです。しかし実際には、無料のオンライン分割ツールはファイルに触れた瞬間に数式を失います。ブラウザベースのツール (SplitForge、xlstools、Switch Labs) は、ピボットテーブル・グラフ・条件付き書式・配列数式が「保持されない可能性がある」と明示的に警告しています — これは「破壊される」と丁寧に言い換えただけです。デスクトップアドイン (Kutools、ASAP Utilities) は年額 39–59 ドル。Aspose / GroupDocs SaaS は当社と同じエンジンですが、無料アップロードを 5 MB に制限し、サインアップを要求します。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.