Split a large Excel file into separate files for each worksheet at one time

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.

Download DataFileConverter

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.

2) Set scheduled task.

---

More about DataFileConverter – Excel sheet splitter

• 
• 
•