TurboSoftwares

Turbo CSV Splitter

Buy now

About 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

  1. Load a CSV.
    Browse or drop it onto the window.
  2. Choose an output folder.
    Confirm delimiter and encoding.
  3. Pick a method.
    Add column or filter options if needed.
  4. 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.