Split Excel by Column Value
Separate a master .xlsx, .csv, or .tsv spreadsheet into one file per client, region, or category — bundled in a single ZIP archive right in your browser.
Looking to divide a large file into fixed-size chunks instead? Use our row-count CSV splitter for splitting by row count.
| Column Value | Rows | Output Filename |
|---|
Generating Client Documents from Each Group?
One file per client usually means one document batch per client — upload your master spreadsheet directly to TryDoku and generate tailored Word or PDF documents from one template in seconds.
Frequently Asked Questions
How do I split an Excel file by column value?
Drop your .xlsx workbook into the upload area, pick the worksheet you want to process, and choose the target column from the Split by Column menu. The tool immediately previews each unique value, row count, and sanitized output filename so you can click Split Spreadsheet and download everything as a ZIP archive.
Is my spreadsheet uploaded anywhere?
No, your spreadsheet never leaves your device. All workbook parsing, row grouping, filename sanitization, and ZIP packaging run locally inside your browser using JavaScript, so sensitive client lists, invoices, and regional reports are never sent to any external server or stored anywhere online.
What happens to rows with an empty value in the split column?
By default, rows where the chosen split column is empty or whitespace-only are skipped so you do not generate stray files. If you want to keep those records, switch the Empty Values selector to Group as "(blank)" and the splitter will collect them into their own dedicated output file without re-uploading.
Can I split a CSV file instead?
Yes, you can upload .csv and .tsv files in addition to Excel workbooks. Keep the Output Format set to Same as input to emit individual CSV files, or switch it to Excel (.xlsx) if you want each split group converted into a native spreadsheet workbook inside the ZIP.