Large Dataset Copier

A massive dataset doesn't always arrive in the same format twice, a Word table, an HTML export, a JSON dump, a spreadsheet, and copying it out in chunks shouldn't require converting to a specific format first just to get started.

Million by Million Rows Copier reads 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, plus WPS Office ET, ETT, WPS, and WPT, loading any of them either by pasting with Ctrl+V or by loading the file directly.

Once loaded, the dataset lives in a local SQLite database rather than memory, and Copy Next Chunk hands it out a million rows at a time by default, adjustable anywhere from 1 to 10,000,000, with the header row included on the clipboard automatically for every chunk.

Six output formats are available for saving chunks to disk as you go: CSV, XLSX, JSON, SQL, TSV, and XML, so whatever format your destination system actually needs, the app can produce it directly rather than requiring a separate conversion afterward.

For datasets that don't need the clipboard-based workflow at all, Export Everything As writes the full dataset to disk in one go, automatically splitting large exports by chunk size, XLSX into multiple sheets, other formats into numbered part files.

Everything runs locally on your PC, aside from a one-time license check. Loading, chunking, 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 supported formats.
3. Click Start Copying Out to lock the dataset in place.
4. Choose your chunk size and auto-save formats.
5. Click Copy Next Chunk to build and copy each piece.
6. Paste each chunk into your destination as you go.
7. Or use Export Everything As to save the full dataset at once.
8. Review your output folder for the saved chunks or export.
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, from Word tables to JSON
• Six output formats: CSV, XLSX, JSON, SQL, TSV, and XML
• SQLite-backed storage handles datasets up to 50,000,000 rows
• Export Everything As for a single, complete export
• Header row included automatically in every chunk
• Automatic splitting of large exports by chunk size
• 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