Excel dosyanızı bölün. Ücretsiz. Formülleri, biçimlendirmeyi ve pivotları korur.
Maks. 100 MB. Sayfa, satır, sütun değeri veya filtre ile. Tarayıcı bölücüleri formüllerinizi kaybeder — biz kaybetmeyiz.
Fortune 100 finans ekiplerinin güvendiği kurumsal sınıf elektronik tablo teknolojisi üzerine inşa edildi. Ücretsiz.
Each worksheet becomes its own .xlsx file. Perfect for delivering one workbook to many people.
.xlsx / .xlsm / .xls / .xlsb / .ods dosyanızı buraya bölmek için bırakın
veya gözatmak için tıklayın — dosya başına en fazla 100 MB
Excel'i bölmek neden göründüğünden daha zor
Splitting an Excel file should be a 5-second job. In reality, the free online splitters drop your formulas the moment they touch them. Browser-side tools (SplitForge, xlstools, Switch Labs) explicitly warn that pivot tables, charts, conditional formatting, and array formulas "may not be preserved" — that's the polite way of saying they will be destroyed. The desktop add-ins (Kutools, ASAP Utilities) cost $39–$59/year. The Aspose / GroupDocs SaaS tools work on the same engine we use, but cap free uploads to 5 MB and require sign-up. ExcelMaster's Splitter is the first free, browser-accessible Excel splitter that actually keeps formulas, merged cells, pivot caches, and charts in every output file. We can do this because we run a server-side commercial-grade engine — the cost of which we cover ourselves so you don't have to.
Her bölmede neler alırsınız
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.
Nasıl çalışır
- 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.
Neden web'in en yetenekli ücretsiz Excel bölücüsü
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.
Sık sorulan sorular
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.