By Jetformat
Each visible worksheet becomes a separate workbook. Hidden worksheets are not part of the output set.
Steps
- Start with a local XLSX. Replace the sample paths and identifiers with your own.
- Run the command below. Save to a new output path so the source remains available for comparison.
- Check the result as described below before using it in another job.
jetformat excel split workbook.xlsx -o workbook-partsOptions for this task
| Option | Meaning |
|---|---|
--output |
Output directory; defaults to <filename>-parts |
Check the result
Compare output file count with the visible-sheet count and check formulas that used other sheets.
Notes and limits
Writing an Office document uses one credit per command. See the billing guide for the current rules.
The examples keep the original file. Add --force only when you intend to overwrite an existing output. Run jetformat excel split --help to compare options with your installed version.
See the excel command reference for the surrounding workflow.