TurboSoftwares

Million by Million Rows Copier

Buy now

About the Software

Pasting hundreds of thousands of rows into Excel can lock it up, and one worksheet holds only about 1,048,576 rows. Database exports and analytics dumps are often far bigger.

Million by Million Rows Copier loads the data once into a local database, then hands it out in even chunks. Each chunk goes to your clipboard with its header row and is saved to disk automatically.

Screenshots

Features

Chunk size
One million rows by default, adjustable from 1 to 10,000,000.
Re-copy
Puts the current chunk back on the clipboard without advancing.
Auto-save
Write each chunk as CSV, XLSX, JSON, SQL, TSV or XML.
Header detection
Applies to CSV, TXT, the Excel family, ODS, DBF, PRN and DIF, and repeats in every chunk.
Cancel safely
Cancelling a load keeps the rows already read.
Export everything
Writes the full dataset as numbered parts, or as multiple sheets in one workbook.
Manifest
A manifest.json and summary.txt list every file produced.

Why it does not freeze

Rows live in a SQLite database on disk, not in memory. The preview grid only draws about 60 rows at a time, and slow tasks run in background threads, so the window stays responsive at 50 million rows.

How to use it

  1. Load.
    Paste with Ctrl+V or load a file.
  2. Start Copying Out.
    This locks the dataset.
  3. Paste chunk one.
    Into Excel or another tool.
  4. Copy Next Chunk.
    Repeat until finished.

Everything runs offline, so data that cannot be uploaded stays on your PC.

What it solves

Excel freezing or crashing when you paste a huge table, and datasets beyond the 1,048,576-row limit. It also helps when tools only exchange data through copy and paste, and it extracts tables from Word, HTML, JSON and XML as well as spreadsheets.

Main controls

Paste All Data appends each paste until you start a new session. Load From File accepts many formats. Start Copying Out locks the dataset, then Copy Next Chunk steps through it. Export Everything As writes the whole dataset in the formats you choose, with XLSX output split into multiple sheets and other formats into numbered parts.

Supported formats

Load files in many formats, including CSV, TXT, the Excel family, ODS, DBF, PRN and DIF, or paste straight from the clipboard. Auto-save writes each chunk to CSV, XLSX, JSON, SQL, TSV or XML the moment it is copied, so a crash never loses more than the chunk in progress.

A 50-million-row dataset becomes fifty paste operations, and a progress bar shows how many rows have been handed out so far.