CleanorTools
Mock data

Mock Data Generator

Details

How to use Mock Data Generator

What the tool does, how to run it, and what to expect from the result.

How to generate mock test data

Mock data fills a table, a list, or an API stub so you can see how a UI behaves with content in it. What you need from it is enough rows, in the right shape, without spending twenty minutes typing names.

The records are generated in your browser and never transmitted. The schema is a fixed set of seven fields covering the common case of a user table, and you can export as JSON or CSV.

  • Choose how many records you need, up to 500.
  • Choose JSON for an API stub or a fixture file, or CSV for a spreadsheet or a database import.
  • Copy or download the output and load it into your test environment.
  • Rely on the id field when you need distinct values, since names and emails repeat quickly.
  • Add a few hostile rows by hand: an empty field, a 300-character name, an apostrophe, and an emoji, because those are the ones that will break your interface.

About this mock data generator

Generate up to 500 fake records at a time with common fields like id, name, email, city, age, and an active flag. Switch between JSON and CSV, then copy the result. All generation runs locally on your device.

Tips

Getting a better result out of Mock Data Generator

Specific settings and thresholds, not general advice.

  • The names collide fast, and the emails are derived from them. There are 16 first names and 14 last names, so 224 combinations, which means by around 18 records you have a better than even chance of a duplicate. Do not use this to test a UNIQUE constraint on a name or an email column, because the failure will be the data's fault rather than your schema's.
  • The id is sequential and therefore genuinely unique, running from 1 to however many records you asked for. That is the only field you can rely on to be distinct.
  • Clean test data passes tests that real data fails. Every record here has a plausible name, a valid email, and a filled-in city, and nothing in production looks like that. Add empty strings, very long values, an apostrophe in a surname, an emoji, and a right-to-left name by hand, because those are the rows that break your UI.
  • example.com is reserved by IANA for documentation and can never be registered, so it is genuinely safe. The other domains in the generated emails are not reserved, so never actually send mail to a generated address.
  • The CSV output quotes and escapes properly, doubling any quote inside a field and wrapping fields that contain commas or newlines, so it round-trips through a spreadsheet without corrupting.
Limits

What Mock Data Generator does not do

The honest boundary, so you do not lose time finding it yourself.

  • The schema is fixed at seven fields, so you cannot add, remove, or rename a column, or choose its type.
  • It generates a maximum of 500 records at a time.
  • It exports JSON and CSV only, with no SQL INSERT statements, no XML, and no SQL schema.
  • The names are all Western and contain no accents, no apostrophes, and no non-Latin scripts, so the data will not exercise your Unicode handling.
Reference

Terms used on this page

Short, plain-language definitions for the formats and settings above.

Files & formatsJSONJSON (JavaScript Object Notation) is a lightweight, text-based format for storing and exchanging structured data as key/value pairs and ordered lists. It is human-readable, language-independent, and the default format for most web APIs and config files.General
At a glance

Who Mock Data Generator is for

A quick way to understand who this helps, what it solves, and where it connects next.

Best fit

Developers, QA engineers, and designers who need sample data for testing and demos.

Ideal for

Quickly seeding a database, API, or prototype with realistic fake records.

FAQ

Common questions

Short answers for the questions people usually have before trying a utility like this.

Is the Mock Data Generator free?

Yes. It is completely free, with no sign-up, no watermark, and no usage limits.

Is the data uploaded anywhere?

No. All data is generated locally in your browser with the Web Crypto API, so nothing is uploaded or stored.

Can I export as CSV?

Yes. Switch the format to CSV to get comma-separated output ready for spreadsheets.

Can I use this to test a unique email constraint?

No, and it will look like your code is broken when it is not. The email is built from the first and last name, and there are only 16 first names and 14 last names in the pool, giving 224 possible combinations. By the birthday-paradox arithmetic that means a duplicate appears at around 18 records with better than even odds, and it is a near certainty long before you reach 100. The id field is sequential and genuinely unique, so use that when you need distinctness.

Is this data realistic enough to test with?

It is realistic in shape and unrealistic in the ways that matter. Every record has a plausible Western name, a valid email, a filled city, and an age between 18 and 67, so it exercises the happy path and nothing else. Real data contains empty fields, names with apostrophes, names in scripts your font does not have, addresses that are 300 characters long, and users who claimed to be born in 1900. Those are the rows that break a UI, and none of them are in here. Generate the bulk with this and add the nasty rows by hand.

Can I safely email the generated addresses?

No. example.com is reserved by IANA under RFC 2606 specifically so that it can never be registered, and mail to it goes nowhere, which makes it safe. The other domains used in the generated addresses are ordinary registrable names, and someone may well own them. Sending test mail to a generated address risks delivering it to a real inbox, so point your test environment at a mail catcher instead.

Can I change the fields?

Not here. The schema is fixed at seven columns: an id, a first and last name, an email, a city, an age, and an active flag. That covers the common case of needing a table of users to populate a UI, and it stops at exactly the point where you would want a custom schema. If you need specific fields and types, a code-level library such as Faker gives you full control and can be seeded so the data is reproducible across test runs.

Is the data generated on a server?

No. The records are built in your browser using its cryptographically secure random number generator, so nothing is transmitted, and the tool works offline.

Recommendations

You Might Also Like

Nearby tools from the catalog that fit the same job or workflow.

RCG
UtilityData

Random CSV Generator

Data

Choose columns and types to generate CSV test data with a header row. Free, in your browser, nothing is uploaded.

RJG
UtilityData

Random JSON Generator

Data

Build a field schema and generate arrays of random JSON objects. Free, in your browser, nothing is uploaded.

SFR
UtilityData

String From Regex Generator

Data

Enter a regex and generate random strings that match the pattern. Free, in your browser, nothing is uploaded.

RDG
UtilityData

Random Date Generator

Data

Generate random dates in a chosen range and format, one per line. Free, in your browser, nothing is uploaded.

RIA
UtilityData

Random IP Address Generator

Data

Generate lists of random IPv4 and IPv6 addresses with private-range or public-only options. Free, in your browser, nothing is uploaded.

RMA
UtilityData

Random MAC Address Generator

Data

Generate random MAC addresses with your chosen separator, case, and administration bits. Free, in your browser, nothing is uploaded.

Cleanor app

Do it all on your device

Cleanor puts these tools in one app: compress and convert images, video, and audio, work with PDFs, and scan text right on your device. Plus free up storage and clear inbox clutter with Email Cleaner. Start with a free trial.

  • iPhone
  • Android
  • Macsoon
  • Windowssoon
Get it on the App StoreGet it on Google PlayAll platforms & pricing