Copy 1 Million Excel Rows

A dataset with a million or more rows sits right at the edge of what a single Excel sheet can accept, roughly 1,048,576 rows per sheet, which means copying and pasting the whole thing at once either fails outright or, worse, silently truncates data at the limit.

Million by Million Rows Copier is a large dataset copying tool built specifically for this scenario. Load your Excel data, by pasting with Ctrl+V or loading an XLSX or XLS file, click Start Copying Out, then use Copy Next Chunk to copy exactly 1,000,000 rows at a time, safely under Excel's per-sheet ceiling.

Each 1-million-row chunk includes the header row automatically, so pasting it into a fresh Excel sheet gives you a complete, immediately usable table, no manual header retyping required for each new sheet.

Behind the scenes, your data is stored in a local SQLite database rather than memory, so copying out a 1-million-row chunk, then the next, then the next, stays responsive even as you work through a dataset that could be up to 50,000,000 rows total.

Every chunk is also saved to disk automatically in your chosen formats, XLSX included, the moment it's copied, giving you a permanent, split backup of the full dataset alongside whatever you paste manually.

Everything runs locally on your PC, aside from a one-time license check. Loading, chunking, and exporting all happen offline, with your Excel 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 Excel data with Ctrl+V or load an XLSX or XLS file.
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 a fresh Excel sheet.
6. Click Copy Next Chunk for the next 1,000,000 rows.
7. Repeat until the full dataset has been copied.
8. Check your output folder for the auto-saved XLSX 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
• Stays safely under Excel's roughly 1,048,576-row-per-sheet limit
• Header row included automatically in every chunk
• SQLite-backed storage handles datasets up to 50,000,000 rows
• Auto-saves each chunk to disk, XLSX included
• Chunk size adjustable if you need a different 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