How to Split an Excel File Into Multiple Files (Without Macros)

If you searched "how to split an Excel file," you probably have one large spreadsheet that needs to become several smaller ones. Maybe you need to send each department their own data, or break a national report into regional files, or split survey responses by location before handing them off to different teams.

This comes up constantly: a national sales report that needs to go to four regional managers, an HR export that needs to be split by department, survey data that different teams need to analyse separately.

Excel does not have a built-in "split by column" feature. The usual workaround is filtering, copying, pasting into a new file, clearing the filter, picking the next value, and repeating. For three groups, that is annoying. For twenty, it is an entire afternoon. This guide covers a faster way to do it.

Why filtering and copy-paste fails

It does not scale. Ten unique values means ten rounds of filter, copy, paste, save. A column with fifty unique values is simply not practical to split by hand. Beyond the time cost, here is what else goes wrong:

• Headers get lost or duplicated. You have to remember to copy the header row every time. Miss it once and you have a file with no column names. Copy it twice and you have a row of headers mixed into your data.
• Formatting breaks. Column widths, number formats, and date formats often do not survive the copy-paste process. You end up reformatting every output file.
• It is painfully slow. Filter by one value, select all visible rows, copy, open a new workbook, paste, save, go back, clear the filter, pick the next value. Multiply that by the number of unique values in your column.

How to split Excel files by column value

The column you pick determines how many files you get. If you split a sales report by "Region" and there are four regions, you get four files. If you split by "Account Manager" and there are twelve managers, you get twelve files. Every output file contains only the rows where the column matches that value, with headers included automatically.

Open the Excel Splitter, drop in your file, and pick the column you want to split by. The tool reads every row, groups them by the unique values in that column, and creates one output file per group. You download everything as a single ZIP file.

Step by step

1. Drop your file into the Excel Splitter. It accepts .xlsx, .xls, and .csv files.
2. Choose a column from the dropdown. The tool shows you a preview of how many files will be created and how many rows each one will contain.
3. Click Split. All output files are packaged into a ZIP and downloaded to your device.

No formulas, no macros, no manual filtering.

When to split Excel files

Regional reporting. A national dataset needs to become separate files for each region. Split by the Region column and send each office only the data they need.

Per-manager distribution. An HR or sales report needs to go to individual managers, but each should only see their own team. Split by "Manager" or "Team Lead" and distribute the files directly.

Survey analysis. Responses collected in one form need to be analysed separately by location, department, or question category. Split the master file so each analyst gets only the subset they are responsible for.

Inventory by warehouse. A consolidated inventory file covers multiple locations. Split by warehouse or supplier code so each location can review and update their own stock levels independently.

Client reporting. A consulting or agency export contains data for multiple clients in one file. Split by client name and send each one only their own data - no risk of accidentally sharing one client's numbers with another.

How does this compare to other methods?

	Filter + copy-paste	VBA macro	Power Query	Google Sheets	PicoTools
Time for 10 groups	30-60 min	5-10 min (after writing macro)	10-20 min	Not built-in	Under a minute
Skill needed	None	VBA programming	Power Query knowledge	Apps Script knowledge	None
Works on Mac	Yes	Limited	No (Windows only)	Yes (browser)	Yes (any browser)
Handles large files	Yes (but slow)	Yes	Yes	Limited	Yes
Reusable for new files	Start over every time	Yes (if macro is saved)	Yes (if query is saved)	Needs new script	Yes
No software needed	No	No	No	No (needs Google account)	Yes

Your files never leave your device

All processing happens locally in your browser. Your files are not uploaded, stored, or transmitted anywhere. This makes it safe to use with client data, financial records, employee information, or anything confidential.

---

Frequently asked questions

Can I split .xlsx and .csv files?

Yes. The tool supports .xlsx, .xls, and .csv files. All output files are saved as .xlsx.

How many files can it split into?

As many as there are unique values in your chosen column. If the column has 50 unique values, you get 50 files. There is no fixed limit on the number of output files.

What happens to the headers?

Every output file includes the full header row automatically. You do not need to copy headers manually.

Can I split by more than one column at the same time?

The tool splits by one column at a time. If you need a two-level split (for example, by Region and then by Manager), run the splitter once on the first column and then again on each output file for the second column.

Is there a file size limit?

There is no strict limit. Since everything runs in your browser, performance depends on your device. Most users split files with tens of thousands of rows without issues.

Does it work on a Mac?

Yes. The tool runs entirely in your browser, so it works on Mac, Windows, Linux, Chromebook, or any device with a modern browser.

Is it safe to use with confidential data?

Your files never leave your device. Nothing is uploaded, stored, or visible to anyone. Processing happens entirely in your browser, and all data is gone when you close the tab.