Open a CSV file that is too big for Excel

Option 1: open it in Rowlode (browser, offline)

1. Open Rowlode and choose your CSV file (or drop it on the page).
2. Rowlode detects the delimiter, encoding and header row and indexes the file – a 150 MB file with 2 million rows takes a few seconds on a normal laptop.
3. Scroll, or type a row number in “Go to row”. Click a cell to see its full value.
4. Need it in Excel? Export to .xlsx in parts of up to 1,048,575 rows each, or filter it down first.

The file is not uploaded and not loaded into memory at once – it is read from your disk in slices. That is why files larger than your RAM can be opened.

Option 2: Excel’s Power Query / Data Model

In Excel, Data → From Text/CSV → Load To… → Only create connection + Add to the Data Model loads more than a million rows into the Data Model. You can then build PivotTables from it, but you cannot see or scroll through the rows in a sheet. It is a good choice if a PivotTable is all you need.

Option 3: split the file

If you just need the data in normal spreadsheets, split the CSV into several files of under a million rows each and open them one by one.

Why Excel cuts the file

An Excel worksheet has 1,048,576 rows and 16,384 columns – see Excel’s row limit explained. Google Sheets allows 10 million cells per spreadsheet, and LibreOffice Calc also stops at 1,048,576 rows.