Split Excel by Column Value
Turn one worksheet into a separate file for every value in a column — one file per region, per salesperson, per month. Excel has no command for this; here it is a drop, a column and a download, and your file never leaves your device.
- Nothing uploaded
- No size limit
- No account
Drag and drop an Excel file here, or click to select
Supported formats: .xlsx, .xls
What the Split Excel by Column Value tool does
A single sheet holding every region, every sales rep or every month is fine to work with and awkward to share, because each recipient only needs their own rows. This tool splits an Excel sheet into separate files based on a column value: pick the column, and every distinct value in it becomes its own file, carrying its whole rows and a copy of the header row. You can also have the split come back as one workbook with a sheet per value instead.
How to split an Excel sheet into multiple files by column value
Add the workbook
Drop an .xlsx or .xls file. The first row is read as your column headers and the first few rows are shown back to you, so you can check you picked the right file before going further.
Choose the column to split by
Pick the column that says which group a row belongs to — Region, Owner, Month, Status. As soon as you choose, you are told exactly how many distinct values it holds and how many rows each one has, before anything is written.
Choose separate files or one workbook
Separate files gives you a .zip with one .xlsx per value. One workbook gives you a single .xlsx with one worksheet per value, which is easier to skim and to keep as a single attachment.
Split and download
Every output starts with your original header row. The download starts on its own — a zip when there is more than one file, or the file itself when the column turned out to hold a single value.
Options explained
What stays on your device
Your workbook is never uploaded. The Split Excel by Column Value tool reads the file straight from your disk and does all of its work inside this browser tab, using the open-source ExcelJS and SheetJS libraries. There is no account, no upload limit and no copy of your data on any server — once this page has loaded, the tool keeps working even if you disconnect from the internet.
Limitations to know about
- Only the first worksheet is split, and its first row must hold your column headers.
- Rows with an empty cell in the split column are gathered into one output named "(blank)" rather than being dropped, so nothing is lost without you seeing it.
- The outputs contain your headers and data. Cell formatting, formulas and charts from the original are not carried across — keep your original file if you need them.
- Characters that Excel allows in a cell but not in a filename or a sheet name, such as a slash or a colon, are replaced with an underscore in the output name.
- A legacy .xls file is converted to .xlsx before processing, which preserves the data but not the original formatting.
Frequently asked questions
How do I split an Excel sheet into multiple files based on a column value?
Drop the workbook above, choose the column that identifies each group, and split. Every distinct value in that column becomes its own file, with your header row repeated at the top, and the whole set arrives as a single zip. There is nothing to install and no macro to enable.
Can Excel do this without a VBA macro?
Not directly. Excel has no built-in command for it, which is why nearly every answer you find is a VBA macro or a paid add-in. The alternatives are filtering and copying each value into a new workbook by hand, which is fine for three regions and unworkable for sixty, or building a parameterized Power Query. This tool does the same job in a couple of clicks.
What happens to rows where that column is empty?
They are grouped together into one output named "(blank)". Silently dropping them would be the worst possible outcome, so they always come back — and the summary shows you how many there are before you split.
Can I get separate sheets instead of separate files?
Yes. Switch the output to one workbook with a sheet per value and you get a single .xlsx with one tab per value, which is usually the easier thing to email. Sheet names are capped at Excel's 31-character limit, and collisions get a numbered suffix.
Are the headers repeated in every file?
Yes. Every output opens with a bold copy of your original header row, so each file stands on its own and can be sorted, filtered or imported without you adding the headers back by hand.
Why is it warning me about the number of files?
Because more than a hundred outputs usually means the wrong column was picked — an ID, an amount or a timestamp rather than a category. The warning asks you to confirm rather than blocking you, so a genuine split by a hundred stores still works.
Are my files uploaded to a server?
No. Every tool on Excel Toolbox runs in your browser using the open-source ExcelJS and SheetJS libraries. Your workbook is read from your own disk, processed in your browser tab, and written back out as a download. It is never sent to us or to anyone else, which is why the tools keep working if you go offline after the page has loaded.
How large a file can I process?
There is no upload limit, because nothing is uploaded — the ceiling is your device's memory. Files up to about 25 MB are comfortable on a typical laptop. Much larger workbooks will still work but take longer, and processing runs in the page, so leave the tab open until your download starts.