About the Random TSV Generator
Tab-separated values are what you get when you copy cells from a spreadsheet, and many tools and databases load them directly. This generator makes TSV test data in one step. Choose the number of rows, tick the columns and decide whether to include a header row. Each row is one consistent made-up person, so the email matches the name and the city matches the postal code. Because tabs rarely appear inside values, there is no quoting to worry about, which makes the output easy to paste into a spreadsheet, a database loader or a script. Emails end in example.com and phone numbers use the fictional 555-01xx range. The data is made in your browser and never leaves your device.
Updated October 2026
How to use the Random TSV Generator
- 1Enter how many rows you want, from 1 to 500.
- 2Tick the columns to include.
- 3Leave Include a header row ticked if you want column names first.
- 4Press Generate, and press it again whenever you want new rows.
- 5Copy the result and paste it straight into a spreadsheet, or download random.tsv.
What you get
Each line holds one person. With the default columns that is a full name, an email, a city and a date of birth, separated by tabs. The other columns add first and last name, phone, username, company, job title, street, state, postal code, country, IP address and website.
- A header line with the column names, if you keep it
- One row per person, with matching name, email and place
- Dates written year-month-day, which every spreadsheet reads correctly
When random TSV is useful
- Pasting believable rows into a spreadsheet to try formulas, filters or charts.
- Testing a loader that reads tab-delimited files, such as a database bulk import.
- Feeding a script or a command-line tool that splits lines on tabs.
- Making demo data for a tutorial or a screenshot.
- Checking how a program copes with many rows of mixed text and dates.
Pasting into a spreadsheet
Use Copy rather than selecting by hand, so every tab is kept. Then click one cell and paste. If the columns do not split, check that your program is not treating the paste as plain text in a single cell.
In a text editor, tab characters look like wide gaps. Some editors turn tabs into spaces when you paste, which would break the columns, so download the file if that happens.
Safe sample data
Nothing here belongs to a real person. The example.com domain is reserved for examples and never delivers mail, and the fictional phone numbers cannot ring a real phone.
Phone and computer
On a phone the options stack in one column, and the result box scrolls sideways. Copy works with the phone's own paste into a spreadsheet app. For commas use the Random CSV Generator, and read the result with the TSV to JSON Converter. For test data in another layout, try the Random JSON Generator, and the TSV to JSON Converter reads the result.
Features
- Sixteen columns to choose from
- Real tab characters between columns, so pasted data lands in separate spreadsheet cells
- Up to 500 rows per press
- Optional header row
- Safe placeholders: example.com emails and fictional phone numbers
- Made on your device, nothing uploaded
Frequently asked questions
What is a TSV file?
TSV stands for tab-separated values. Each line is a row, and the columns are separated by a tab character instead of a comma. It is the format spreadsheets use when you copy a block of cells.
How do I use the result in a spreadsheet?
Press Copy, click the first cell in Excel, Google Sheets or Numbers, and paste. Each tab-separated value lands in its own cell.
Why use TSV instead of CSV?
Commas are common inside names, addresses and job titles, so CSV needs quotes. Tabs almost never appear in text, so TSV is simpler and safer to split. If you need commas, use the Random CSV Generator.
Is the data real?
No. Names come from lists of common names mixed at random, emails end in example.com, and phone numbers use the fictional 555-0100 to 555-0199 range.
Can I remove the header row?
Yes. Untick Include a header row and the first line will already be data.
Does the download keep the tabs?
Yes. The file is plain text with real tab characters, so it opens correctly in spreadsheet programs and database loaders.
How many rows can I get?
Up to 500 per press. Press Generate again and join the results if you need more.
Is anything sent to a server?
No. The rows are made in your browser.