.csv

Search services

Search tools and open pages quickly

Fikirlər · 6 dəq oxu

When to use TSV instead of CSV for handoffs between teams

Choosing tab-separated values when prose columns or European decimals collide with comma delimiters, and interoperability tradeoffs with Excel and Unix tools.

Dərc 19 mart 2025 · Table

TSV uses tab characters between fields. It is a pragmatic choice when your data contains lots of commas (prose, addresses, JSON fragments) and you want to avoid heavy quoting. Unix pipelines and bioinformatics stacks often default to TSV for that reason.

When TSV wins

  • Free-text columns where comma escaping would bloat the file.
  • European numeric exports that use comma as the decimal separator alongside comma delimiters (confusing without strict locales).
  • Quick handoffs between engineering tools that treat tabs as rare inside values.

Tradeoffs

  • Tabs can hide inside pasted spreadsheet cells; always validate field counts.
  • Some Windows workflows assume .csv even when content is tabbed; document the delimiter for partners.

Table focuses on CSV interchange for the broadest business audience. If your pipeline emits TSV, convert to CSV at the boundary or use a one-line tool to swap delimiters before loading here.

← Bütün məqalələr

Aparıcı komandalar tərəfindən istifadə olunur

Sürüşən loqolar (hər biri brend saytını yeni vərəqdə açır): Google, Apple, Meta, GitHub, Stripe, Shopify, Databricks, Snowflake, Notion, Vercel, Intel, NVIDIA, Netflix, Spotify, Airbnb, Yale, Harvard University, Massachusetts Institute of Technology, Stanford University, University of California, Berkeley, Princeton University, California Institute of Technology, Columbia University, University of Chicago, Cornell University, Duke University, Carnegie Mellon University, Georgia Institute of Technology, Johns Hopkins University, Northwestern University, University of Toronto, McGill University, University of Oxford, University of Cambridge, Imperial College London, University College London, ETH Zurich, EPFL, Technical University of Munich, Sorbonne University, KU Leuven, National University of Singapore, Nanyang Technological University, Tsinghua University, Peking University, The University of Tokyo, KAIST, Seoul National University, University of Melbourne, Australian National University, University of Sydney, The University of Hong Kong.