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?

Some application frameworks, like Ruby on Rails, have great data mocking libraries. But not everyone is a programmer, has time to learn a new framework, or is at liberty to adopt a new platform. 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?

5/10/2016
Added mongoDB date formats.
5/9/2016
Lots of new data types including Avatars, IP v4 and v6 cidrs, MD5, SHA1, and SHA256, App Bundle ID, App Name, and App Version.
3/11/2016
Custom List and Dataset Column fields with the sequential distribution type no longer iterate in a nested fashion. You can use the new "cartesian" distribution type to get the old behavior. All existing sequential fields were migrated to cartesian.
3/10/2016
You can now generate xml data!
3/4/2016
Added search
2/9/2016
Generate image urls for dummyimage.com
2/7/2016
Yuuuge update! Projects, apply formula to any data type, custom frequencies for lists, and more.
1/26/2016
Added Base64 Image URL type
12/21/2015
Locations can now be restricted to specific countries
12/20/2015
Added LinkedIn skills data type.
12/3/2015
Added hex(str) and base64(str) formula functions.
11/18/2015
11/9/2015
Added epoch format to date fields and epoch(date) formula function to convert a date field to an epoch.
11/7/2015
Added digest(str, algorithm, encoding) formula function
10/4/2015
Added CORS headers to API responses for GET and POST
9/14/2015
Now supports custom delimiters.
8/28/2015
You can now use Ruby Math functions in formulas.
8/10/2015
Added a Naughty String data type as well as a naughty(field, percent) function to formulas. Happy testing!
8/4/2015
Added a "now()" function to formulas that returns the current date and time
7/13/2015
Added a "restart at" parameter to sequences.