elefcode

Fake / Test Data Generator

Generate realistic dummy data — up to 10,000 rows — as JSON, CSV, SQL or TypeScript for seeding databases, tests and mockups.

Identity

Person

Work

Location

Commerce

Data

Internet

Text

Your own columns

Output · 10 rows · 1.4 KB
[
  {
    "id": 1,
    "firstName": "Margaret",
    "lastName": "Turing",
    "email": "[email protected]",
    "city": "Nairobi"
  },
  {
    "id": 2,
    "firstName": "Alan",
    "lastName": "Thompson",
    "email": "[email protected]",
    "city": "Sydney"
  },
  {
    "id": 3,
    "firstName": "Hedy",
    "lastName": "Clarke",
    "email": "[email protected]",
    "city": "Cairo"
  },
  {
    "id": 4,
    "firstName": "Liam",
    "lastName": "Hamilton",
    "email": "[email protected]",
    "city": "Berlin"
  },
  {
    "id": 5,
    "firstName": "Tim",
    "lastName": "Meyer",
    "email": "[email protected]",
    "city": "Mumbai"
  },
  {
    "id": 6,
    "firstName": "Chen",
    "lastName": "Sharma",
    "email": "[email protected]",
    "city": "Nairobi"
  },
  {
    "id": 7,
    "firstName": "Liam",
    "lastName": "Stroustrup",
    "email": "[email protected]",
    "city": "Cairo"
  },
  {
    "id": 8,
    "firstName": "Fatima",
    "lastName": "Haddad",
    "email": "[email protected]",
    "city": "Singapore"
  },
  {
    "id": 9,
    "firstName": "Anita",
    "lastName": "Johnson",
    "email": "[email protected]",
    "city": "London"
  },
  {
    "id": 10,
    "firstName": "Margaret",
    "lastName": "Silva",
    "email": "[email protected]",
    "city": "Amsterdam"
  }
]

Emails use the reserved example.com domains, phone numbers the fictional 555-01xx range, and cards Stripe's test numbers — nothing reaches a real person or account.

Advertisement

Guide

About the Fake / Test Data Generator

Building and testing software needs data, and typing out sample records by hand is slow and unrealistic. This generator produces convincing fake data — names, emails, addresses, dates, prices, UUIDs, and more — so you can seed a database, populate a UI mockup, test an import, or load a form with realistic values in seconds. Pick the fields you want, choose how many rows, and export as JSON, CSV, or ready-to-run SQL inserts.

Everything is generated locally and is entirely synthetic — no real people, and nothing is sent to a server.

Choose the right export format

  • JSON — for API mocks, fixtures, and front-end state.
  • CSV — for spreadsheets, bulk imports, and data pipelines.
  • SQL — ready-made INSERT statements to seed a database table directly.

Realistic, related fields

Fields are generated so they hang together — the email and fullNameare derived from the same first and last name, for example — which makes the data look genuine rather than random noise. That realism matters when you're demoing a UI or testing how your app handles real-world-looking input.

How to use it

  1. 1Select the fields you need (id, name, email, address, and more).
  2. 2Set how many rows to generate.
  3. 3Choose JSON, CSV, or SQL output — and a table name for SQL.
  4. 4Copy or download the data, or regenerate for a fresh set.

Frequently asked questions

Is the generated data real?

No. Everything is synthetic and assembled from bundled word lists, so it resembles real records without referring to any actual person.

What formats can I export?

JSON for code and APIs, CSV for spreadsheets and imports, and SQL INSERT statements for seeding a database table directly.

How many rows can I generate?

Up to 10,000 at a time. Emails and usernames include the row number, so they stay unique and can seed columns with a UNIQUE constraint.

Can I add my own columns?

Yes. Add a column that picks from your own comma-separated values (free, pro, enterprise) or a number from a range. They are included in every format, and in CREATE TABLE.

Are the email addresses valid?

They are realistically formatted but use example domains, so they are safe for testing and will not reach real inboxes.

Is any data sent to a server?

No. Generation runs entirely in your browser, so you can even use it offline.

Learn more

GuideGenerating Realistic Test Data (Without Using Real People)

Related tools

UUID GeneratorJSON ↔ CSVJSON FormatterLorem Ipsum