1 Million Row Copier

Copy large data in million-row chunks, without Excel freezing

Copy Large Data in Million-Row Chunks

Database exports, analytics dumps, and system extracts routinely produce far more rows than a spreadsheet can accept in one paste. Trying to move that data with a single copy and paste either fails outright or locks up the destination application while it struggles to process an enormous single operation.

Million by Million Rows Copier moves large data in million-row chunks instead. Load everything once, by pasting with Ctrl+V or loading a file in any of 33 supported formats, and the app hands the data out a manageable chunk at a time, letting any destination accept it piece by piece rather than all at once.

Chunk size defaults to 1,000,000 rows, fitting neatly under Excel's per-sheet limit, but can be set anywhere from 1 to 10,000,000 to match whatever tool you're pasting into. Each chunk includes the header row automatically, so every piece you paste is immediately usable on its own.

Data is stored in a local SQLite file rather than kept in memory, so loading, chunking, and exporting all stay responsive even at the upper end of the app's 50,000,000-row capacity, with every chunk auto-saved to disk in your chosen format the moment it's built.

Worker threads run independently, so building the next clipboard chunk and auto-saving the previous one to disk genuinely happen in parallel rather than queuing behind each other, keeping the overall process quick even for very large datasets.

Everything runs locally on your PC, aside from a one-time license check. Loading, chunking, and exporting all happen offline, with nothing uploaded during the process. 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.

Million by Million Rows Copier

Million by Million Rows Copier - main window
App Screenshots
Home Screen - Before Loading Data
Load Controls - Paste or Load From File
Choosing an Output Folder
Chunk Size and Header Row Options
Auto-Save Format Checkboxes
Loading a Large Dataset - Progress Bar
Export Everything as pop-up
Help & Guide
Loaded Data
Enlarged application screenshot
How to Copy Large Data in Million-Row Chunks
  1. Install Million by Million Rows Copier on your Windows PC.
  2. Paste your data with Ctrl+V or load a file.
  3. Click Start Copying Out to lock the dataset in place.
  4. Set your chunk size if you want something other than the default million.
  5. Click Copy Next Chunk to build and copy the first piece.
  6. Paste the chunk into your destination.
  7. Click Copy Next Chunk repeatedly to work through the rest of the data.
  8. Open your output folder to review the auto-saved chunks.
  9. Use Re-copy Current Chunk if your clipboard gets overwritten mid-paste.
  10. Click Open Output Folder to review everything you've saved so far.
Why Use This 1 Million Row Copier
  • Hands out data in million-row chunks instead of one giant paste
  • Header row included automatically in every chunk
  • Chunk size adjustable from 1 to 10,000,000 rows
  • SQLite-backed storage keeps the app responsive at any scale
  • Parallel worker threads for chunk building and auto-save
  • Handles datasets up to 50,000,000 rows in one session
  • 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
Frequently Asked Questions

Why does pasting all my data at once fail or freeze?

Destination applications, especially Excel, struggle with very large single paste operations, either rejecting rows past their limit or freezing while attempting to process an enormous amount of data in one go.

Does chunking mean I lose the column headers on later chunks?

No, every chunk includes the header row on the clipboard, so each piece is self-describing whether it's the first chunk or the last.

Can I use a chunk size other than one million?

Yes, chunk size can be set anywhere from 1 to 10,000,000 rows to match whatever tool or limit you're working around.

How large a dataset can this handle in one session?

Up to 50,000,000 rows, stored in a local SQLite database rather than memory, so the app stays responsive throughout.

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 your large data in million-row chunks, fully offline?

Related guides and tools

This guide is part of TurboSoft’s large row copying resources. Million by Million Rows Copier handles all of these tasks offline on Windows.

Get Million by Million Rows Copier →