Want to split a large Excel file into separate files for each worksheet at one time?
Using DataFileConverter, a native GUI tool, 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.
- Split Excel locally, Avoid uploading LARGE Excel file(s) to online services.
- Support Windows, Linux, macOS.
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.