CodesBeautify

Random TSV Generator

Produce tab separated rows of believable but fake records to paste into a spreadsheet or an import test.

TSV rows10 generated
7511	Hana Yilmaz	pixel80@example.org	Pune	India	2022-02-20	68
2525	Dalia Yilmaz	harbor24@example.org	Zurich	Switzerland	2025-02-27	48
8796	Petra Fernandes	ember02@mail.example	Palermo	Italy	2021-01-05	149
7091	Gabriel Sharma	pixel23@test.example	Brno	Czechia	2026-11-03	85
9583	Tomas Cardoso	quartz51@example.net	Gothenburg	Sweden	2022-03-07	461
8750	Lucas Vidal	quartz36@mail.example	Dunedin	New Zealand	2024-05-03	104
8743	Nikolai Rahman	cinder22@example.com	Antwerp	Belgium	2026-09-03	164
6484	Imani Oyelaran	harbor28@example.net	Cali	Colombia	2022-12-21	421
3311	Karim Ivanov	vellum14@test.example	Halifax	Canada	2022-07-20	257
2274	Mateo Rossi	ember96@example.net	Split	Croatia	2021-01-20	371
Runs locally in your browser

About the Random TSV Generator

Each generated row carries seven tab separated columns in a fixed order: an account id between 1000 and 9999, a full name, an email address, a city, a country, a signup date somewhere in 2021 to 2026, and a spend figure between 1 and 480. Nothing is quoted and no field contains a tab or a line break, so the file parses cleanly in Excel, Google Sheets, pandas and any TSV reader you point at it.

TSV suits this kind of sample data better than comma separated output because names and city names never need escaping. There is no ambiguity about whether a comma inside a value is a separator, which is exactly the sort of edge case that makes a test fixture unreliable. The city and country columns are drawn as a matched pair from a list of eighty real places, so a row never claims that Kyoto sits in Brazil, and the people are invented rather than borrowed from anyone. Every email domain is a reserved example name such as example.com, which cannot receive mail.

The generator emits data rows only. Add your own header line, for example id, name, email, city, country, signup_date, spend with tabs between the fields, if your importer expects one. To turn the result into another format afterwards, pass it through TSV to CSV or TSV to JSON, or start from the Random CSV Generator when you need control over the column list.

How to use

  1. Set Rows to the number of records you need, up to 500.
  2. Leave No duplicate rows ticked so every record in the fixture is distinct.
  3. Press Generate, then copy the block or download it as a .tsv file.
  4. Paste your own header line above the rows if the importer you are testing expects one.

Common questions

Which columns does it produce?
Seven, always in this order: id, name, email, city, country, signup date and spend. The order is fixed so the output is predictable.
Does it include a header row?
No, only data rows. Paste your own header line above them if your importer needs one.
Are the email addresses real?
No. They use reserved example domains that cannot receive mail, so nothing you generate can reach a real inbox.
Can I choose different columns?
Not here, the layout is fixed. Use the Random CSV generator, which lets you name the fields, then convert its output with CSV to TSV.
Will the values open correctly in Excel?
Yes. No field contains a tab, a quote or a newline, so each row splits into exactly seven cells.