CSV Nedir? Comma-Separated Values'in Tam Açıklaması
Quick Answer
CSV, her satırın bir satır ve değerlerin virgülle ayrıldığı tabular veri için metin formatıdır. İlk satır genelde sütun header'larını içerir. CSV veri export, import ve değişimi için kullanılır. CSV'yi JSON'a dönüştürmek için ücretsiz CSV to JSON Converter kullanın.
Introduction
CSV (Comma-Separated Values), tabular veri için plain-text formatıdır —satır ve sütun halinde düzenlenmiş veri, elektronik tablo gibi. Her satır bir metin satırıdır ve satırdaki her değer virgülle ayrılır. CSV, tabular veri için en basit ve en çok desteklenen format: her elektronik tablo, veritabanı ve veri analiz aracı CSV okuyup yazabilir. RFC 4180 tarafından tanımlanır.
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.