About Mockaroo
Mockaroo is a web tool for generating realistic test data. You define the fields, choose a format and download the results.
What it does
Each field has a type, such as names, email addresses, dates or IP addresses, with options for blanks and formats. Rows can be exported as CSV, JSON, SQL or Excel, so the data fits most databases and tools. The site also offers mock API endpoints, so you can test a front end before the back end is ready.
Key features
- Pick field types like names, emails and IP addresses
- Export as CSV, JSON, SQL or Excel
- Create mock API endpoints for prototypes
- Derive fields from an example dataset
- Generate blanks and value ranges for edge cases
Who it's for
Developers and QA testers who need sample data for apps and databases. Designers use it to fill prototypes with believable content, and teachers use it to give students realistic datasets to work with.
Pricing and good to know
The free option generates up to 1,000 rows of data. Paid plans start at $60 per year and allow more rows. Mockaroo is also offered as a Docker image for running in your own private cloud, which suits teams with strict data rules.
Highlights
- Pick field types like names, emails and IP addresses
- Export as CSV, JSON, SQL or Excel
- Create mock API endpoints for prototypes
- Derive fields from an example dataset
