Distribute tickets by team
Prepare a worksheet for each team while keeping ticket references, dates and comments together for detailed follow-up.
Split an Excel file by column
Choose a grouping column and generate a workbook containing a separate sheet for each detected value.
- Batch processing
- Export
Your files are processed locally in your browser and are never sent to our servers.
Drop your file here
Recommended size: up to 30 MB
Workbook split
Processing…0 %
Was this tool useful?
How does this tool work?
An export of orders, service tickets or registrations may need to be distributed across several teams. This tool creates one XLSX workbook with a worksheet for every value in your chosen column. It retains each group’s rows and all their columns, including the grouping field. Splitting does not calculate totals or remove duplicates: it distributes records so that each group can be read and reviewed separately.
Import an XLSX, XLS, CSV, TSV or tabular JSON file. With a workbook, only the first worksheet is read; other sheets are neither combined nor copied into the result. Column names come from the imported table’s headings. JSON must contain an object or a list of objects with simple scalar cells; flatten nested structures beforehand. Reading extracts table data rather than reproducing the original layout, charts, macros or workbook formulas. Check the preview to make sure the intended source sheet and headings have been selected.
The engine visits records in their original order and assigns each one to the textual representation of its selected cell. Case and whitespace matter: North, north and North followed by a space form three separate groups. Missing, null and empty values belong to the group without a value. Groups follow their first appearance in the input, and rows within each group retain their original sequence. No alphabetical sorting, summation or matching by identifier is performed. Values with the same textual representation can belong together even when their JSON types differ.
Worksheet names are then adapted to Excel constraints: outer whitespace and edge apostrophes are removed, forbidden characters replaced and length limited to 31 characters. An empty name receives a replacement label. When different values produce the same sheet name, a suffix such as (2) makes it unique; name comparisons ignore case. The reserved name History is avoided too. Naming adjustments never merge groups or change their original cell values. Two groups can therefore have similar sheet labels while retaining different source categories.
How to use this tool
Import the intended source sheet
Move the table to the first position in a workbook with several sheets, import the file and check its preview before choosing a field.
Choose the distribution field
Select a column present in the imported data. Prepare the workbook and inspect the proposed group labels and record counts.
Download and inspect the tabs
Export the XLSX workbook. The on-screen list shows at most twenty groups, whereas the downloaded file includes every prepared worksheet.
Use cases
Review sales by branch
Create branch tabs for inspection of individual records. Use grouping or a pivot table instead when you need branch totals.
Find incomplete categories
Inspect the group without a value and spelling variants before correcting the categories in the original export.
Examples
Two teams and three tickets
Both columns remain in each worksheet. North contains two records in their original sequence, T1 followed by T3.
Input
team;ticket
North;T1
South;T2
North;T3
Column: teamResult
North: T1, T3
South: T2Different values producing one sheet label
Replacing forbidden characters creates a name collision, resolved with a suffix. Original A/B and A?B cell values remain separate and unchanged.
Input
area;id
A/B;1
A?B;2
Column: areaResult
A-B: id 1
A-B (2): id 2Tips and best practices
- Clean surrounding spaces and standardize case before splitting if spelling variants should belong to one team.
- A column of unique identifiers creates one worksheet per record. Choose a category with a manageable number of values to keep the workbook practical.
- Sending the entire workbook shares every group. Extract the intended worksheet and review personal information before distributing only one team’s records.
Sources and references
- Rename a worksheet (opens in a new tab), MicrosoftPage in English
Frequently asked questions
Will I receive several Excel files?
No. The download is one XLSX workbook containing multiple sheets. Use the CSV splitter when you need separate CSV files.
What happens to my other source worksheets?
Only the first imported worksheet supplies records. Other source sheets are not copied. Reorder the original workbook before importing if another sheet should be used.
Why do almost identical categories create separate tabs?
Grouping compares the exact textual value, including spaces and case. Sheet names are adapted afterwards, without combining the underlying groups.
Does the exported workbook preserve formulas and colours?
It is rebuilt from the table values that were read. It is not a faithful copy of the original formatting, macros or formulas.
Does distribution upload my spreadsheet?
Reading, grouping and exporting run in your browser. Large tables or very many groups can still exceed the memory available on your device.
Related tools
Keep going with these tools
Tools similar or complementary to this one.
Similar tools
Split a CSV file into smaller files using the size or groups you choose.
Data & spreadsheetsFeaturedUse this tool
Remove duplicates, empty rows and unnecessary spaces.
Data & spreadsheetsUse this tool
Merge multiple Excel or CSV files into one table with automatic column alignment.
Data & spreadsheetsUse this tool
Read next
GuideBest practicesBeginner
Split a CSV or Excel table into smaller files
Discover when to split a large table by row count or by a column value, and how to preserve a useful structure in every output file.
29 August 20261 min
GuideBest practicesBeginner
Merge CSV or Excel files without misaligning columns
Learn how to align headers, verify schemas and combine several CSV or Excel files while avoiding duplicated or shifted columns.
29 August 20262 min
GuideBest practicesBeginner
Convert CSV, Excel, JSON and TSV without losing the structure
Understand delimiters, encodings, types, nested JSON and spreadsheet features before converting data between CSV, Excel, JSON and TSV.
29 August 20262 min
GuideBest practicesBeginner
How to clean and prepare a CSV or Excel file before using it
Learn a practical order for removing empty rows, trimming values, standardizing headers, checking identifiers and validating a CSV or Excel dataset.
29 August 20263 min