CSV Splitter is a free, open-source desktop app for splitting large CSV, TXT, XML, and log files into smaller parts that are easier to open in Excel and other tools.
Download the latest Windows executable or run from source with Python.
Microsoft Excel worksheets are limited to 1,048,576 rows. When a source file is larger than that, CSV Splitter lets you choose a practical row count and generate numbered output files that stay easier to open, inspect, and share.
Use it when you need to:
- Split a large CSV file before Excel's 1,048,576-row worksheet limit gets in the way.
- Break large text-based exports into smaller numbered files.
- Keep the original header row at the top of every generated part.
- Use a simple Windows desktop GUI instead of command-line scripts.
- Split CSV, TXT, XML, log, and other text-based files into numbered parts.
- Choose how many data lines should go into each output file.
- Optionally copy the source header row into every generated part.
- Prevent accidental overwrites of existing output files.
- Cancel long-running line counts or split jobs.
- Build a standalone Windows executable with PyInstaller.
- Open the latest release.
- Download
CSV_Splitter_windows.exe. - Run the executable and select the file you want to split.
Install the required Python dependencies with:
pip install -r requirements.txtLaunch the graphical interface with:
python csv-splitter.pySet "Lines per file" below your target row limit. When "Include header in each part" is enabled, the header row is added to each output file in addition to the selected data-line count.
pyinstaller csv-splitter.py --clean --noupx --noconsole --noconfirm --onefile --windowed --icon=app_icon.ico --add-data "app_icon.ico;."Install pytest, then run the test suite:
pip install pytest
pytest -qThis project is released under the MIT License.
