Need some mock data to test your app?

Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats.

Need more data? Plans start at just $50/year.

Field Name
Type
Options
Add another field



Why is test data important?

If you're developing an application, you'll want to make sure you're testing it under conditions that closely simulate a production environment. In production, you'll have an army of users banging away at your app and filling your database with data, which puts stress on your code. If you're hand-entering data into a test environment one record at a time using the UI, you're never going to build up the volume and variety of data that your app will accumulate in a few days in production. Worse, the data you enter will be biased towards your own usage patterns and won't match real-world usage, leaving important bugs undiscovered.

Why is realistic data important?

When your test database is filled with realistic looking data, you'll be more engaged as a tester. When you demonstrate new features to others, they'll understand them faster. Real data is varied and will contain characters that may not play nice with your code, such as apostrophes, or unicode characters from other languages. Testing with realistic data will make your app more robust because you'll catch errors that are likely to occur in production before release day.

Why Mockaroo?

There are plenty of great data mocking libraries available for almost every language and platform. But not everyone is a programmer or has time to learn a new framework. Mockaroo allows you to quickly and easily to download large amounts of randomly generated test data based on your own specs which you can then load directly into your test environment using SQL or CSV formats. No programming is required.

Want to automate test data generation?

If you sign in using your Google account, you can download random data programmatically by saving your schemas and using curl to download data in a shell script via a RESTful url.


What's new in Mockaroo?

8/8/2017
Switched to easier to read font in page headers
7/31/2017
Added Animal, Plant, and Movie data types
7/25/2017
Added Firebase output format
7/20/2017
SSNs are now guaranteed to be valid
7/19/2017
You can now restrict locations by state.
7/18/2017
Data is now displayed in a table when previewing CSV, tab-delimited, excel, and SQL formats.
6/18/2017
Add Stock Industry, Market, Name, Symbol, Sector for all NYSE and NASDAQ stocks.
6/13/2017
Added Car Make, Model, and Year types.
6/13/2017
Added Product (Grocery) type.
4/22/2017
Improved name generator now pulls from a set of 9,000 male and female first names and 50,000 surnames across multiple languages.
3/12/2017
Added Support for Cassandra CQL collections.
3/11/2017
Added responsive support for wider monitors
1/23/2017
Added NHS Number type