CSV Validator

CSV (Comma-Separated Values) is a text format for storing tabular data. Each line is a record, and values are separated by commas (or another delimiter). The first line usually contains headers.

The tool shows the line numbers with the wrong number of columns. This is usually caused by unclosed quotes, an incorrect delimiter, or a line break pasted inside a field. Try changing the delimiter.

Enclose values containing commas in quotes: "Smith, John". Double any quotes inside a value: "Acme ""Widgets"" Inc.". The tool handles both cases correctly.

In Russia, Excel often uses ; (semicolon). The international standard is , (comma). TAB is used in TSV files. If the data contains commas and semicolons, use TAB or |.

Use the CSV → JSON tool on reChecker. Specify the headers and delimiter to get an array of JSON objects. Useful for importing data into an API.