Want to split a large Excel file into separate files for each worksheet at one time?
Using Data File Converter, a native GUI tool for Windows, MacOS, and Linux, you can split each Excel worksheet into separate Excel 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.
- Filter files locally and privately, avoid uploading Excel file(s) to online services.
Download DataFileConverter
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 a large Excel file into separate files for each worksheet
Choose source Excel file -> Set target Excel files -> Split Excel
Click “Start a New Convert” at task dialog.
then show the wizard.
Select From “File” “Excel” To “Files” “Excel”.
1. Open a source Excel file, select sheets to split to smaller Excel files.
2. Config target target Excel files.
3. Summary.
List selected sheets.
4. Split a large Excel file into separate files for selected sheets.
After converting, you can view output Excel files.
Split Excel by sheets in command line
Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.
Set scheduled tasks for splitting Excel
You can schedule and automate this Excel splitting task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.