CSV viewer and column filter
Open a CSV that is too big for a spreadsheet. The file is parsed in a background worker and only the rows on screen are drawn, so a million rows scroll smoothly. Search every column, sort by any column, add filters, look at column statistics and export just the rows and columns you kept.
Tooloat runs in your browser and needs JavaScript. It opens in a moment, and your files are processed on your device.
How it works
- Drop a CSV or TSV file.
- Search, sort, filter and hide columns.
- Export the current view as CSV, TSV or JSON.
Why use it
- Handles hundreds of megabytes and millions of rows.
- Delimiter and encoding auto detection.
- Filters with conditions and regular expressions.
- Column summaries and a row inspector.
Questions and answers
How big a file can it open?
Files of hundreds of megabytes open fine, up to about 480 MB, depending on device memory.
Can I fix a garbled encoding?
Yes. Pick another text encoding such as Windows-1252 and the file is re-read.
Is my data uploaded?
No, it is parsed on your device.
Related tools
- Excel to CSV converterConvert a workbook to CSV, TSV or JSON with one file per sheet, or turn a CSV into a proper Excel file.
- Convert JSON, CSV, YAML and XMLSwitch data between formats without a script.
- Word and character counterPaste text and see live counts of words, characters with and without spaces, sentences, paragraphs and lines.
- JSON formatter and validatorPaste JSON and get it pretty printed, minified or key sorted.