How to use the mock data generator
- Pick a template or build your own list of fields. Give each field a name and a type.
- Set how many rows you want and choose the output format.
- Click Generate, then Copy or Download.
Field types
| Group | Types |
|---|---|
| Identity | Row number, UUID, first name, last name, full name, username, email, phone number |
| Work | Company, job title, department |
| Places | Street address, city, US state, ZIP code, country, latitude, longitude |
| Numbers | Whole number, decimal, price, percentage, true or false |
| Dates | Date, date and time (ISO 8601), Unix timestamp |
| Internet | IPv4, IPv6, MAC address, URL, domain, user agent, HTTP method, HTTP status, hex color |
| Text | Word, sentence, paragraph, product name |
| Your own | Pick from a list you type, or always the same value |
The options box changes with the type. Numbers and dates take a range such as 18-65 or 2024-01-01..2026-12-31. A custom list takes values separated by commas, such as new, paid, shipped.
Why use fake data?
- Privacy. Copying production data into a test system puts real customers at risk and can break privacy law. Generated data has no real people in it.
- Volume. A page that looks fine with five rows may fall apart with fifty thousand. Generate a big set and find out early.
- Demos and screenshots look right with believable names and numbers.
- Repeatable tests. Enter a seed and the same data comes out every time, on any machine.
Is the data real?
No. Names are random pairs of common first and last names, emails use the reserved example.com family of domains, and phone numbers use the 555 range set aside for fiction. Addresses are invented. Any match with a real person is a coincidence.
Load the result into the SQL playground to query it, send it with the API tester, or convert it with JSON to CSV.
Private by design
This tool runs entirely in your web browser. Nothing you type or paste is sent to a server, logged or stored, so it is safe to use with internal addresses, configuration files and other work data. There is no sign-up and it keeps working offline once the page has loaded.
Frequently asked questions
How many rows can I generate?
Up to 100,000 at a time. The preview shows the first part and the download contains everything.
Can I get the same data again?
Yes. Type anything in the Seed box. The same seed and fields always give the same rows.
Which formats can I export?
JSON, CSV, TSV, NDJSON and SQL INSERT statements with a CREATE TABLE.
Is the generated data real?
No. It is random and uses reserved example domains and fictional phone ranges.
Can I add my own values?
Yes. Choose “Pick from my list” and type your values separated by commas.