Want to split large Excel file into multiple files by column value without programming?
Using Withdata software Data File Splitter, a Excel splitter for Windows, MacOS, and Linux, you can split big Excel file by column value easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Split Excel file locally, Avoid uploading LARGE Excel file(s) to online services.
Download DataFileSplitter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit
Split large Excel file by column value
Choose source Excel file -> Set splitting Excel options -> Split Excel
Click “New Task” at “Start”.
Choose “Excel” file type.
1. Open Excel file as source.
The Excel file like this:
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.
3. Summary.
4. Split Excel file by column value.
View a result Excel file.
Split Excel by column value in command line
Save “Split Excel” session, then you can:
- Split Excel by column value in Windows command line.
- Split Excel by column value in Linux command line.
- Split Excel by column value in macOS command line.
Set scheduled tasks for splitting Excel by column value
You can schedule and automate this “Split Excel” task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.