Format Code Now
/

Random TSV Generator

RG-23

Choose your columns and the number of rows, and get tab-separated data for tests, imports and database loads. Values contain no tabs, so each row splits cleanly.

Runs in your browser. Nothing is uploaded.

Optional: columns, one per line, as name:type or just type. Types: id, first_name, last_name, name, email, city, word, number, age, decimal, date, boolean, phone, ip, url, text. Empty uses a default set.

Random TSV

How to use it

  1. List columns in the box, one per line, as name:type or just a type. Empty uses a default set.
  2. Choose how many rows you want, up to 1000.
  3. Keep Header row ticked if the first line should hold the column names.
  4. Press Generate TSV and copy the data or download it as a .tsv file.

What TSV output looks like

Each row is one line, and columns are separated by a single tab character. The data is made up so that no value contains a tab or a line break, which means a plain split on tab always gives the right columns. Lines end with a line feed. Quote every value wraps each value in double quotes for programs that expect them. TSV has no single standard for quoting, so leave it unticked unless your target needs it.

Column types you can use

Use id, first_name, last_name, name, email, city, word, number, age, decimal, date, boolean, phone, ip, url or text. Write joined:date to name a column. Names and words come from short lists written for this page, so the rows are fictional. Emails use example.com, example.org or example.net, phone numbers use 555-01xx, and IP addresses come from the documentation ranges. There are up to 30 columns, and rows are not linked to each other.

Questions people ask

What is a TSV file?

TSV means tab-separated values. It is like CSV, but a tab character separates the columns instead of a comma. Spreadsheets and databases can load it, and it avoids trouble with commas inside values.

How is TSV different from CSV?

The separator is a tab, not a comma. Because tabs are rare in text, TSV rarely needs quoting. The CSV generator on this site makes comma, semicolon or pipe separated data with quoting rules for values that contain the delimiter.

Can I paste the result into a spreadsheet?

Yes. Copy the output and paste it into the first cell of a spreadsheet. Excel and Google Sheets put each tab-separated value into its own column. You can also download the data as a .tsv file and open that.

Do the values ever contain tabs?

No. The names, words and other values here never contain tab characters or line breaks, so each line splits into exactly the columns you asked for. If you tick Quote every value, quotes are added around each value as well.

Is the data real?

No. Rows combine names, cities and words from short lists at random, with example.com emails and 555-01xx phone numbers. A row could match a real person only by chance, so it is meant for tests and demos, not for research.

How do I name the columns?

Write name:type per line in the box, such as visits:number. The text before the colon becomes the header. A line with just a type, such as email, uses the type as its header.

About this tool

Values are made in your browser with crypto.getRandomValues and rejection sampling, so no value is favored, and nothing is sent anywhere or stored. Names, cities and words come from short lists written for this page, so rows are made up and do not describe real people. Emails use example.com, example.org or example.net, phone numbers use the reserved 555-01xx range and IP addresses use the documentation blocks 192.0.2.0/24, 198.51.100.0/24 and 203.0.113.0/24. Columns are separated by one tab character and rows by a line feed. None of the generated values contain tabs or line breaks, so quoting is not needed; "Quote every value" is there only for programs that expect it, and it uses double quotes as in CSV (TSV has no single standard for quoting). Write one column per line as name:type or just the type. Up to 30 columns. Flat rows only, with no relationships between them.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.