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.

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.