How to Copy and Paste a Lot of Data in Excel

When people ask how to copy and paste a lot of data in Excel, the real question is usually how to do it without the paste stalling, the file bloating, or rows going missing. A worksheet can only ever hold 1,048,576 rows, so a lot of data almost always means splitting the job into pieces.

Million by Million Rows Copier automates that splitting. Load your file or paste your data, and the app stores it in a local SQLite file capable of holding up to 50,000,000 rows, well beyond what any single worksheet could take.

From there, Copy Next Chunk hands the data out in clean 1,000,000-row pieces, ready to paste into Excel one sheet at a time. Because the app tracks how much has already been handed out, you always know exactly how much of the dataset remains.

This turns a task that would otherwise mean manually cutting a spreadsheet into pieces into a simple repeat-and-paste loop that takes minutes instead of hours.

1. Load your file, or paste your data directly, into Million by Million Rows Copier.
2. Let the app finish storing the data locally; progress is shown as it loads.
3. Click Start Copying to begin handing data out in chunks.
4. Click Copy Next Chunk, then paste into a new worksheet in Excel.
5. Repeat until the app confirms that the entire dataset has been copied out.

• Loads and stores up to 50,000,000 rows in one session
• Hands data out in 1,000,000-row chunks sized for a single worksheet
• Tracks how many rows remain, so you always know what's left
• Loads more than 25 input formats without manual conversion first
• Runs loading and copying on background threads so the app never locks up
• Auto-saves every chunk to disk as a built-in backup