All tools

Fake Data Generator

Generate realistic fake names, email addresses, phone numbers, addresses, and more — in bulk. Build a multi-column schema, choose from 16 locales, and export up to 1,000 rows as CSV, JSON, or SQL. Free, no signup, and everything runs locally in your browser.

Schema

What data types can you generate?

This fake data generator covers 27 field types across six categories:

  • Person — full name, first name, last name, email address, phone number, username, password, birth date, gender, job title
  • Location — street address, city, state / province, ZIP / postal code, country, latitude, longitude
  • Business — company name, website URL
  • Internet — IPv4 address, MAC address
  • IDs & numbers — UUID, random number, boolean
  • Text — lorem ipsum word, sentence, paragraph

Combine any mix of these into a single dataset. A typical test dataset might include first name, last name, email, phone, street address, city, ZIP, and company — all generated together in one click.

Who uses a fake data generator?

Fake data — also called test data, dummy data, or mock data — is used wherever real personal information would be inappropriate, unavailable, or illegal to use:

  • Developers testing registration forms, checkout flows, and user profile pages need realistic-looking inputs that won't trigger false positives in validation.
  • QA engineers seed staging and development databases with hundreds of rows of dummy data to simulate production conditions.
  • UI/UX designers fill wireframes and prototypes with realistic names, addresses, and email addresses so mockups look credible in client presentations.
  • Data engineers use sample datasets to test ETL pipelines, data models, and import scripts before connecting real data sources.
  • Teachers and instructors demonstrate SQL queries, data analysis techniques, and database design with safe, fictional datasets.
  • Content creators need plausible-looking data for screenshots, tutorials, and blog posts without exposing any real person's information.

Build a complete schema — not just one field at a time

Most simple fake data generators let you pick one field and copy a list. That works for a quick email address, but it's useless when you need a full user table for a database seed script or a realistic CSV for an import test.

This tool works like a lightweight schema builder. Add as many columns as you need, give each one a name and a data type, and generate all the rows in one pass. Four presets cover the most common cases:

  • Person — first name, last name, email, phone, birth date
  • Address — street, city, state, ZIP, country
  • Company — company name, job title, email, website
  • Full Profile — ID, name, email, phone, address, country, company, and job title in one table

Column names are editable, so you can match your exact database schema or field naming convention before exporting.

Export fake data as CSV, JSON, or SQL

Once you've generated your rows, pick the export format that fits your workflow:

  • CSV — a header row followed by comma-separated values, ready to open in Excel, Google Sheets, or Numbers. Also works for database import wizards, pandas read_csv, and any tool that accepts flat files.
  • JSON — an array of objects with your column names as keys. Drop it straight into a REST API mock, a Node.js fixture file, a json-server database, or a front-end component that consumes JSON.
  • SQL — a ready-to-run INSERT INTO statement compatible with MySQL, MariaDB, PostgreSQL, and SQLite. Set the table name before exporting to match your schema. String values are properly single-quote escaped; booleans and numbers are unquoted.

Hit Download to save the file directly, or Copy to paste it wherever you need it. Up to 1,000 rows per generation.

Fake data in 16 languages and locales

Locale support is what separates a useful fake data generator from a toy. When you select a locale, the generated names, addresses, and phone numbers follow the conventions of that region — not just translated labels, but structurally correct data. A French dataset gets French names and French phone formats. A Japanese dataset gets Japanese names in kanji.

Supported locales: English (US), English (UK), English (Australia), French, German, Spanish, Italian, Portuguese (Brazil), Dutch, Polish, Swedish, Russian, Turkish, Japanese, Chinese (Simplified), and Korean.

This is useful for testing internationalised applications, checking that your UI handles non-ASCII characters, or simply demoing a product to an international audience with locally appropriate data.

Completely free — no account, no limits

There is no account to create, no API key to manage, and no daily row limit. Generate as much data as you need. All data is generated locally in your browser using Faker.js — nothing is transmitted to any server, and nothing is stored. Refreshing the page clears everything. The tool works offline once the page has loaded.