What to do when a CSV file is too large to open in Excel
Why Excel truncates or slows to a crawl on big CSV exports, and practical ways to work with a large file without losing rows.
Before you work through this by hand: you can check your own CSV free and see which of these problems your file actually has — duplicate rows, near-duplicates, broken quoting, encoding damage. It runs in your browser tab, nothing is uploaded, and there's no signup or email.
Why this happens
Excel has a hard row limit (1,048,576 rows in modern versions). If your CSV export has more rows than that, Excel will silently truncate the file on open — you'll see a warning, but it's easy to miss, and any rows past the limit are simply not loaded. Even well under that limit, very wide files (many columns) or files with long text fields can make Excel slow to open and scroll.
Option 1: Split the file
If you don't need everything in one sheet, split the CSV into smaller chunks. On Linux/macOS: split -l 500000 file.csv part_ (keeps roughly 500,000 rows per chunk; re-add the header row to each chunk afterward). On Windows, a short PowerShell or Python script can do the same.
Option 2: Use Google Sheets or a database instead
Google Sheets has its own (different) cell limits but sometimes handles large flat files better for quick viewing. For real analysis, importing into a lightweight database (SQLite, DuckDB) or using pandas.read_csv with chunksize avoids loading the whole file into memory at once.
Option 3: Reduce the file before opening it
If you only need a subset of columns or rows (e.g. this year's records only), filter the file down first with a script rather than opening the full export in a spreadsheet at all.
If the file is large because of duplicates
Sometimes a "too large" file is large partly because it contains many duplicate or near-duplicate rows from repeated exports. Removing those first (see our duplicate-removal guide) can shrink the file enough to open normally.
See CSV Repair & Deduper (offline browser tool) — $19 one-time