About the Fake Data Generator
This Fake Data Generator makes made-up people and places for testing. Tick the fields you need from sixteen choices, including names, email, phone, username, company, job title, street address, city, state, postal code, country, date of birth, an IP address and a website, then choose how many rows you want, up to 1,000, and an output format: JSON, CSV, SQL INSERT statements or tab-separated text. Each row describes one consistent person, so the email and username match the name, and the city, state, postal code and country belong together. Copy the result or download it as a file. All the values are invented combinations from short built-in lists. Emails use example.com, phone numbers use the reserved 555-01XX range and IP addresses come from documentation ranges. It is English-language, mostly US data, and it runs on your device.
Updated September 2026
How to use the Fake Data Generator
- 1Tick the fields you want in your data. The defaults are full name, email, phone and city.
- 2Type how many rows you need, from 1 to 1,000, and pick JSON, CSV, SQL INSERT or TSV.
- 3For SQL, set the table name, using letters, numbers and underscores.
- 4Press Generate, then copy the result or download the file.
What fake data is good for
Empty screens are hard to design and hard to test. A few hundred believable rows show how a table scrolls, how a long surname wraps, and whether a search box works. Fake data also protects privacy: instead of copying real customers into a test system, you can use people who do not exist.
Because each row is built around one person, the results look natural. The email uses the same first name and surname as the full name, and the postal code belongs to the city.
Choosing fields and formats
Pick only what you need. Fewer fields make smaller files that are easier to read. JSON suits APIs and JavaScript code, CSV opens directly in spreadsheets, TSV is handy when values contain commas, and SQL INSERT loads straight into a database console.
In CSV and TSV, the first line holds the field names. Values that contain the delimiter, quotes or line breaks are wrapped in quotes so that they import correctly.
Realistic but safe values
- Emails end in example.com, which is reserved for examples and never delivers.
- Phone numbers use the fictional 555-01XX range.
- IP addresses come from the ranges 203.0.113.x, 198.51.100.x and 192.0.2.x, which are set aside for documentation.
- Websites end in .example, a name that never resolves.
- Dates of birth fall between 1950 and 2005.
Loading generated data into a database or spreadsheet
For a spreadsheet, generate CSV, save the file and open it, or paste it into a new sheet. For a database, generate SQL INSERT and run the statement in your database client after creating a table with matching column names. To turn a CSV file into JSON later, use the CSV to JSON Converter.
The lists are short and English-language, so this is not suitable for load tests that need thousands of unique people. For random strings, numbers, IP addresses and dates, use the Random Data Generator instead. For one value type, use Random Name Picker or Random Number Generator, and Lorem Ipsum Generator for filler text.
Features
- Sixteen fields for people, places and contact details
- Each row is one consistent person
- JSON, CSV, SQL INSERT and TSV output
- Up to 1,000 rows at a time
- Safe values: example.com emails and 555-01XX phone numbers
- Copy or download as a file
- Made on your device
Frequently asked questions
What is fake data used for?
Developers and testers use it to fill databases, try forms and import tools, build demos and screenshots, and check that reports and layouts cope with realistic names and addresses, without touching real people's information.
Are the names and emails real people?
No. Names are random pairs from short lists, so a pair may match a real person by coincidence. Emails always use example.com, a domain reserved for examples, so they cannot reach anyone. Companies and streets are invented, and the cities are real places used only as labels.
How do I generate fake data as CSV or JSON?
Choose your fields and the number of rows, pick CSV or JSON under Format, and press Generate. The result appears in the box. Copy it, or use the Download button to save fake-data.csv or fake-data.json.
Can I get SQL INSERT statements?
Yes. Choose SQL INSERT and type a table name. The tool writes a single INSERT INTO statement with one row per line, doubling any single quotes in values. Column names come from the field names, such as fullName and postalCode, so rename them if your table differs.
Why do phone numbers all start with 555?
Numbers in the 555-0100 to 555-0199 range are reserved for fiction, so they are not assigned to real subscribers. The area code is random from a short list. That keeps your test data from ringing real people.
How many rows can I generate?
Up to 1,000 rows each time, which is a few tens of kilobytes to a few hundred, depending on the fields. Press Generate again for another batch. Names repeat in large batches because the lists are short.