Want to split large Excel file into multiple files by object count without programming?
Using Withdata software Data File Splitter, a Excel splitter for Windows, MacOS, and Linux, you can split big Excel file into multiple files 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 into multiple files
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 object count.
If you want to split by column value, see this: Split Excel by column value.
3. Summary.
4. Split Excel file into multiple files.
View a result Excel file.
Split Excel into multiple files in command line
Save “Split Excel” session, then you can:
- Split Excel into multiple files in Windows command line.
- Split Excel into multiple files in Linux command line.
- Split Excel into multiple files in macOS command line.
Set scheduled tasks for splitting Excel into multiple files
You can schedule and automate this “Split Excel” task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.