Pasting a huge table straight into Excel almost always ends the same way: the application freezes, sometimes crashes, and you're left wondering how much of the paste actually went through. Excel's own row limit, roughly 1,048,576 rows per sheet, means anything larger simply can't land in one paste regardless of how patient you are.
Million by Million Rows Copier solves this by handing data out a million rows at a time. Load your dataset once, by pasting with Ctrl+V or loading a file in any of 33 supported formats, then click Copy Next Chunk to put exactly one million rows, header included, onto your clipboard, ready to paste into Excel or wherever else you need it.
Your data is stored in a local SQLite database on disk rather than held in memory, so the app stays responsive whether you loaded a thousand rows or fifty million. Each chunk is also automatically saved to disk in your chosen formats, CSV, XLSX, JSON, SQL, TSV, or XML, the moment it's copied, so a crash never loses more than the chunk in progress.
Chunk size defaults to 1,000,000, matching just under Excel's per-sheet limit, but can be set anywhere from 1 to 10,000,000 rows to match whatever tool you're actually pasting into. Re-copy Current Chunk is always available if something else overwrites your clipboard before you've finished pasting.
Loading, chunk-building, and exporting all run on background threads, so the window itself never locks up while a large dataset processes, a common failure point in tools that try to do this work on the main UI thread.
Everything runs locally on your PC. The only online step is a one-time license check; loading, chunking, and exporting all happen offline after that, with nothing uploaded. Data analysts and engineers moving large extracts between tools, database administrators handing off query results, finance and accounting teams transferring big ledgers, operations and reporting staff assembling data from many sources, and anyone who has ever tried to paste more rows into Excel than it was willing to accept, all use the same underlying workflow. Virtual rendering keeps the loaded-data view smooth even at the upper end of the app's capacity, and every worker thread runs its own SQLite connection in WAL mode, so nothing here depends on your PC having an unusual amount of memory to spare.
- Install Million by Million Rows Copier on your Windows PC.
- Paste your data with Ctrl+V or load a file.
- Click Start Copying Out to lock the dataset in place.
- Choose your auto-save formats and output folder if needed.
- Click Copy Next Chunk to put the first million rows on your clipboard.
- Paste that chunk into Excel or your destination tool.
- Click Copy Next Chunk again for the next million rows.
- Repeat until the full dataset has been copied and pasted.
- Use Re-copy Current Chunk if your clipboard gets overwritten mid-paste.
- Click Open Output Folder to review everything you've saved so far.
- Copies exactly 1,000,000 rows to your clipboard by default, header included
- Chunk size adjustable from 1 to 10,000,000 rows
- Backed by an on-disk SQLite database, not memory
- Auto-saves each chunk to disk in your chosen format as it copies
- Re-copy Current Chunk if your clipboard gets overwritten
- Background threads keep the app responsive during large jobs
- Runs fully offline aside from a one-time license check
- One-time purchase for Windows, with Gumroad license activation
- Choose your own output folder, or use the default under My Documents
- Works with files on local drives, external drives, and network shares
How do I copy 1 million rows and paste them into Excel?
Load your data, click Start Copying Out, then click Copy Next Chunk. The app copies exactly one million rows to your clipboard with the header row included, ready to paste straight into Excel.
Why can't I just paste all my rows into Excel at once?
A single Excel sheet is capped at 1,048,576 rows, so more than 1 million rows cannot fit on one sheet, and pasting hundreds of thousands of rows at once often freezes Excel before you even reach that ceiling.
Does each copied chunk include the header row?
Yes, when you copy a chunk, the header row is placed on the clipboard with the rows, so every pasted chunk is self-describing.
What happens if something overwrites my clipboard mid-paste?
Click Re-copy Current Chunk to put the same chunk back on your clipboard without needing to move forward or start over.
Does this work on both Windows 10 and Windows 11?
Yes, Million by Million Rows Copier is built and tested for both Windows 10 and Windows 11.
Is my data safe when using this tool?
Yes, all processing happens locally on your PC; no data is ever uploaded, so proprietary or sensitive records stay fully under your control.
Where do saved chunks and exports go by default?
A default output folder under My Documents is set automatically at startup, though you can choose a different folder before loading begins.
Can I use this on files stored on an external or network drive?
Yes, files on local drives, external drives, or mapped network shares all load the same as any local file.
What happens if the app is closed partway through a session?
Each chunk is saved to disk automatically the moment it's copied, so a closed app or crash never loses more than the chunk that was in progress.
Is there a trial version available before buying?
Check the product page on turbo-soft.com for current trial availability and details.
Ready to copy 1 million rows at a time, fully offline?