Tool to Split Excel file in Windows

Up until the 2007 version, Microsoft Excel used a proprietary binary file format called Excel Binary File Format (.XLS) as its primary format. Microsoft Excel 2007, along with the other products in the Microsoft Office 2007 suite, introduced new file formats. The first of these (.xlsx) is defined in the Office Open XML (OOXML) specification.

Sometimes you need to split large Excel file into smaller pieces, you can use Withdata DataFileSplitter as Excel Splitter (Divider / Breaker)

Split Excel file into multiple files using Withdata DataFileSplitter

Works GREAT in 2025.

Can run in GUI mode, Step by Step, just a few mouse clicks.

Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.


Split Excel file into multiple files in Command Line

After splitting Excel file in GUI, and Saving "split Excel file" session, then you can:

Set scheduled tasks for splitting Excel file

After splitting Excel file in Command Line, then you can schedule and automate "split Excel file" conversion task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for "split Excel file" conversion.
  2. Set scheduled task: On Linux/macOS, use Crontab. On Windows, use scheduled task.

FAQ

How long does it take to split Excel file?

Is it safe to split Excel file using DataFileSplitter?

Can I split Excel file in command line?

Can I split Excel file without Microsoft Excel installed?