TSV test data generator

What the output looks like

order_id	product	quantity	unit_price
b3c9a1f2-6d4e-4a7b-9c1d-2f8e5a6b7c8d	Ergonomic Bamboo Keyboard	2	129.99
7f2e0d94-1c3b-4e5a-8f6d-9a0b1c2d3e4f	Rustic Steel Lamp	1	54.50

Why TSV?

Tab-separated values sidestep CSV's biggest annoyance: commas inside the data. Because real-world values almost never contain tabs, TSV rows rarely need quoting at all — which makes the files trivially cut-, awk- and paste-friendly, and means a copied block drops straight into Excel or Google Sheets with columns intact.

Where TSV shines

• Spreadsheet pastes — copy the raw output and paste it directly into a sheet; every tab becomes a column.
• Unix pipelines — cut -f2, sort -k3 and friends work without a CSV parser.
• MySQL imports — LOAD DATA INFILE defaults to tab separators, so TSV loads with zero extra flags.
• Header row & Blank % — same controls as CSV: toggle the header, inject empty cells to simulate missing data.

Quick recipe: column stats with awk

awk -F'\t' 'NR>1 { sum += $4 } END { print sum/NR }' fundata_1000_rows.tsv

TSV compatibility and edge cases

Every record occupies one line and every field is separated by a literal tab. Text is encoded as UTF-8, so non-English names survive spreadsheet and command-line workflows. Because tabs are rare in ordinary values, TSV avoids much of CSV's quoting overhead; when a consumer requires RFC-style comma-separated input, switch to CSV. Blank percentages generate empty fields between delimiters, making missing-value tests easy to spot.

Common TSV questions

For a practical spreadsheet workflow, read the Excel and Sheets sample-data guide.

Other formats

The same schema exports to all six formats — switch with one dropdown: CSV, JSON, NDJSON, SQL, XML. New here? Start with the getting-started guide or the full field type reference.