Fake Data Generator - JSON, CSV, TSV & SQL Test Fixtures

2026-07-29

  • fake data
  • test data
  • mock data
  • json
  • csv
  • sql
  • developer tools

When you need a fake data generator

  • Front-end needs rows before the API is ready
  • Test DB needs hundreds of INSERT statements
  • Demos must avoid real phone numbers and emails

The Fake Data Generator runs in the browser: pick column types, up to 1000 rows, preview and export JSON / CSV / TSV / SQL.

Field types (sample)

Full name, email, phone, username, password, address, city, company, job title, UUID, integers, floats, booleans, dates, URLs, IPs, colors, sentences and paragraphs. Add/remove columns and rename headers to match your schema.

Suggested workflow

  1. Choose Chinese or English locale.
  2. Map columns, e.g. id=UUID, name=Full name, email=Email.
  3. Set row count and click Generate.
  4. Download SQL for seeds, copy JSON for Postman, CSV for spreadsheets.

Works well with

Scenario Tool
Spreadsheet edits CSV → Excel tools
Small manual INSERT rows Generate INSERT
From real sheet Excel to SQL

Important

  • Values are random fiction, not real people
  • Do not use for spam or fraud
  • Complex foreign keys still need code (Faker, etc.)

Privacy

Nothing is uploaded during generation.

中文版