Split a Workbook So Each Team Gets Only Its Sheet
Split a workbook for each team by selecting the intended worksheets, exporting one file per sheet, and checking each extracted file before sending it. This walkthrough uses regions-q1.xlsx, which has North, South, and West worksheets plus a hidden Notes sheet. The goal is a separate values file for each region, with no unintended sheet in the handoff.
CombineSheets processes the workbook locally in your browser and downloads the outputs together as a ZIP. The ZIP is a delivery bundle for you to inspect. If each team should receive only its own records, extract the bundle and send each file separately.
Inspect the workbook before splitting it for each team
Download regions-q1.xlsx and open it in your spreadsheet app. Each regional sheet has eight data rows and the same six columns: Order ID, Date, Region, Product, Units, and Revenue.
The hidden Notes sheet is part of the workbook too. Hidden sheets start unselected in the tool. That default helps avoid adding them accidentally, but it does not replace checking the worksheet selection or the downloaded content.
For a real team workbook, inspect what is inside each tab. A sheet labeled North might still contain a pasted total for another region or an extra table farther down. Splitting follows the selected worksheet; it does not examine whether each record belongs to the recipient you have in mind.
Keep the original workbook unchanged. You will need it for future edits, formulas, formatting, and comparisons. The individual outputs contain values only and are not full backups of the original workbook.
Select one file per worksheet
Open the worksheet splitting tool, select the sample workbook, and choose One file per sheet. Select North, South, and West. Leave Notes unselected.
Choose XLSX for this first run. The workbook and sheet names produce these expected filenames:
| Selected sheet | Output filename | Expected data rows |
|---|---|---|
| North | regions-q1 - North.xlsx | 8 |
| South | regions-q1 - South.xlsx | 8 |
| West | regions-q1 - West.xlsx | 8 |
Unsafe filename characters are replaced in output names. The sample names are simple, but your own sheet labels may contain characters that need cleaning. Inspect the extracted names, especially if several source labels look similar after that change.
One file per sheet is different from Split by rows. Row splitting takes one chosen worksheet, or a CSV, and divides its records into numbered parts with a repeated header. It does not use a Region field to assign recipients. Use worksheet splitting when the workbook already has the team separation you want.
Choose between XLSX and CSV
XLSX is appropriate when the recipient expects a workbook file. CSV is appropriate when the next task is an import into a system that accepts a single text table. Either choice exports values only; neither preserves the original formulas or formatting.
CSV does not include workbook tabs or styling. When the recipient imports it into a spreadsheet app, have them set identifier columns to text. Text IDs such as 000101 keep their leading zeros in the exported data, but another app can reinterpret them as numbers when opening the CSV.
Check the values before settling on a format. If the team needs a chart, image, macro, pivot object, comment, validation rule, or the original layout, these split files will not carry it. Fonts, fills, borders, column widths, merged-cell layout, conditional formatting, and external links are also not preserved.
If a source has formulas, recalculate and save it in your spreadsheet app before splitting. Formula cells become their last saved values. A missing saved result stops export and prompts you to recalculate and save; an old saved result still needs your attention before the file is sent.
Consider PDF for a reading copy
If a team only needs to read the table, review the separate worksheet PDF tool. Each selected worksheet becomes its own PDF in a ZIP, with repeated table headers and page numbers.
PDF output is a re-layout of the values, not the original workbook's print view. It does not reproduce print areas, manual page breaks, headers, footers, charts, images, or cell styling. Choose A4 or US Letter and review the estimated page count and orientation before export.
Very wide tables continue on extra pages with the first column repeated. Inspect later pages as well as the first page after downloading. Text must use Western European Latin-1 characters; other scripts and emoji stop PDF export.
Free PDF batches allow 3 worksheets, while a pass allows 100. Every tier has guards of 20,000 non-empty cells per sheet and 100,000 per batch. A reading copy still needs to fit those limits.
Extract and check before sharing
Download the split ZIP and extract it to a location where you can inspect all the files. For the sample run, expect the three regional outputs and no Notes output. Open every file rather than assuming that the filename proves its contents.
For each regional file, check:
- The name matches the intended region.
- The header has the six expected fields.
- There are eight data rows, excluding the header.
- Order IDs and representative values match the source sheet.
- No unintended data has entered the output.
Then match each checked file to its recipient. Sending the whole ZIP to North would also send the South and West outputs. If that is not intended, attach only the extracted North file. Repeat that recipient check for the other teams.
The tool prepares files, while you control the final sharing destination. Review attachments in the sending app before completing the handoff. A correct export can still be sent to the wrong person.
Plan larger runs within the limits
Free splitting accepts one workbook per run and up to 10 output files. A pass supports several workbooks in a run and up to 300 outputs, organized with one folder per workbook inside the ZIP.
General batch input limits are 50 MB and 30 files free, or 100 MB and 300 files with a pass. The free splitting mode still accepts just one workbook. Merge and split guards are 1,000,000 non-empty cells free and 2,000,000 with a pass.
On phones, merge and split use 20 MB and 300,000 non-empty cells per batch across tiers. PDF input limits remain 50 MB free or 100 MB with a pass, including on phones, with the PDF-specific cell guards listed above. Browser memory can run out below a stated guard, so a pass does not guarantee that a large team workbook will fit your device.
Retain the original and your checked outputs after the handoff. When records change next quarter, return to the updated source and repeat the selection and recipient checks rather than assuming the previous workbook structure is unchanged.