Explore a CSV or TSV file
Inspect CSV or TSV columns, missing values and sample rows without a spreadsheet. Export the file structure as JSON or CSV, locally in your browser.
CSV · TSV · TXT → preview · structure
DATA AND FILES
Explore a CSV or TSV file
An unfamiliar file? See what is inside.
Up to 50,000 records, 500 fields and 1 million cells. The preview shows the first 100 rows and 20 columns.
Choose a file or try the example.
| No. | Field | Types | Missing | Empty | Null |
|---|
Preview limited to the first 100 records and 20 fields. Long cells are shortened to 240 characters. [missing] and [empty] are display markers.
Exports describe all fields, even when a search is active. CSV protects names that could be interpreted as formulas; JSON preserves exact names.
How do I read the results?
Missing means a JSON object does not have that field. Empty means an empty string. Null means the JSON null value. CSV types are suggestions: values are never converted.
The explorer describes top-level JSON fields. Nested objects remain visible in the preview. Parquet, Excel and NetCDF files are not supported by this tool.
Steps, formats and limits
How to use this tool
- Choose a CSV, TSV or delimited TXT file, or try the example.
- Check the separator, encoding and header setting. Review field types or preview the first rows.
- Find a field, copy its name or export the complete structure as JSON or CSV.
Are values changed or converted?
No. CSV values remain text, including leading zeros. Types are suggestions. Blank rows count as records. Quoted separators and line breaks are supported.
What if columns or accents look wrong?
Open Adjust file reading. Select the separator or encoding and run the analysis again. UTF-8, Windows-1252 and UTF-16 are available.
What are the limits?
Up to 10 MB, 50,000 records, 500 fields and 1 million cells. Counts cover the whole file read. The preview shows at most 100 rows and 20 fields, with cells shortened to 240 characters. Analysis stops after 30 seconds.
Do exports contain the original data?
Exports describe the fields, types and counts, not all data rows. Searches do not limit the export. JSON keeps exact field names; CSV protects names that a spreadsheet could interpret as formulas.
Can I switch between CSV and JSON?
Yes. Each explorer keeps its own file, options and result within this tab. A failed or cancelled analysis leaves the last successful result available.
Are my files uploaded?
No. Processing happens in your browser. Download results before closing the tab or switching language. Original files remain unchanged.
Read the practical guide: Check CSV or TSV columns and parsing (new tab)