Что такое CSV? Полное объяснение Comma-Separated Values
Quick Answer
CSV — текстовый формат табличных данных, где каждая строка — линия, а значения разделены запятыми. Первая строка часто содержит заголовки столбцов. CSV используется для экспорта, импорта и обмена данными. Используйте наш бесплатный CSV to JSON Converter.
Introduction
CSV (Comma-Separated Values) — plain-text формат для табличных данных —данных, организованных в строки и столбцы, как электронная таблица. Каждая строка — линия текста, а каждое значение в строке разделено запятой. CSV — простейший и наиболее поддерживаемый формат табличных данных: каждая электронная таблица, база данных и инструмент анализа могут читать и писать CSV. Определён RFC 4180.
Step by Step
-
Understand CSV structure
A CSV file has one row per line, with values separated by commas. The first row is often a header row containing column names. Each subsequent row is a data record. Example: 'name,age,city\nAlice,30,NYC\nBob,25,LA'.
-
Learn the quoting rules
Values containing commas, quotes, or newlines must be wrapped in double quotes. A quote inside a quoted value is escaped by doubling it. Example: 'Alice,"Hello, world"' — the comma inside the quotes is part of the value, not a separator.
-
Recognize CSV variations
While commas are the standard delimiter, some files use semicolons (;), tabs (TSV), or pipes (|). European locales often use semicolons because commas are used as decimal separators. Always check the delimiter when parsing.
-
Convert CSV to other formats
CSV has no type information — all values are strings. When converting to JSON or loading into a program, you may need to convert numeric strings to numbers. Use our CSV to JSON Converter for instant conversion.
Examples
Simple CSV with headers
Input: Three columns, two data rows
Output: name,age,city
Alice,30,NYC
Bob,25,LA
CSV with quoted values
Input: Value containing a comma
Output: name,note
Alice,"Hello, world"
TSV (tab-separated)
Input: Same data, tab delimiter
Output: name age city
Alice 30 NYC
Common Problems
- All values are strings —CSV has no type information. Numbers, dates, and booleans are all stored as text and must be parsed by the application.
- Inconsistent delimiters —some files use commas, others semicolons or tabs. Detect the delimiter automatically or let the user specify it.
- Encoding issues —CSV files from Excel may use BOM or Windows-1252 encoding instead of UTF-8. This causes problems with non-ASCII characters.
- Inconsistent row lengths —some rows may have fewer or more columns than the header. Handle missing values as null and extra values by truncating or erroring.
Tips
- CSV is best for tabular data —use JSON for nested or hierarchical data.
- Always quote values containing commas, quotes, or newlines to avoid parsing errors.
- Use UTF-8 encoding without BOM for maximum compatibility.
- Use our CSV to JSON Converter to transform CSV into JSON for use in web applications.