What to Do When a CSV Is Too Large for Excel
A worksheet holds at most 1,048,576 rows, header included. Open a longer CSV and the program may show a warning and quietly drop everything past that line, which is easy to miss if you only look at the top of the sheet.
Your rows stay on your computer. The tool runs only in your browser. Confirm totals afterwards.
Steps
- Check how many lines the file really has. Many text editors show a line count, and the Split CSV tool reports the number of data rows once the file is loaded.
- If it is near or above the limit, decide on a chunk size well under it, such as 500,000 rows.
- Use the Split CSV tool to cut the file into pieces of that size.
- Open each piece in its own sheet or workbook.
- Check that the rows-out figure in the summary matches the rows-in figure before you rely on the result.
Good to know
Signs a file was cut off
The last visible row sits exactly on line 1,048,576, totals look lower than expected, or the program warned that not all data loaded. Any of these means rows are missing.
Do not save over the original
If a truncated sheet is saved back as CSV, the missing rows are gone from that copy. Keep the source file untouched.
Other routes
A database, a data-analysis tool or a scripting language can handle long files without splitting. Splitting is simply the lowest-effort option for spreadsheet users.
Questions
Is the limit the same in every spreadsheet program?
No. Each program has its own maximum, and some are much lower. Check the limit for the one you use.
Will splitting change my numbers?
No. Rows are copied exactly as they are, without reformatting. Formatting changes usually happen later, when a spreadsheet opens the file. Because nothing is altered, open files from unknown sources with care.
Can a big file crash the browser?
The tool reads the file in chunks, but the finished parts are held in memory until the zip downloads, so very large files on low-memory devices may still struggle.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.