dummy-data
Dummy data — also called test data, sample data, or placeholder data — is realistic-looking fake records used for development, demos, and testing. Common fields include full names, emails, phone numbers, addresses, birthdates, company names, job titles, and lorem ipsum paragraphs. The ZTools Dummy Data generator builds rows of any shape, supports CSV / JSON / SQL INSERT output, runs entirely in the browser, and never persists data. The generator picks values from open name lists and templated formats — output looks plausible but matches no real person.
Use cases
Seed a development database
Need 10,000 fake users to load-test a new feature. Generate as SQL INSERT or CSV, import into Postgres / MySQL / SQLite.
Demo screenshots without real data
Sales demos must not show real customer data. Generate fake names + emails matching the schema, take screenshots, ship.
Spreadsheet practice / training
Excel courses need realistic data. Generate a workbook of orders, customers, transactions to use in lessons.
Form-validation testing
Validate that the form correctly accepts edge cases (long names, accented characters, plus-aliased emails). Generators can produce these on demand.
How it works
- Pick fields — Choose from 40+ field types: full-name, first-name, last-name, email, phone, street, city, country, zip, company, job, date, age, gender, lorem, image-url, currency, boolean, custom-list.
- Configure each field — For email, pick "personal" (gmail, yahoo) or "company" (custom domain). For phone, pick country format. For date, pick range.
- Set count and output — 1 to 100,000 rows. Output as CSV (with header), JSON array, JSON lines, or SQL INSERT statements.
- Download or copy — Stream large outputs to a file directly — avoids browser-tab freezing on 100k rows.
Examples
Input: Fields: name, email, age; count 5; output JSON
Output: [{"name":"Maria Garcia","email":"maria.garcia@example.com","age":31},{...},...] — five plausible-looking but fake user records.
Input: CSV with header, 1000 rows
Output: Header: name,email,age. Then 1000 data rows. Pasteable into Excel / Google Sheets / a database import wizard.
Input: SQL INSERT for 100 customers
Output: INSERT INTO customers (name, email, age) VALUES ('Maria', 'maria@example.com', 31), ...; — quoted, escaped, ready to paste into a SQL prompt.
Frequently asked questions
Is the data legally usable?
For development and testing, yes. The names come from public lists and aren't tied to specific real individuals — but coincidences are possible (the "any resemblance is coincidental" disclaimer applies).
How realistic is the geographic distribution?
Names lean US/Western unless you pick a locale. We support en-US, en-GB, es, fr, de, ja, zh locales — names match the locale convention.
Are emails routable?
Use @example.com / @example.org / @example.net (RFC 2606 reserved domains) — never deliverable, never spammy. Custom domains are also supported.
Does it support nested objects?
Yes — JSON output mode allows nested structures (user.address.city). CSV flattens; SQL stays one row per record.
Privacy?
Generator runs in the browser. Generated data never uploads. Use the data however you want.
How big can I generate?
100,000 rows works in modern browsers; larger uses streaming download to avoid memory pressure. For million-row workloads, use a CLI tool.
Tips
- Use @example.com domains for emails — RFC-reserved, never accidentally hits a real inbox.
- For geographically realistic data, pick a locale and stick to it within one dataset — mixed-locale names look uncanny.
- When seeding a database, use sequential IDs in the output and let the database auto-increment its own ID column.
- For form-validation tests, configure edge-case generators (max-length names, plus-aliased emails, leap-day birthdays).
Try it now
The full dummy-data runs in your browser at https://ztools.zaions.com/dummy-data — no signup, no upload, no data leaves your device.
Last updated: 2026-05-06 · Author: Ahsan Mahmood · Edit this page on GitHub