CSV structure inspector

Inspect quoted records, column consistency and delimiter candidates without executing cell formulas.

Your input

Outputs are cleared when the input changes.

Result

Enter your data or use the example, then run the tool.

Worked example

"a,b",c contains two columns; the comma inside quotes stays within a field.

A quoted newline stays within one logical record. Inconsistent widths report physical start lines.

Method

A state-machine parser handles quoted fields, escaped quotes and embedded newlines.

Comma, semicolon and tab candidates are scored by modal column consistency. User confirmation selects an interpretation.

Limits

At most 10 MiB UTF-8, 100,000 records, 1,000 columns and 1 MiB per field. Single-column input is ambiguous.

No encoding detection, Excel/JSON conversion or formula execution. The first record is not automatically assumed to be a header.

Sources

RFC 4180: CSV record and quoting conventions

Your inputs stay on this device. Only optional, consented page visits are measured. Input values, files, filenames and processing logs are not sent to Analytics.

When switching languages, text, settings and selected files are temporarily kept on this device. Transfers are removed after restoring; interrupted transfers are cleaned up on a later visit. Inputs and files are never uploaded.