Turbo CSV Splitter
Buy nowAbout the Software
Turbo CSV Splitter is for CSV files that have outgrown a spreadsheet. It breaks a huge file into smaller, well-formed parts, joins parts back together and inspects columns for data-quality problems.
Rows stream through one at a time, so memory use stays flat whatever the file size. Delimiters and encodings are detected for you.
Screenshots
Features
- Nine split methods
- Row count, file size, column value, date, alphabet range, duplicates, unique values and equal parts.
- Column tools
- Keep, drop and rename columns, add a row number and run find and replace with optional regex.
- Filter and sort
- Simple or advanced filters, an external sort for huge files and duplicate removal.
- Output control
- Change the delimiter, quoting and line endings, and compress parts with ZIP or GZIP.
- Merge tab
- Combine files under one header, optionally tagging each row with its source.
- Profile tab
- Counts blanks and distinct values per column and flags ragged rows.
- Resume
- Cancelled jobs continue from a checkpoint.
How to use it
- Load a CSV.
Browse or drop it onto the window. - Choose an output folder.
Confirm delimiter and encoding. - Pick a method.
Add column or filter options if needed. - Preview, then Start Split.
Follow rows per second and time remaining.
No upload, account or subscription is involved. Everything runs on your PC.
Split methods
- Number of rows
- The same count per file, up to 1,000,000.
- File size
- Rolls over at a target size in MB.
- Column value
- One file per distinct value.
- Date column
- Groups by day, month or year.
- Alphabet
- A–F, G–L, M–R, S–Z, 0–9 and Other.
- Duplicate values
- Separates repeats from first-seen rows.
- Unique values
- Keeps the first occurrence only.
- Equal parts
- Exactly N files of similar size.
Delimiters and encodings
Comma, semicolon, tab and pipe delimiters are detected, along with UTF-8, UTF-8-SIG, UTF-16, CP1252 and Latin-1. A worker slider from 1 to 128 speeds compression of many parts. Drop a file onto the window, or send the app to the system tray during a long job.
Column tools and filters
Keep only some columns, or drop others. Rename columns with pairs such as old:new, and add a row-number column starting at 1. Find and replace rules can be limited to one column and can use regex.
A simple filter picks a column, an operator such as equals, contains or is blank, and a value. The advanced filter takes an expression. An optional chunked external sort orders even huge files, and Remove Duplicate Rows drops exact repeats before the split.
Parts can be named with a custom base name, written as plain CSV or compressed, and bundled into one archive.