CSV Dataset Generator

Runs in browser Test Data

Build a column schema (name, type, options), choose the delimiter and quoting, and download thousands of rows for import and ETL testing.

TEST DATA ONLY — all generated names, contacts, identifiers and numbers are synthetic and do not belong to real people or accounts.
Privacy: This tool runs entirely in your browser. Your input never leaves your device.

What is the CSV format?

CSV (comma-separated values) is a plain-text table: one record per line, fields separated by commas, and a field quoted with double quotes when it contains a comma, a quote or a line break. RFC 4180 records the common rules, but there is no strict standard, which is why delimiter, encoding and header conventions differ between tools.

How to use CSV Dataset Generator

  1. Define the columns, one per line (load the example for a starting point).
  2. Choose delimiter, quoting, line ending and header options.
  3. Set the row count and press Generate, then download the CSV.

CSV Dataset Generator features

  • Column schema in name:type:options form with 50+ generator types
  • Nullable columns (name?) and consistent person fields per row
  • Comma, semicolon, tab or pipe delimiter; RFC 4180 or quote-all
  • LF or CRLF line endings, optional header and UTF-8 BOM
  • CSV-injection warning for values starting with =, +, - or @
  • Up to 5,000 rows, seedable, with preview and size summary

CSV Dataset Generator example

Customer import file

Input:

id:id
name:fullName
email:email
plan:pick:free|pro
signup:date:2024-01-01,2024-12-31

Output:

id,name,email,plan,signup
1,Freddie Mitchell,freddie.mitchell@example.com,pro,2024-05-31
2,Aurora Taylor,aurora.taylor@example.net,free,2024-06-10

Frequently asked questions about CSV Dataset Generator

How do I define columns?

One per line as name:type[:options], for example email:email, age:int:18-65, status:pick:active|inactive or created:date:2023-01-01,2024-12-31. Append ? to a name to make it nullable.

Which delimiters and quoting rules are supported?

Comma, semicolon, tab and pipe; RFC 4180 minimal quoting or quote-everything; LF or CRLF line endings; optional UTF-8 BOM for Excel.

Does the tool warn about CSV injection?

Yes — if a value starts with =, +, - or @ the tool warns that spreadsheet apps may treat it as a formula.

Are names and emails consistent within a row?

Yes. Person-related columns in the same row share one generated identity, so first name, last name, username and email agree.

References