Random CSV Generator

Random CSV generator: sample files in seconds

CSV (comma-separated values) is the lingua franca of spreadsheets, databases and data pipelines. When you are building an import feature or testing a report, you need sample files that look like the real thing. This random CSV generator produces rows of realistic fake data in the column order you choose, with an optional header row.

Example

id,fullName,company,city,price
1,Aisha Thompson,"Hartmann, Weber and Lang",East Brenda,412.99
2,Lucas Moreau,Kuhn Group,Port Elsie,78.5
3,Sofia Rossi,"Stark, Mills and Bode",New Jaylen,15

Notice the quotes around company names that contain commas. The generator follows the common RFC 4180 conventions: values containing a comma, a double quote or a line break are wrapped in double quotes, and embedded quotes are doubled (" becomes ""). That is exactly the kind of case an importer must handle, so the sample data doubles as a robustness test.

Available fields

Type a comma-separated list of field names in the order you want the columns. Unknown names produce an error listing all valid ones. The full list is:

id, uuid, firstName, lastName, fullName, name, gender, email, username, password, phone, company, jobTitle, street, city, state, zip, country, countryCode, latitude, longitude, date, datetime, birthdate, age, boolean, active, number, price, product, ip, url, color, word, sentence, paragraph, avatar, iban, currency

id is a sequential number starting at 1, uuid is a random version 4 UUID, age is between 18 and 90, date and datetime fall within the past five years, and number is an integer from 0 to 10,000. Names, addresses, companies and products come from an English-language fake-data library.

Testing CSV imports

• Quoted fields – include company or street columns; many values contain commas.
• Long text – sentence and paragraph fields test column widths and truncation.
• Numbers and booleans – price, age and active check type conversion.
• Header handling – toggle the header row off to test files without column names.
• Volume – 5,000 rows is enough to notice slow parsing or memory issues in a browser.

Opening the file in Excel

The CSV is plain UTF-8 without a byte order mark. Recent versions of Excel usually detect this correctly when you use Data > From Text/CSV; if accented characters look garbled, import through that dialog and choose UTF-8 as the file origin. In locales that use a comma as the decimal separator, Excel may expect semicolons between fields; the import dialog lets you pick the delimiter.

Next steps

Inspect the result as a table in the CSV viewer, convert it to JSON with CSV to JSON, or turn it into database inserts with CSV to SQL. If your system expects tab-separated files, use the random TSV generator instead.

All rows are created in your browser. The data is fictional, but email addresses use real provider domains, so do not send messages to them.