TurboSoftwares

Turbo Large Data Splitter

Buy now

About the Software

A single Excel sheet stops at about 1,048,576 rows, and a multi-gigabyte export can freeze a computer long before that. Turbo Large Data Splitter cuts such files into smaller ones and merges them back.

Files stream through in one pass, so the limit is free disk space rather than memory. Files over 100 GB work. Input and output formats are independent, so a giant CSV can become several XLSX workbooks in the same pass.

Screenshots

Features

Seven split methods
Rows, file size, column value, date, alphabet range, duplicates and unique values.
Merge tab
Rejoins parts into one file with a single header.
Excel sheets
Use the largest sheet, the first, or one by name.
CSV settings
Set delimiter, encoding and header row, sort huge files, filter rows and remove duplicates first.
Compression
ZIP or GZIP each part, or bundle everything into one archive.
Resume
A checkpoint lets an interrupted job continue where it stopped.
Preview
Shows row count, columns and the expected number of output files.

How to use it

  1. Add your file.
    Browse, drag it in or use Recent Files.
  2. Choose formats.
    Keep “same as input” for a plain split.
  3. Pick a split method.
    Fill in its single setting.
  4. Preview.
    Check the estimate.
  5. Start Split.
    Follow speed and time remaining.

SQL dumps are read line by line as rows and are input only. All processing is offline.

Split methods

Number of rows
The same row count per part, up to 1,000,000.
File size
Starts a new part at a target size in MB, for upload and email limits.
Column value
One file per value, such as Country or Department.
Date column
Files by day, month or year.
Alphabet ranges
A–F, G–L, M–R, S–Z, 0–9 and Other.
Duplicate values
One file of repeats and one of first-seen rows.
Unique values
Keeps only the first occurrence of each row.

Convert while splitting

Turn a giant CSV into several XLSX workbooks, an XLSX sheet into CSV parts, or a large JSON array into flat CSV files. Each line of a SQL dump becomes one record.

Advanced settings and speed

For delimited files, set the delimiter, encoding and header row. Sort by a column with a disk-based merge sort that handles huge files, filter rows with a simple expression, and remove exact duplicates before splitting.

Reading and splitting happen in one ordered pass, which keeps row order correct and makes resuming possible. Compression of finished parts can use up to 128 parallel workers.