Fun Data Playground csv export
Field types ← Generator

CSV test data generator

Build a schema from 60+ realistic field types and download it as clean, spreadsheet-ready CSV — up to 100,000 rows, free, no signup, 100% client-side.

Generate CSV data → Browse field types

What the output looks like

id,first_name,last_name,email,city,registered_at
1,Elena,Rossi,elena.rossi7@example.org,Vienna,2025-03-18T09:41:26Z
2,Marco,Schneider,marco.s@example.com,Izmir,2024-11-02T14:07:52Z
3,Aisha,Yılmaz,aisha.yilmaz@example.net,Oslo,2025-01-27T08:15:03Z

Why CSV?

CSV is still the lingua franca of tabular data: every spreadsheet, BI tool and database import path understands it. It is the format to reach for when the data ends up in Excel or Google Sheets, a Postgres COPY or MySQL LOAD DATA statement, or a colleague's inbox.

CSV-specific options

  • Header row — toggle the first line of column names on or off to match your importer.
  • Automatic quoting — values containing commas, quotes or newlines are quoted and escaped correctly, so full addresses and free-text sentences won't break your parser.
  • Blank % — any field can emit empty cells at a rate you choose, which is the honest way to test how your pipeline copes with missing values.
  • Seed — set one and every export is byte-identical, so a fixture checked into your repo stays stable.

Quick recipe: load into Postgres

\copy customers FROM 'fundata_1000_rows.csv' WITH (FORMAT csv, HEADER true);

CSV compatibility and edge cases

Output uses commas as delimiters and standard double-quote escaping. A value is quoted only when it contains a comma, quote or newline; embedded quotes are doubled. UTF-8 preserves international names such as Yılmaz or Sørensen. Blank fields stay empty, so you can test how Excel, database imports and ETL jobs distinguish an empty cell from a populated value. For typed values and explicit nulls, use JSON instead.

Common CSV questions

Can I open the generated CSV in Excel or Google Sheets?

Yes. Keep the header row enabled, download the UTF-8 file and import it with comma as the delimiter. The same schema can also produce spreadsheet sample data as TSV when tabs are a better fit.

Can I reproduce the same CSV later?

Yes. Enter a seed before exporting. The same seed and schema produce byte-identical output, which is useful for committed fixtures and repeatable QA runs.

Need a database-ready fixture? See the database test-data guide.

Other formats

The same schema exports to all six formats — switch with one dropdown: TSV, JSON, NDJSON, SQL, XML. New here? Start with the getting-started guide or the full field type reference.