Random CSV Generator
RG-22List the columns you want, choose a row count, and press Generate CSV. You get a header and made-up rows you can drop into a test, an import or a spreadsheet.
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 CSV
How to use it
- In the box, list columns one per line as name:type, for example joined:date, or just a type. Leave it empty for a default set.
- Choose the number of rows and the delimiter.
- Tick or untick Header row and Quote every value.
- Press Generate CSV, then copy the result or download it as a .csv file.
Column types
The types are id (1, 2, 3 and so on), first_name, last_name, name, email, city, word, number (0 to 1000), age (18 to 80), decimal, date (2015 to 2025), boolean, phone, ip, url and text (random lowercase letters up to the length you pick). Write joined:date to name a column joined and make it a date. An unknown type stops with an error that lists all valid types. You can use up to 30 columns.
Made-up data and CSV rules
Names, cities and words come from short lists written for this page, so the rows are made up. Emails end in example.com, example.org or example.net, phone numbers use the reserved 555-01xx range, and IP addresses use the documentation blocks. A value is put in quotes only when it contains the delimiter, a quote or a line break, or when you tick Quote every value; quotes inside are doubled. Rows are independent, so there are no keys linking one row to another.
Error messages and what to do
| Message | What it means | Fix |
|---|---|---|
Use at most 30 columns. | The box lists more than 30 columns. | Remove some columns. |
Item 1 has a colon but no column name before it. | A line starts with a colon, as in :date. | Write a name before the colon, such as joined:date. |
Questions people ask
How do I generate a CSV file with random data?
List the columns you want in the box, set the number of rows, and press Generate CSV. Then use Copy or Download. If you leave the box empty, you get id, first name, last name, email, city, age, signup date and active.
Is the data real?
No. Names come from a short list of common first names and last names, and rows combine them at random, so a row can match a real person only by chance. Emails use example domains and phone numbers use the reserved 555-01xx range.
Can I use semicolons instead of commas?
Yes. Choose Semicolon or Pipe under Delimiter. Values that contain the chosen delimiter are put in quotes. The generated names and words never contain commas, so quoting rarely happens unless you tick Quote every value.
How do I name my own columns?
Write name:type on one line, for example customer:name or paid:boolean. The part before the colon is the header; the part after is the kind of value. A line with only a type, such as city, uses the type as its header.
How many rows can I make?
Up to 1000 rows in one go, in steps of 1, 5, 10, 25, 50, 100, 500 and 1000. All rows are made in your browser, so large sizes are quick. You can download the result as a .csv file.
Can I get a column of unique IDs?
Use the id type. It counts 1, 2, 3 and so on down the rows, so it is unique within one file. For random unique identifiers, use the UUID generator instead.
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. Write one column per line as name:type (for example joined:date) or just the type, which then names the column. A value is wrapped in quotes only if it holds the delimiter, a quote or a line break, or when you tick "Quote every value"; quotes inside are doubled, as in RFC 4180. Line breaks are \n. The "text" type is random lowercase letters up to the length you pick. Up to 30 columns; an unknown type stops with an error that lists the valid ones. It makes flat tables only, with no links between rows.