The maximum number of rows you can copy and paste in Excel is bound by the worksheet limit itself: 1,048,576 rows. In practice, the safe working number is often lower, since very wide datasets or formatted cells can make the clipboard buffer choke well before that ceiling is reached.
This is why a dataset with several million rows cannot simply be selected and pasted in one motion. Excel either refuses the paste outright or accepts only the rows that fit, silently leaving the rest behind.
Million by Million Rows Copier treats this limit as a known constant rather than a barrier. It loads your full dataset, up to 50,000,000 rows, into a local SQLite file, then serves the data back out in 1,000,000-row chunks, a size chosen specifically to stay comfortably under Excel's maximum.
Each chunk is copied to the clipboard on demand with Copy Next Chunk, so you paste one safe block at a time instead of guessing how many rows Excel will actually accept.
- Load your dataset into Million by Million Rows Copier, whether it is a CSV export, an XLSX file, or a pasted SQL result.
- Review the row count the app reports after loading, so you know exactly how many chunks lie ahead.
- Adjust the chunk size if needed, keeping it at or below Excel's maximum for a safe margin.
- Use Copy Next Chunk to place the first block on the clipboard.
- Paste into Excel, move to a new sheet, and repeat Copy Next Chunk until the dataset is fully transferred.
- Chunk size defaults to 1,000,000 rows, safely under Excel's 1,048,576-row maximum
- Supports datasets up to 50,000,000 rows in a single session
- Adjustable chunk size for smaller worksheets or slower machines
- Header row is preserved on every chunk automatically
- Local SQLite storage prevents the app from running out of memory on huge files
- Manifest and summary logs show exactly how many chunks were copied
What is the actual max number of rows you can copy and paste in Excel?
Excel worksheets support up to 1,048,576 rows, and that number is the hard ceiling for any paste operation, not just a recommendation.
Why does a large paste sometimes fail before reaching that number?
Wide datasets, heavy formatting, or clipboard buffer limits in Windows can cause a paste to fail before the row count alone would explain it.
How do I safely move a dataset with more rows than that maximum?
Load it into Million by Million Rows Copier and use Copy Next Chunk to move it in 1,000,000-row pieces, each one comfortably below Excel's limit.
Can I choose a smaller chunk size than 1,000,000 rows?
Yes, the chunk size is adjustable, which is useful on slower machines or when working with unusually wide columns.
Stop guessing at Excel's row limit and start copying in chunks that always fit.