Split one Excel sheet by column value — into sheets or files
Choose a column like Region or Department, click Run, and get one sheet (or one file) per value, with your formatting intact.
You have one master sheet and 15 managers who each need only their own rows. So you filter, copy, paste into a new sheet, fix the column widths, rename — 15 times. Then again next month. Kita turns that into one click.
or download the installer directly
No subscription. The files your tools process stay on your computer.
How it works
-
Get Kita and the tool
Free download, one-click install from the store.
-
Pick your file and the column
Choose the column to split by, and whether you want sheets or files.
-
Run
Get one sheet per value in a new workbook, or one file per value.
What it handles
- Any column: region, customer, project, department, status
- Sheets and files are named after each value (files as Report_split_North.xlsx)
- Cell formatting, column widths, merged cells and the header row are kept
- Title rows above the header are skipped, and a bottom total row is left out (a whole-sheet total would be wrong for one value)
- Your original file is never changed
Why not filter and copy by hand?
Manual filtering is fine once. With 15+ values every month, it's an hour of clicking and an easy place to send the wrong rows to the wrong person. A macro can do it, but someone has to write and maintain the VBA.
Questions
Can I get separate files instead of sheets?
Yes. Choose "One file per value" before you run it.
What happens to rows with a blank value?
They go into a sheet or file called "Unspecified".
Will it keep my formatting?
Yes — cell formatting, column widths and merged cells. Pictures and charts are not copied.
What if my workbook has several sheets?
Only the first sheet is split.
Is there a limit?
One workbook can hold up to 100 sheets. With more values, choose one file per value.
Are my files uploaded?
No. Everything runs on your computer.
Related tools
-
Merge Excel files
Pick a folder of spreadsheets, click Run, and get one combined sheet. Columns line up by name, even when every file orders them differently.
Open tool → -
Compare Excel files
Pick the old file and the new one. Kita lists every new row, every removed row, and every value that changed — old and new side by side.
Open tool →
Stop doing it by hand.
Get Kita, install this tool from the store, and run it on your own files.