Split an Excel file into sheets by a column value
Splitting a sheet by category is the classic reason people go looking for a VBA macro. Describe the split instead: the tabs come back in one workbook, named the way you asked.
The instruction to paste
Example instruction
Keep rows where Amount is over 500, and move the ones with status overdue onto a separate tab named overdue
What comes back
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| APAC | Beta | 340 | cancelled |
| EMEA | Gamma | 890 | overdue |
| AMER | Alpha | 1500 | paid |
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| AMER | Alpha | 1500 | paid |
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Gamma | 890 | overdue |
How it works
- 01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
- 02
Paste the instruction, changing the column names to the ones in your own file.
- 03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.
Other ways to ask
The instruction is read as a sentence, not filled into a form. These all work on the same file.
Put each Region on its own tab, named after the region
Move rows where Amount is under 500 onto a tab named small, and keep the rest on the main tab
The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.
Questions
How are the tabs named?
By whatever you say in the instruction. Ask for a tab per value of a column and each tab takes that value as its name.
Can each tab have a different set of columns?
Yes. Say which columns belong on which tab and the result is built that way.
Does this work on a CSV?
You can upload one, but a CSV has no concept of tabs, so the result comes back as an .xlsx workbook.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.