Divide tu archivo Excel. Gratis. Conserva fórmulas, formato y tablas dinámicas intactas.
Máx. 100 MB. Por hoja, filas, valor de columna o filtro. Los divisores del navegador pierden tus fórmulas — nosotros no.
Construido sobre tecnología de hojas de cálculo de nivel empresarial — la misma clase de motor que usan los equipos financieros de Fortune 100. Gratis, con la misma fidelidad que las herramientas comerciales de 99 USD/mes.
Cada hoja se convierte en su propio .xlsx. Perfecto para entregar un archivo a varios destinatarios.
Suelta tu .xlsx / .xlsm / .xls / .xlsb / .ods aquí para dividir
o haz clic para examinar — hasta 100 MB por archivo
Por qué dividir Excel es más difícil de lo que parece — y por qué la mayoría de las herramientas gratuitas destruyen silenciosamente tus datos
Dividir un archivo Excel debería ser un trabajo de 5 segundos. En realidad, los divisores online gratuitos eliminan tus fórmulas en cuanto tocan el archivo. Las herramientas basadas en navegador (SplitForge, xlstools, Switch Labs) advierten explícitamente que las tablas dinámicas, gráficos, formato condicional y fórmulas matriciales "podrían no preservarse" — que es la forma educada de decir que se destruirán. Los add-ins de escritorio (Kutools, ASAP Utilities) cuestan 39–59 USD/año. Las herramientas SaaS Aspose / GroupDocs funcionan con el mismo motor que usamos nosotros, pero limitan las cargas gratuitas a 5 MB y exigen registro. El divisor de ExcelMaster es el primer divisor de Excel gratuito, accesible desde el navegador, que realmente conserva las fórmulas, celdas combinadas, cachés de pivot y gráficos en cada archivo de salida.
Lo que obtienes en cada división
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.
Cómo funciona
- 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.
Por qué este es el divisor de Excel gratuito más capaz de la web
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.
Preguntas frecuentes
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.