CodesBeautify

Random CSV Generator

Generate sample CSV rows with believable names, emails, prices and dates for testing imports.

Sample CSV10 rows, 7 columns
id,first_name,last_name,email,city,country,signup_date
1,Lucia,Haddad,ayla.novak@example.com,Bergen,Vietnam,2026-08-22
2,Piotr,Cardoso,beatrix.vasquez@test.example,Rosario,Argentina,2020-09-17
3,Selin,Riedel,lucas.lombardi@mail.example,Kyoto,Vietnam,2026-08-24
4,Nadia,Almeida,ravi.halvorsen@corp.example,Turin,Denmark,2019-11-28
5,Pedro,Serrano,viktor.weber@example.net,Medellin,Portugal,2022-12-14
6,Mei,Halvorsen,lucas.nakamura@mail.example,Turin,Croatia,2024-05-27
7,Kofi,Ahmadi,ronan.weber@mail.example,Bilbao,Georgia,2019-04-22
8,Nadia,Marchetti,talia.rahman@example.com,Odense,Netherlands,2020-08-28
9,Petra,Novotny,selin.trinh@example.net,Kyoto,Australia,2021-01-25
10,Karim,Osei,amara.cardoso@example.net,Sapporo,France,2024-06-04
Runs locally in your browser

About the Random CSV Generator

Testing a spreadsheet import, a database loader or a chart component usually starts with finding a file to feed it. This generator builds one on demand: choose how many rows you want, pick a shape such as People, Employees, Products, Orders or Log events, and a fresh CSV appears with column headers and values that look like real records rather than aaa,bbb,ccc.

Columns can also be listed by hand in the Custom columns box. Write the names you want, separated by commas, and each one is filled with matching values: full_name, email, city, country, price, quantity, status, date, datetime, ip, uuid and about thirty more. Use header:type when the heading should differ from the field, for example Ordered on:datetime.

Quoting follows RFC 4180. With the default setting a value is wrapped in double quotes only when it holds the delimiter, a quote or a line break, and inner quotes are doubled; switch to Every field when the consumer you are testing is strict, or to Never when you want raw values and are willing to lose commas inside them. Semicolon output suits European spreadsheet locales. Once you have a file, feed it to the CSV to JSON converter or preview it in the CSV viewer.

How to use

  1. Set the number of Rows you need.
  2. Pick a ready made Shape, or type your own column list in Custom columns.
  3. Choose the delimiter and whether a header row is included.
  4. Press Generate again for a different draw, then Copy or Download the file.

Common questions

Is the data real?
No. Names, addresses and emails are assembled from word lists and use reserved example domains, so nothing points at a real person or mailbox.
How many rows can I generate?
Up to 1000 per run. Generate several times and paste the results together if you need a larger fixture.
Which column types are supported?
Roughly forty, including identifiers, people, places, commerce and log fields. An unknown name in the Custom columns box shows the full list in the error message.
Can I get the same rows twice?
No. Every run draws new random values, so save the output if a test needs a fixed fixture.