AnyTool
Your files never leave your device. All processing happens locally in your browser.

How do I generate fake test data for names, emails and addresses?

Open AnyTool Fake Data Generator, build a schema by adding columns and choosing a field type for each — first name, email, phone, full address, company, date, number, UUID and more — set how many rows you want, then generate. Pick a preset like User, Product or Address book to start in one click. Switch the output between a live table, JSON, CSV or SQL INSERT statements, and copy it or download a file. Everything runs in your browser from clean, bundled word lists — the data is synthetic and nothing is uploaded.

  • 30+ field types: names, emails, phones, addresses, companies, dates, numbers, UUIDs, colours and more
  • Schema builder: add, rename, reorder and remove columns; one-click User / Product / Address-book presets
  • Export as a table, JSON array, CSV, or ready-to-paste SQL INSERT statements (with your table name)
  • Optional seed for reproducible output — the same schema gives the same rows every time
  • Clean, family-friendly, obviously-fake data; example.com emails and test card numbers — never real PII

What is

Synthetic Test Data

Synthetic (fake or mock) test data is artificially generated data that mimics the shape and field types of real records — names, emails, addresses, numbers, dates — without referring to any real person. It lets developers and QA engineers populate databases, demos and test suites with realistic-looking rows while avoiding the privacy and compliance risk of using real production data.

Generators

Related terms

Mock dataDatabase seedingTest fixturesSchemaCSV / SQL export

Frequently Asked Questions

Common ones include first/last/full name, username, email, phone, street address, city, state, country, zip, company, job title, dates, numbers, decimals, booleans, UUIDs, colours, URLs and IP addresses.

A good fake data generator offers a broad menu of field types grouped by purpose. AnyTool covers personal fields (first name, last name, full name, username), contact fields (email, phone, URL), address fields (street, city, state, country, zip), business fields (company, job title, department), text (word, sentence, paragraph), numbers (integer, decimal, boolean, amount, currency), dates and times, and technical values such as UUID v4, hex colour, IPv4, MAC address, plus clearly-marked test card and IBAN values. You pick a type per column and the engine fills every row accordingly.

Yes. AnyTool exports the rows as a JSON array of objects, RFC-4180 CSV, or SQL INSERT statements with your own table name, and you can copy or download each.

After you generate the rows you can switch the output format at any time. JSON gives a pretty-printed array of objects ideal for API mocks and JavaScript apps; CSV gives a header row plus escaped values for spreadsheets and database imports; SQL produces one INSERT statement per row using a table name you choose, with values properly quoted and escaped. A plain preview table is also available. Each format can be copied to the clipboard or downloaded as a .json, .csv or .sql file — all generated locally in your browser.

No, it is entirely synthetic. The names, addresses and companies are invented, emails use example.com / test domains, and card and IBAN values are test-only — never real PII.

Every value is generated from small, clean, family-friendly word lists bundled with the tool, so it does not refer to any real person or organisation. Emails use the reserved example.com and test domains, phone numbers use the 555-01xx range set aside for fiction, the test card number is a Luhn-valid but non-real number in the standard 4111 1111 test style, and the IBAN is format-only and clearly marked TEST. It is meant for prototypes, mockups, database seeding and test suites — never as real personal data and never for real payments.

No. The schema you build and the rows you generate stay in your browser — there is no faker library download, no CDN and no server round-trip.

AnyTool Fake Data Generator runs entirely client-side in JavaScript. It bundles its own small data pools and a tiny seedable random-number generator, so nothing is fetched and nothing you build or generate is sent anywhere, logged or stored. Close the tab and the data is gone, and the page works offline once it has been cached. Turning on a seed makes the output reproducible without changing where the work happens — still 100% in your browser.

Detailed Explanation

Methodology

How the Fake Data Generator Works

AnyTool Fake Data Generator builds every row in the browser from a reusable, dependency-free engine that bundles its own small, clean, family-friendly word lists — there is no faker library, no CDN and no server round-trip. You define a schema as an ordered list of columns, giving each a name and one of 30-plus field types: personal (first name, last name, full name, username), contact (email, phone, URL), address (street, city, state, country, zip), business (company, job title, department), text (word, sentence, paragraph), numeric (integer, decimal, boolean, amount, currency), date and time, and technical values (UUID v4, hex colour, IPv4, MAC address, plus clearly-marked test card and IBAN numbers). Choosing a row count then fills each column for every row, with column names de-duplicated automatically and the count capped at 1,000 so a large value can never freeze the tab.

  • Reusable client-side engine with bundled clean word lists — no faker, no CDN
  • 30+ field types across personal, contact, address, business, text, number, date and tech groups
  • Schema = ordered columns, each with a name and a field type
  • Row count clamped to 1–1,000; duplicate column names auto-suffixed
  • Generation is pure JavaScript in the browser — no server round-trip
Use Cases

Presets and Export Formats

To start quickly the tool ships one-click presets — User, Address book, Product, Employee and Transaction — that load a sensible set of columns you can then rename, reorder, add to or remove. The same generated rows can be viewed and exported four ways: a live preview table, a pretty-printed JSON array of objects for API mocks and JavaScript apps, RFC-4180 CSV (header row plus comma-escaped values) for spreadsheets and database imports, and SQL INSERT statements that use a table name you supply with values quoted and escaped for safe pasting into a database. Each format can be copied to the clipboard or downloaded as a .json, .csv or .sql file. An optional seed makes output reproducible: with the seed on, the same schema and row count regenerate the exact same rows, which is ideal for stable test fixtures and demos.

  • Presets: User, Address book, Product, Employee, Transaction
  • Export as preview table, JSON array, RFC-4180 CSV, or SQL INSERT statements
  • SQL uses a custom table name with quoted, escaped values
  • Copy to clipboard or download a .json / .csv / .sql file
  • Optional seed → reproducible, stable rows for fixtures and demos
Privacy & Security

Privacy and the Honest Fake-Data Note

Because all generation happens in the browser, neither the schema you build nor the rows you generate are ever uploaded, logged or stored — closing the tab discards everything, and the page works offline once cached. The tool is explicit that the output is synthetic and fictional: invented names, addresses and companies that refer to no real person or organisation, emails on the reserved example.com and test domains, phone numbers in the 555-01xx range set aside for fiction, a Luhn-valid but non-real test card number in the standard 4111 1111 style, and a format-only IBAN clearly marked TEST. This data is intended for prototypes, mockups, database seeding and test suites — not as real PII and never for real payments or transactions.

Fake data generation: in-browser (AnyTool) vs typical online generators
CapabilityAnyToolTypical online generators
ProcessingRuns entirely in your browserOften server-side / API-gated
Field types30+, grouped, with presetsVaries; sometimes limited free tier
Row limit (free)Up to 1,000 per generateOften capped at ~1,000 then paywalled
Export formatsTable, JSON, CSV, SQL INSERTUsually JSON/CSV; SQL sometimes paid
Reproducible seedYes — same schema, same rowsRare
Data safetyexample.com emails, test cards onlyNot always clearly fake
PrivacyNever uploaded, works offlineMay transmit or log your schema
Cost / signupFree, no signupOften gated or rate-limited

AnyTool generates every row locally from bundled clean word lists and uploads nothing.