Random TSV Generator
Generate tab-separated test data with the columns you need. TSV is what a spreadsheet puts on the clipboard, so the output pastes straight into Excel, Numbers or Google Sheets and lands in the right cells. A tab is also far less likely than a comma to appear inside a value, which makes TSV a little safer than CSV for text-heavy data. Rows stay internally consistent. Everything is generated in your browser; nothing is uploaded and no result is recorded anywhere.
How it works
Choose the columns you need and how many rows, and the data appears below in whichever format you are pasting it into. Values that belong together stay consistent within a row — the email address is built from that row’s own name, so the result reads like a real table rather than unrelated columns side by side.
Everything generated here is fictional and deliberately unreachable: email addresses use the domains reserved for documentation, phone numbers come from the range set aside for drama and never allocated to anyone, and IP addresses come from the documentation block. Nothing here maps to a real person, and it should not be used as though it did.
Generation runs entirely in your browser.
Frequently asked questions
Why use TSV rather than CSV?
Two reasons: a tab is what a spreadsheet puts on the clipboard, so TSV pastes directly into cells; and a tab is much less likely than a comma to appear inside a real value, so fewer fields need quoting and there is less to go wrong.
Can I paste this straight into Excel or Google Sheets?
Yes — copy the output and paste into a sheet, and the columns will separate correctly without going through an import dialogue.
What happens if a value contains a tab?
It is quoted, using the same rule CSV applies to its own delimiter. This is rare in practice, which is part of what makes TSV convenient.
Does a comma inside a value cause a problem?
No — a comma is not the delimiter here, so it is left alone and not quoted. That is one of the practical advantages of tab separation.
Is any of this data real?
No. Emails use reserved documentation domains, phone numbers come from the range set aside for fiction, and IP addresses come from the documentation block.
Related tools
Random CSV Generator
Generate a CSV file of realistic test rows with the columns you choose, correctly quoted and escaped.
Sample Data Generator
Build a table of realistic test data with the columns you choose, in CSV, JSON, XML, SQL, YAML or HTML.
CSV to TSV Converter
This CSV to TSV converter swaps commas for tabs and gets the quoting right on the way through.