Wat Is CSV? Een Volledige Uitleg van Comma-Separated Values
Quick Answer
CSV is een tekstformaat voor tabellaire data waarbij elke rij een regel is en waarden gescheiden door komma's. De eerste rij bevat vaak kolomheaders. CSV wordt gebruikt voor data-export, -import en -uitwisseling. Gebruik onze gratis CSV to JSON Converter om CSV naar JSON te transformeren.
Introduction
CSV (Comma-Separated Values) is een platte-tekst formaat voor tabellaire data —data georganiseerd in rijen en kolommen, zoals een spreadsheet. Elke rij is een tekstregel en elke waarde binnen een rij is gescheiden door een komma. CSV is het simpelste en meest ondersteunde formaat voor tabellaire data: elke spreadsheet-app, database en data-analysetool kan CSV lezen en schrijven. Het is gedefinieerd door 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.