Skip to main content
Data and spreadsheets

Split an Excel file by column

Choose a grouping column and generate an Excel workbook containing a separate sheet for each value.

  • 100% local
  • Instant
  • Free
  • No account
  • Works offline
  • Batch processing

Your files are processed locally in your browser and are never sent to our servers.

Drop your file here

Recommended size: up to 30 MB

Split an Excel table into multiple worksheets based on values from a grouping column.

Guide

How to use this tool

  1. 1

    Import the table

    Add the file to split.

  2. 2

    Choose the column

    Select the field used to create groups.

  3. 3

    Export the workbook

    Download a workbook with one sheet per group.

Tips and best practices

  • Work on a copy when your data is important.
  • Review the result before reusing it in another application.
  • Processing takes place directly in your browser.

Frequently asked questions

How are worksheet names generated?

They are derived from column values and adjusted to Excel worksheet naming constraints.

Is my data uploaded?

No. Processing happens locally in your browser.

Can I use this tool for free?

Yes. The tool is free and requires no account.

You may also like

Data and spreadsheets

Clean an Excel or CSV file

Remove duplicates, empty rows and unnecessary spaces.

100% localNewFeatured
Use this tool
Data and spreadsheets

Merge Excel or CSV files

Combine several tables into one file.

100% localNewFeatured
Use this tool
Data and spreadsheets

CSV ↔ JSON converter

Convert CSV data to JSON and back.

100% localNewFeatured
Use this tool
Data and spreadsheets

Split a list

Split a list into equally sized groups.

100% localNew
Use this tool

Latest additions

Images

Resize an image

Change the dimensions of a PNG, JPEG or WebP image.

100% localNewFeatured
Use this tool
PDF and documents

Merge PDF files

Combine several PDF files in the selected order.

100% localNewFeatured
Use this tool