CSV vs TSV
Een uitgebreide vergelijking van CSV (Comma-Separated Values) en TSV (Tab-Separated Values) — bestandsgrootte, kwaliteit, compatibiliteit en welk formaat het beste past bij jouw workflow.
CSV (Comma-Separated Values)
Spreadsheets & DataCSV is a simple text-based format for tabular data where values are separated by commas. It is the universal interchange format for data between spreadsheet applications, databases, and programming languages.
Over CSV-bestandenTSV (Tab-Separated Values)
Spreadsheets & DataTSV uses tabs instead of commas to separate values in tabular data. It avoids quoting issues common in CSV when data contains commas, making it popular for scientific and linguistic data.
Over TSV-bestandenVergelijking van sterke punten
CSV Sterke punten
- Universally readable — every spreadsheet, database, and programming language.
- Human-readable in any text editor.
- Stream-friendly — can process terabytes with constant memory.
- Git-friendly — clean diffs of row changes.
- Tiny overhead vs columnar data structures for simple data.
TSV Sterke punten
- No quoting needed — tabs in data are astronomically rare.
- Simpler parser than CSV.
- Preferred by databases, bioinformatics, and scientific pipelines.
- Opens cleanly in every spreadsheet app.
- Plain text, grep-friendly, diffable.
Beperkingen
CSV Beperkingen
- No standard — quoting, escaping, encoding, and separators vary wildly.
- No type information: 0042 might be an integer, a string, or an error.
- Leading zeros and large numbers often get mangled by Excel auto-conversion.
- Not suitable for hierarchical or binary data.
- Breaks when content contains the delimiter and the parser is naive.
TSV Beperkingen
- Tabs can be invisibly replaced with spaces by text editors.
- Carriage returns inside fields require escaping conventions.
- Less ubiquitous than CSV in business/consumer workflows.
- No metadata, no schema, no type information.
Technische specificaties
| Specificatie | CSV | TSV |
|---|---|---|
| MIME type | text/csv | text/tab-separated-values |
| Specification | RFC 4180 (informational) | — |
| Typical separator | Comma (;), semicolon, tab, pipe | — |
| Typical encoding | UTF-8, Windows-1252, ISO-8859-1 | — |
| Line endings | LF (Unix), CRLF (Windows) | — |
| Extensions | — | .tsv, .tab |
| Standard | — | IANA registration (1993), IETF RFC unofficial |
| Delimiter | — | Tab (ASCII 9) |
| Encoding | — | UTF-8 (convention) |
Typische bestandsgroottes
CSV
- Contact export (1000 rows) 100–300 KB
- Analytics export (100k rows) 10–100 MB
- Large dataset (1M rows) 100 MB – 1 GB
- Full database dump 1 GB – 100 GB
TSV
- Small data export 1-50 KB
- Typical database dump 1-500 MB
- Genome annotation file 100 MB - 50 GB
Klaar om te converteren?
Converteer online tussen CSV en TSV, gratis en zonder iets te installeren. Versleutelde upload, automatische verwijdering na 60 minuten.
Need to Convert Gigabyte Archives or Mass Folders?
KaijuConverter delivers ultra-fast in-memory conversions for everyday tasks. For multi-gigabyte production workloads without browser bandwidth bottlenecks, explore high-throughput desktop suites.
Eenmalige betaling zonder verlenging: converteer 24 uur lang bestanden tot 1 GB en batches van 50 bestanden.
Converteer grote video's, pdf's en lossless audio direct in je browser—100% reclamevrij met prioriteit.
Supersnelle cloudverwerking voor bestanden tot 1.024 MB, 24 uur versleutelde opslag en prioriteitsondersteuning.
Convert thousands of camera RAW files (CR3, NEF, ARW) to WebP, AVIF, or TIFF in one pass.
GPU-accelerated RAW development with end-to-end 16-bit ICC color profile management.
Veelgestelde vragen
Upload je CSV-bestand naar KaijuConverter om het direct in je browser om te zetten naar PDF, JPG, PNG of een ander standaardformaat.
Upload je TSV-bestand naar KaijuConverter om het direct in je browser om te zetten naar PDF, JPG, PNG of een ander standaardformaat.
Ja, gratis tot 25 MB (tot 1 GB met 24-uurspas of Pro) en alle bestanden worden na 60 minuten automatisch verwijderd.
Ja, gratis tot 25 MB (tot 1 GB met 24-uurspas of Pro) en alle bestanden worden na 60 minuten automatisch verwijderd.