The tool splits one large Excel or CSV table into multiple separate sheets within a new XLSX file. The core principle is grouping all rows by the unique values found in a column you select, such as by manager or city. Each resulting data group is neatly placed onto its own sheet, with the original header row fully preserved on every tab, making the data ready for independent use.
When this is useful
First scenario: a sales lead gets a consolidated monthly report and wants to email each employee only their respective rows. They upload the file, select the 'Manager' column, and instantly receive a workbook where each sheet is a personal extract for a specific person. Second case: an online store owner exports the full product catalog and decides to structure it by category for easier browsing, splitting the table by the 'Product Type' column.
Step-by-step instructions
- Start by uploading your source file in XLSX or CSV format, keeping within the 20 MiB total limit for free usage.
- Once uploaded, the system will display a list of columns from your table — choose the one whose values will be used for the split.
- Make sure the selected column has no hidden characters or typos that could create unnecessary extra groups.
- Launch the processing, wait for it to finish, and then download the resulting XLSX file with multiple sheets.
How to verify the result
After downloading, open the file and check the number of sheets — it should match the count of unique values in the source column, but not exceed the 50-group limit. Verify that the header row is present on every sheet and that the data hasn't shifted. If some rows are missing, check the source column for empty cells — they might have been ignored or grouped separately. If you get a CSV reading error, ensure that a comma is used as the delimiter.
Important limitations
The tool has a hard limit of no more than 50 unique groups, otherwise processing will not run, making it unsuitable for columns with highly variable data. Complex formatting, such as merged cells, in-sheet formulas, and non-standard visual styles, will most likely not be preserved in the output file. Note that the tool works specifically with data, not the visual layout, creating a structurally clean workbook.