Copy 1 Million CSV Rows

A CSV export with a million or more rows is common enough from database dumps and analytics platforms, but getting that many rows into Excel, or any tool that accepts data through the clipboard, means the copy has to happen in pieces small enough for the destination to accept.

Million by Million Rows Copier is a bulk data copy tool built for exactly this. Load your CSV data, by pasting with Ctrl+V or loading the file directly, click Start Copying Out, then use Copy Next Chunk to copy exactly 1,000,000 rows at a time, ready to paste wherever the data needs to go.

Every 1-million-row chunk includes the header row automatically, so each paste is a complete, self-describing table, and every chunk is saved to disk in your chosen format the moment it's copied, CSV included, giving you a permanent record of every piece.

Your CSV data is stored in a local SQLite database once loaded, rather than kept in memory, so copying out one million-row chunk after another stays fast and stable, all the way up to the app's full capacity of 50,000,000 rows in a single session.

Chunk size defaults to 1,000,000 rows, matching just under Excel's per-sheet limit, but can be adjusted anywhere from 1 to 10,000,000 if your destination needs a different size.

Everything runs locally on your PC, aside from a one-time license check. Loading, chunking, and exporting all happen offline, with your CSV data 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 CSV data with Ctrl+V or load the CSV file directly.
3. Click Start Copying Out to lock the dataset in place.
4. Click Copy Next Chunk to copy the first 1,000,000 rows.
5. Paste that chunk into your destination.
6. Click Copy Next Chunk for the next 1,000,000 rows.
7. Repeat until the full CSV file has been copied.
8. Check your output folder for the auto-saved CSV 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.

• Copies exactly 1,000,000 rows per chunk by default
• Loads CSV files directly, or accepts pasted CSV data
• Header row included automatically in every chunk
• Auto-saves each chunk to disk as CSV or other formats
• SQLite-backed storage handles CSV files up to 50,000,000 rows
• Chunk 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