Sample TSV File — Free Download
A tab-separated version of a simple customer table — 100 rows — for testing a TSV parser, a TSV-to-CSV conversion, or an import that expects tabs instead of commas.
Download the sample file
TSV · 100 rows · 6.6 KB · synthetic data, free for any use
Download TSV samplePreview
| id | name | country | signup_date | orders | lifetime_value | |
|---|---|---|---|---|---|---|
| 1 | Sam Diaz | [email protected] | Brazil | 2025-03-27 | 58 | 7074.86 |
| 2 | Priya Petrov | [email protected] | Germany | 2025-05-13 | 30 | 2092.40 |
| 3 | Mia Al-Sayed | [email protected] | Japan | 2025-06-22 | 19 | 7221.64 |
| 4 | Elena Bianchi | [email protected] | Spain | 2025-07-03 | 29 | 3820.14 |
| 5 | Tomás Khan | [email protected] | UK | 2025-05-14 | 41 | 859.23 |
| 6 | David Petrov | [email protected] | Canada | 2025-02-16 | 5 | 2765.04 |
Showing the first 6 of 100 rows.
Columns
| Column | Type | Description |
|---|---|---|
id | integer | Row id 1–100 |
name | string | Full name |
email | string | @example.com address |
country | string | Country |
signup_date | date (YYYY-MM-DD) | Signup date |
orders | integer | Order count |
lifetime_value | decimal | LTV in USD |
What makes this file useful
- Fields are separated by a real tab character (\t), not spaces — open it in a plain-text editor with "show whitespace" to confirm.
- No field contains a tab or newline, so the file needs no quoting — a clean baseline before you test messy input.
- The same 100 rows are available as CSV via the with-headers sample, so you can diff the two formats.
Use cases
- Test that your parser splits on tab, not comma
- Convert TSV to CSV and check quoting behaviour
- Load a tab-delimited file into a spreadsheet or database
- Confirm your pipeline auto-detects the delimiter
Open it in a tool
Load this sample — or your own file — into a real tool. Everything runs client-side.
Related guides
More sample datasets
Frequently asked questions
What is the difference between TSV and CSV?
TSV uses a tab between fields instead of a comma. Tabs almost never appear inside data, so TSV often needs no quoting, but fewer tools auto-detect it.
How do I open a TSV file in Excel?
Rename it to .txt and use Data → From Text, or use the TSV to CSV tool first.
Does Google Sheets read TSV?
Yes, on import it lets you pick tab as the separator.
Turn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.
Follow HowToCSV on Google
Add us as a preferred source on Google Search so our latest CSV guides and tutorials surface more often in your Top stories.