Million by Million Rows Copier
Buy nowAbout 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
- Load.
Paste with Ctrl+V or load a file. - Start Copying Out.
This locks the dataset. - Paste chunk one.
Into Excel or another tool. - 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.
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.