Million by Million Rows Copier is a windows desktop application which loads millions of rows into a high-performance local database, then copies and exports them in configurable million-row chunks for easy pasting into Excel, database tools, or other applications. With virtual rendering, background processing, and support for numerous file formats, it delivers smooth, reliable performance even with extremely large datasets.
- Step 1 - Load everything into the app. Paste your data with Ctrl+V or load a file. It goes straight into a local SQLite file on disk, never into one giant list in memory, so the app stays light no matter the size. Loading a new file or paste replaces whatever was loaded before, after a confirmation prompt, so each load is a fresh, standalone conversion rather than a merge.
- Step 2 - Click "Start Copying Out." This locks the loaded dataset in place, so chunk numbering stays consistent from the first chunk to the last.
- Step 3 - The app builds the first chunk. It takes the first 1,000,000 rows, puts them on your clipboard with the header row included, and saves them to disk in your chosen format (CSV, XLSX, JSON, SQL, TSV, or XML) right after.
- Step 4 - Paste that chunk wherever it needs to go - Excel, another database tool, or any destination that accepts pasted data. This is where you copy and paste 1 million rows at a time, which is exactly why this app exists: Excel itself only holds about 1,048,576 rows per sheet.
- Step 5 - Click "Copy Next Chunk." The app puts rows 1,000,001-2,000,000 on your clipboard and saves that chunk too. "Re-copy Current Chunk" is always available if something else overwrites your clipboard first.
- Step 6 - Repeat until every row has been handed out, million by million, until the full dataset, however large, has been copied and pasted in full.
▶ Rows Live on Disk, Not in Memory
Rows are never all held in memory at once. Everything lives in a local SQLite file on disk, which comfortably pages through tens of millions of rows on a normal laptop - the same design that makes this a reliable Excel copier for oversized datasets.
▶ A Truly Virtual Preview Grid
The on-screen grid only ever creates around 60 row widgets, whether the table holds 1,000 rows or 50,000,000. Scrolling simply re-queries SQLite for the rows currently in view, so the preview never slows down as your data grows.
Background Threads for Every Slow Task
Parsing pasted or loaded text, inserting into SQLite, building clipboard chunks, and exporting all happen on background threads. The window itself only reads a thread-safe queue and updates labels and progress bars, which is what keeps this copy and paste software from ever freezing.
Rowid Seeking Instead of Slow Offsets
Later chunks are fetched with a direct rowid seek rather than a slow row-by-row scan, so copying rows 40,000,001-41,000,000 is just as fast as copying rows 1-1,000,000. Copying large data and pasting it one by one never gets slower the deeper you go into the dataset.
Each Chunk Is Saved the Moment It's Copied
Every 1,000,000-row chunk you hand out is written to disk immediately after it lands on your clipboard, so a crash or an accidental close never loses more than whatever chunk was still in progress.
One Connection Per Thread
Each worker thread gets its own SQLite connection running in WAL mode, so building the next clipboard chunk and auto-saving the previous one to disk genuinely run in parallel instead of queueing behind each other.
Most of these are document formats, not just spreadsheets - loading one pulls out whatever looks like tabular data, whether that is an Excel sheet, a Word table, an HTML table, or plain delimited text.
If a file's extension is not recognized, the app checks its actual content and loads it correctly anyway, which is handy for misnamed or unusually named exports coming out of SQL tools.
Every chunk can auto-save to disk in any combination of these formats the moment it is copied. Exports larger than one chunk are split automatically: XLSX gets multiple sheets in one workbook, while CSV, JSON, SQL, TSV and XML get numbered files, such as name_part001.csv and name_part002.csv, so nothing ever exceeds a format's row limit.
▶ 1,000,000-Row Chunked Copying
The core of this copy and paste app: data is handed out in clean, Excel-safe chunks of 1,000,000 rows, adjustable up to 10,000,000, each copied to the clipboard with its header row included and ready to paste immediately.
▶ Handles Up to 50 Million Rows
Built for anyone who needs to copy paste more than 1 million rows in Excel, this app breaks a 50-million-row dataset into fifty manageable, one-at-a-time paste operations, with nothing ever held entirely in memory.
Adjustable Chunk Size
Set the chunk size anywhere from 1 to 10,000,000 rows to match the row limit of your destination tool, not just Excel's.
Re-copy Current Chunk
Puts the same chunk back on your clipboard at any time, without rebuilding or advancing, which is useful the moment something else gets copied over it.
Export Everything As...
Writes the full dataset to disk in one go, in any combination of CSV, XLSX, JSON, SQL, TSV or XML, independent of the per-chunk auto-save settings.
Cancel Load, Keep What's Loaded
Cancelling a load part-way through keeps every row already read and simply stops before adding more, so a long paste or file load is never all-or-nothing.
Automatic Header Row Detection
"First row is a header" applies wherever the source data genuinely has one, including CSV, TXT, the Excel family, ODS, DBF, PRN and DIF, and every copied chunk repeats that header row so a fresh destination sheet always shows column names.
Live Load, Copy and Export Progress
Rows-per-second, percentage complete, and an overall "handed out so far" bar are all shown live, so you always know exactly where a multi-million-row job stands.
Choose Your Own Output Folder
A default output folder under My Documents is set automatically, though you can choose a different folder of your own before loading begins.
Session Manifest and Summary
Once every chunk has been copied, the app writes a manifest.json file and a summary.txt file listing every file produced during the session, for an easy audit trail.
Gumroad License Verification
Licensing is handled through Gumroad, the same activation system used across every TurboSoft app.
100% Offline - No Internet Required
Loading, copying, and exporting all happen locally on your PC. An internet connection is used only for one-time license activation.
- Nothing Lost on a Crash - Each chunk is saved to disk the instant it is copied, so an accidental close never loses more than the chunk currently in progress.
- No Silent Merging - Loading a new file or paste always asks for confirmation before replacing existing data, so a source is never accidentally merged with a different one.
- Excel-Safe by Design - Chunk size and export splitting keep every output file within its format's real row limits, including Excel's 1,048,576-rows-per-sheet cap.
- Cancel-Safe Loading - Cancelling a load keeps everything already read; nothing after the cancel point is added, and nothing before it is lost.
- Stable at Extreme Row Counts - Behavior stays consistent whether a dataset is 10,000 rows or 50,000,000 rows.
- Ideal for SQL Exports - Purpose-built for the common case of pulling a large query result out of SQL and then pasting it into Excel or another tool, chunk by chunk.
Million by Million Rows Copier is a fully local desktop application. Every row you load, copy, or export is processed entirely on your own computer. No data is uploaded, scanned remotely, or shared with third parties.
- Does not log, analyze, track, or store the contents of your data
- No integration with third-party analytics, advertising trackers, or background telemetry
- Internet is used only for license validation, and that request contains no data content whatsoever
- Well suited to confidential exports from SQL databases, HR systems, and financial spreadsheets
- Complete confidentiality for personal, professional, and enterprise data-handling workflows
| Operating System | Windows 8 (64-bit) |
| Processor | 1-2 CPU cores |
| Memory | 2 GB RAM |
| Storage | 500 MB free disk space, plus room for exported chunks |
| Operating System | Windows 10 or later (64-bit) |
| Processor | 4 or more CPU cores |
| Memory | 8 GB RAM or more for datasets above 10 million rows |
| Storage Type | SSD recommended for the fastest chunk copy and export speed |
| Free Disk Space | 2 GB or more, plus space for every exported chunk |
| App Name | Million by Million Rows Copier |
| Platform | Windows |
| Category | Data Tools |
| Max Rows Supported | 50,000,000 |
| Default Chunk Size | 1,000,000 rows (adjustable, up to a maximum of 10,000,000) |
| License Management | Gumroad |
Million by Million Rows Copier is copy and paste software made for one specific, everyday problem: how to copy 1 million rows out of a database or spreadsheet and get them into Excel in one piece. Excel itself caps every sheet at roughly 1,048,576 rows, so trying to copy paste 1 million rows, or trying to copy paste more than 1 million rows in Excel, the normal way usually ends in a frozen window, a truncated paste, or a crash. This app solves that problem by acting as a dedicated tool to copy million rows and paste them, one clean chunk at a time, so the Excel 1 million rows limit stops being a blocker for your workflow. As an Excel copier, it treats Excel's row ceiling as a starting point rather than a hard limit, letting you work with genuinely large tables, whether that means 5 million rows, 20 million rows, or the full 50 million rows the app supports, without ever exceeding what a single sheet can hold. It is equally useful as a way to copy large data and paste it one by one from any source, and it is a natural fit for anyone who regularly needs to copy large data from SQL and paste it in Excel: run your query, paste or export the results into the app, and let it manage the chunking, the clipboard, and the disk-safe exports for you.
Common Questions About Million by Million Rows Copier
How do I copy 1 million rows and paste them into Excel?
Load your data into Million by Million Rows Copier by pasting it or loading a file, click "Start Copying Out," then click "Copy Next Chunk." The app copies exactly one million rows to your clipboard with the header row included, ready to paste straight into Excel.
Can I copy and paste more than 1 million rows in Excel?
A single Excel sheet is capped at 1,048,576 rows, so more than 1 million rows can never fit on a single sheet. Million by Million Rows Copier works around this by handing data out in 1,000,000-row chunks that you paste into separate sheets or workbooks, one after another, until the whole dataset has been delivered.
Is this a copy and paste app for datasets larger than Excel can hold?
Yes. Million by Million Rows Copier is copy and paste software built specifically for datasets between 1 million and 50 million rows, well beyond what Excel, the Windows clipboard, or most spreadsheet tools can move in one go.
How do I copy large data from SQL and paste it in Excel?
Export or paste your SQL query results directly into Million by Million Rows Copier, then use "Copy Next Chunk" to hand the data out in 1,000,000-row pieces. Each chunk is saved to disk automatically and copied to your clipboard, so you can paste it directly into Excel.
Does this work as an Excel copier for files with more than 1 million rows?
Yes. As an Excel copier for oversized datasets, Million by Million Rows Copier loads XLSX, XLS, CSV and more than 25 other formats, then copies the data out in Excel-safe, 1,000,000-row chunks that never exceed a single sheet's row limit.
How do I copy large data and paste it one by one without the app freezing?
Million by Million Rows Copier stores your data in a local SQLite file instead of holding it all in memory, and every slow task runs on a background thread. This is what lets you copy large data and paste it one by one, chunk by chunk, without the window ever freezing.
What is the largest dataset this copy and paste software can handle?
Up to 50,000,000 rows in a single session. Chunk size can be set anywhere from 1 to 10,000,000 rows, so you can match it to whatever tool you are pasting into.
Does it work with data pasted straight from the clipboard, not just files?
Yes. "Paste All Data (Ctrl+V)" loads whatever is currently on your clipboard directly into the app, which is often the fastest route when copying results out of a SQL client or another spreadsheet.