Split an Excel file into a file for each company, department or employer
Upload the file, choose the column to split by, and the tool produces a file for each value, lets you merge values into one file and gives you a Summary file with the total of each file.
Five free uses on a full file, then one subscription for all tools.
What is the Split Excel File tool?
Split Excel File is a tool that splits a table (an Excel or CSV file) into a file for each value in a column you choose, such as the company, department or employer, with the option to merge several values into one file. It produces a Summary file with the row count and the total of the numeric columns for each file, all inside your browser without uploading the file to any server.
What does the tool do?
- Splitting by any column: company, department, employer or others
- A separate file for each value, and merging several values into one file with a name you choose
- The total of numeric columns (such as net salary) in each file and in the Summary file
- Matching the sum of rows with the total row in your original file
- Downloading each file separately or everything at once in a ZIP
How it works
- Upload an Excel or CSV file
- Choose the split column and merge values if you wish
- Press “Split the file” and download the files or the ZIP
Who is it for?
Suited to anyone who receives a single payroll or data file and needs to distribute it by company, department or employer so each part reaches its owner.
Your files stay with you
Your files are processed entirely inside your browser on your device, and are never uploaded to any server.
The content and results shown on this site are indicative. They are meant to help with planning and review, and they are not legal, accounting or tax advice, nor a binding regulatory opinion. Regulations and rates may change, so verify with the competent official authorities before relying on any result.
Frequently asked questions
Which file types are supported?
Excel files in xlsx and xls format, and CSV files.
Can I upload more than one file?
Yes. Columns with the same name are merged into one table, which is then split.
Does it keep the original file's formatting?
No. The output files carry the headings and values without the original formatting, with a total row for the numeric columns you choose.
Are my files uploaded to a server?
No. Reading, splitting and exporting all happen inside your browser.
How many free uses are there?
Five uses on a full file after signing in, then a subscription to continue without limits.