How to Open a Multi-GB CSV File Without Excel Crashing

To open a multi-GB CSV without Excel or Numbers crashing, use Zro7 Big CSV Viewer. It uses DuckDB-WASM to memory-map the file, so you can scroll, filter, and query files far larger than your RAM — 1 GB, 5 GB, 20 GB — without ever loading the whole thing into memory. Zero upload, runs in your browser tab.

Why Excel dies

Excel has a hard limit of 1,048,576 rows per sheet and loads the entire workbook into memory. A 2 GB CSV expands to 5–10 GB of Excel objects. Numbers crashes even earlier. Google Sheets caps at 10 million cells total. None of these are built for the shape of a raw data-warehouse export.

How Zro7 handles it

1. The file handle is registered directly with DuckDB-WASM — no pre-load.
2. DuckDB reads only the byte ranges the current view or query needs (columnar reads).
3. The UI shows a virtualized 100-row window at a time, so scrolling is instant.
4. Any SQL you type runs against the raw file — no import step.

What you can actually do

• Peek — auto-loads first + last rows; column types inferred.
• Filter — click any column header to add a WHERE.
• Count / group — SELECT status, COUNT(*) FROM data GROUP BY status.
• Export a slice — COPY (SELECT ... WHERE date > '2026-01-01') TO 'slice.parquet'.

Steps

1. Open Big CSV Viewer.
2. Drop the CSV. First 100 rows appear immediately even for a 10 GB file.
3. Scroll, sort, filter, or drop into SQL Playground for real queries.
4. Export any filtered slice as CSV or Parquet.