TSV and JSON explained
TSV is CSV with tab characters as separators. Because tabs almost never appear inside data fields, it sidesteps most of CSV's quoting problems.
JSON represents structured data as nested objects and arrays. It came from JavaScript but is now the default interchange format for essentially every web API.
- Where TSV files come from
- Bioinformatics, data pipelines and anywhere fields contain commas.
- Where JSON is used
- APIs, configuration files and application data exports.