How to split an excel payroll sheet into department-specific files for secure distribution
- Step 1Export the consolidated payroll to Excel — Download the full payroll as .xlsx with a Department column.
- Step 2Enter 'Department' as the split column — Type the column header name (e.g. 'Department', 'Cost Centre', 'Division').
- Step 3Distribute the multi-sheet workbook — The output .xlsx has one sheet per department. Share with respective managers and partners.
Frequently asked questions
Can the tool output each department as a separate file instead of separate sheets?+
ZIP-packaged separate files are on the roadmap. Currently all departments are in one multi-sheet .xlsx.
Is payroll data safe to process in a browser tool?+
Yes. The tool is 100% client-side — no file is uploaded to any server. Data processing occurs entirely in your browser's memory.
What if a department name contains a slash (/) or other special characters?+
Excel sheet names cannot contain / \ * ? [ ] characters. The tool replaces these with underscores in the sheet name automatically.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.