Open a CSV file too large for Excel
Excel stops at 1,048,576 rows. Here, the file is read from your disk in chunks: browse, filter, sort, and export what you kept as CSV, or as XLSX if it fits.
What this tool does
- Files of several gigabytes, read in chunks: nothing is loaded whole.
- The exact number of rows, with irregular rows flagged.
- Combined filters (contains, equals, greater than, empty…), with numbers and dates read in your format.
- Sorting by column, and a profile of each column: most frequent values, minimum, maximum, sum.
- The result exported as CSV with no size limit, or as XLSX up to 1,048,575 rows.
What it does not do: Text files only (CSV, TSV, TXT), in UTF-8 or a Western code page; an XLSX workbook is limited to 1,048,576 rows by Excel anyway. Sorting keeps one key per row in memory: beyond three million rows of text, filter first.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Automatic pivot table : Useful pivots suggested, dates grouped, the table and its chart.
- SQL queries : SELECT, JOIN, GROUP BY on your files, with no database.
- Unpivot or pivot : One column per month becomes one row per month, and the reverse.
- Convert a spreadsheet : XLSX, CSV, ODS, JSON, in every direction, sheet by sheet.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.