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.
Country United States (US)
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, 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, postal code, and company — all generated together in one click.
Example dataset
Here is a sample of the data this generator produces — names, emails, phone numbers, and cities (all fictional):
| first_name | last_name | phone | city | |
|---|---|---|---|---|
| Lelia | Lehner | Lelia_Lehner63@gmail.com | 1-696-536-2459 x6241 | Starkfort |
| Evalyn | Streich | Evalyn_Streich92@hotmail.com | 1-388-255-1457 x5541 | Newark |
| Laila | O'Connell | Laila_OConnell@yahoo.com | (895) 884-3509 x9631 | Bradleychester |
| Americo | Lubowitz | Americo.Lubowitz@gmail.com | 1-757-331-6338 x728 | Jerdehaven |
| Giovanny | Sauer | Giovanny_Sauer99@hotmail.com | (663) 319-8966 x353 | East Eliane |
| Laury | Becker | Laury_Becker24@gmail.com | 853-392-5539 x47298 | Tuscaloosa |
| Jeremy | Franecki | Jeremy_Franecki72@yahoo.com | 604-421-5971 x75428 | Vineland |
| Reginald | Smith | Reginald_Smith53@hotmail.com | 700.642.9732 x6197 | South Demarco |
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, postal code, 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.
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. The tool works offline once the page has loaded.