\n \n
#211 · Merge Split & Organize Tool

Split CSV by Column Value

Split one CSV or spreadsheet into separate CSV files based on the values in a chosen column, then download the parts together as a ZIP.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the source file.
  2. Select the worksheet and review the header-row setting.
  3. Click Split CSV and provide any requested operation details.
  4. Review the bounded preview and download the newly generated result.

What this tool does

Split one CSV or spreadsheet into separate CSV files based on the values in a chosen column, then download the parts together as a ZIP.

Each distinct value in the selected column becomes one CSV file; the header row is repeated and unsafe file-name characters are removed.

Keep the original file until you have opened and checked the downloaded result in your preferred spreadsheet application.

Supported formats

XLSX, XLS, CSV, and TSV can be read in the browser. Output is generated as XLSX, CSV, or ZIP according to this operation.

FormatUse
XLSX / XLSWorkbook input
CSV / TSVDelimited table input
Generated resultNew downloadable file

Tips for better results

  • Work from a copy when the workbook contains business-critical records.
  • Check header spelling, identifiers with leading zeros, and date cells after export.
  • Remove passwords before processing; encrypted workbooks cannot be opened here.
  • For very large files, split the source into smaller worksheets first.

FAQ

Does split csv by column value upload my workbook?

No. The selected files are read and processed locally by JavaScript in your browser.

Which spreadsheet formats work with this tool?

XLSX, XLS, CSV, and TSV inputs are accepted where the selected operation applies. The page reports parsing errors instead of claiming a damaged file was processed.

Will formulas and advanced Excel features be preserved?

Basic cell values and formulas are handled, but macros, external links, charts, pivot tables, and application-specific features may not be fully preserved.

Can I use this with large workbooks?

Moderate files work best in a browser. The tool rejects files over 25 MB and limits the on-screen preview so thousands of rows are not inserted into the page.

How should I verify the downloaded result?

Open the output in your spreadsheet application and review a few representative rows, dates, identifiers, and formulas before replacing an original file.

Processing notes

AreaBehavior
PrivacyLocal browser processing
PreviewLimited to 100 rows
ResultNew ZIP blob

Browse more office tools

Office tool hubs