Divisez votre fichier Excel. Gratuit. Conserve formules, mise en forme et tableaux croisés dynamiques.
Max. 100 Mo. Par feuille, lignes, valeur de colonne ou filtre. Les diviseurs en navigateur perdent vos formules — pas nous.
Bâti sur une technologie tableur de niveau entreprise — la même classe de moteur utilisée par les équipes finance Fortune 100. Gratuit, avec la même fidélité que les outils commerciaux à 99 $/mois.
Chaque feuille devient son propre .xlsx. Parfait pour livrer un classeur à plusieurs personnes.
Déposez votre .xlsx / .xlsm / .xls / .xlsb / .ods ici pour le diviser
ou cliquez pour parcourir — jusqu'à 100 Mo par fichier
Pourquoi diviser un fichier Excel est plus difficile qu'il n'y paraît — et pourquoi la plupart des outils gratuits détruisent silencieusement vos données
Diviser un fichier Excel devrait être un travail de 5 secondes. En réalité, les diviseurs en ligne gratuits suppriment vos formules dès qu'ils touchent au fichier. Les outils côté navigateur (SplitForge, xlstools, Switch Labs) avertissent explicitement que les tableaux croisés dynamiques, graphiques, mises en forme conditionnelles et formules matricielles "pourraient ne pas être préservés" — c'est la manière polie de dire qu'ils seront détruits. Les add-ins de bureau (Kutools, ASAP Utilities) coûtent 39–59 $/an. Les outils SaaS Aspose / GroupDocs fonctionnent sur le même moteur que nous, mais limitent les téléversements gratuits à 5 Mo et exigent une inscription. Le diviseur d'ExcelMaster est le premier diviseur Excel gratuit accessible via navigateur qui conserve réellement les formules, cellules fusionnées, caches de tableaux croisés dynamiques et graphiques dans chaque fichier de sortie.
Ce que vous obtenez à chaque division
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.
Comment ça marche
- 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.
Pourquoi c'est le diviseur Excel gratuit le plus complet du 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.
Foire aux questions
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.