Copy Large Datasets

A large dataset earns its size from all kinds of sources, a database export, a Word table, an HTML page, a spreadsheet, and copying it out in batches shouldn't require converting it to a specific format first just to get started.

Million by Million Rows Copier copies large datasets in batches regardless of their original format, reading 33 input formats directly, spanning Word, the Excel family, and other data formats including DBF, CSV, TXT, RTF, ODT, ODS, HTML, XML, JSON, MD, PRN, DIF, and WPS Office formats.

Once loaded, either by pasting with Ctrl+V or loading a file directly, the dataset lives in a local SQLite database, and Copy Next Chunk hands it out in batches of 1,000,000 rows by default, each including the header row automatically for a complete, self-describing paste every time.

Every batch is also saved to disk in your chosen output format, CSV, XLSX, JSON, SQL, TSV, or XML, the moment it's copied, so you build up a permanent, split record of the dataset while you work through the batches manually.

Batch size, called chunk size in the app, adjusts anywhere from 1 to 10,000,000 rows, letting you tune the size of each batch to whatever your destination or workflow actually calls for.

Everything runs locally on your PC, aside from a one-time license check. Loading, batching, and exporting all happen offline, with your dataset never uploaded anywhere. 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.

1. Install Million by Million Rows Copier on your Windows PC.
2. Paste your data with Ctrl+V or load a file in any of 33 formats.
3. Click Start Copying Out to lock the dataset in place.
4. Set your batch size if the default million doesn't fit.
5. Click Copy Next Chunk to build and copy the first batch.
6. Paste that batch into your destination.
7. Click Copy Next Chunk repeatedly for the rest.
8. Review the auto-saved batches in your output folder.
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.

• Reads 33 input formats directly, no conversion needed
• Copies large datasets out in configurable batches
• Header row included automatically in every batch
• Auto-saves each batch to disk in six possible formats
• SQLite-backed storage handles datasets up to 50,000,000 rows
• Batch size adjustable from 1 to 10,000,000 rows
• 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