Split large EXCEL file by column value

by

Want to split large Excel file into multiple files by column value without programming?

Try Withdata Data File Splitter, a desktop Excel splitter for Windows, MacOS, and Linux, Split big Excel file by column value, Easy and Fast.

Download Withdata DataFileSplitter Download DataFileSplitter

Split large Excel file by column value

Choose source Excel file -> Set splitting Excel options -> Split Excel

Click “New Task” at “Start”.

Split big Excel file by column value - new task

Choose “Excel” file type.

Split big Excel file by column value - select file type

1. Open Excel file as source.

Split big Excel file by column value - open source Excel file

The Excel file like this:

Split big Excel file by column value - view the source excel file

2. Config Excel file splitting options, split by column value.

If you want to split by object count, see this: Split Excel by object count.

Break big Excel file by column value - config splitting options

3. Summary.

Break big Excel file by column value - summary

4. Split Excel file by column value.

Split big Excel file by column value - split

View a result Excel file.

Split big Excel file by column value - view a result excel file


More about Excel Splitter