Split an .xlsx spreadsheet into separate files by the values in a column, by sheet, or every N rows. Formatting stays, each file holds only its own rows, and it works offline.
Get Spreadsheet Splitter on the Microsoft Store 日本語のページ
Windows only. Your file is only read and nothing goes over the network.
Pick a column and rows with the same value go into one file. The preview under the column lists every file with its row count before anything is written, and an empty value becomes a (blank) file instead of being dropped. The header rows, up to the row you set, stay on top of every file.
Each file holds only its own rows. Other people's rows, other sheets, hidden sheets and the author's name are left out. Values calculated from other rows stay as values, so the result screen lists them in the Check before you hand them out box with a count and examples.
By sheet turns each sheet into a file. A formula that reads another sheet would point at nothing, so it becomes its saved value, and a drop-down list that reads another sheet is taken out. The counts and examples are shown.
Write CSV in UTF-8 with BOM or in Shift-JIS. Characters Shift-JIS cannot hold are counted and listed, with the file and row, right after writing. One button writes the files again in UTF-8.
A workbook with a table, pivot table, chart, picture or comment is refused with the reason in a red box, and nothing is written. CSV output reads values only, so it can still be used. Macro files (.xlsm) are not read.
Open the .xlsx, choose By column value in step 2, pick the column (for example the person in charge) and press Split. Rows with the same value go into one file, and the files that will be made are listed with their row counts before you start.
No. Spreadsheet Splitter reads and writes .xlsx itself, so no other app is needed. Excel is not started.
In .xlsx output colours, borders, column widths, frozen rows, filters and conditional formatting are kept. In CSV output only the values are written.
No. Each file holds only its own rows. Other sheets, hidden sheets and the author's name are left out. One thing to check: values calculated from other rows, such as running totals and ranks, stay as values and may still hold everyone's total. The result screen lists them in the "Check before you hand them out" box with a count and examples. The app can only spot values that come from formulas, so open one file and look before you hand them out.
When each file holds one sheet, a formula that reads another sheet is replaced by its saved value and a drop-down list that reads another sheet is taken out. The result screen shows how many. Formulas within the same sheet stay formulas.
Yes. Every N rows cuts the data into files of N rows with the header rows on top of each. The names are numbered.
Yes, in UTF-8 with BOM or in Shift-JIS. Characters Shift-JIS cannot hold are written as "?", and the result screen counts them and lists examples right after writing. One button writes the files again in UTF-8. In CSV, dates are written as yyyy/MM/dd and numbers without their display format.
Excel for the web with an English display may show a Shift-JIS CSV as garbled text. Choose CSV (UTF-8 with BOM) if you open the files there.
It refuses what it could damage and writes nothing, with the reason on screen: tables, pivot tables, charts, pictures, comments, macros (.xlsm), the old .xls format and password-protected files. Only .xlsx is read; .xlsb is not.
Measured on made-up data on the author's test PC: a 100,000-row sales sheet split by person into 6 files in about 6 to 8 seconds. Other PCs and larger files were not measured.
No. The original is only read. Nothing goes over the network and there is no account. An existing file is never overwritten; a number is added to the name instead.
Get Spreadsheet Splitter on the Microsoft Store
Microsoft, Windows and Excel are trademarks of Microsoft Corporation. This page and the app are not affiliated with, made or endorsed by Microsoft.
Questions? Support or support@hullspark.com.
Hullspark