<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Back to Blog Listing
 |  June 27, 2017

While building sample apps with AppSheet is pretty easy, finding test data to drive the app can be a tedious process.

Picture this: You are one day away from presenting a mobile app solution to your client. They are looking for a solution to manage their customer interactions for their business, an independent car dealership located in West Seattle. Your task: Build a demo app that addresses their specific needs.

Creating the app is easy but to really showcase its power, you need a robust data set. Otherwise, it’s hard for clients or potential users to understand how it changes their business processes for the better. In other words, good test data sets lead to powerful sample apps.

When it comes to “creating” data, you have 2 options:

  • Build your own. You can pop an energy drink, take a sip, and type "Fake addresses" on Google Search. Before you know it, you've spent 4 hours creating fake customer names and addresses on a spreadsheet for a sample app.
  • Let a data generator build it for you. With test data generators, you can quickly (in minutes rather than hours) create a sample data set that you can use to test app functionality, as well as identify bugs.

What's a good test generator to use? Mockaroo.


Mockaroo is a simple, user-friendly data generator that can provide small or large volumes of realistic looking data. It allows you to quickly build test data based on your own specifications. No coding is required (sounds familiar, right?).

Example: Build a Sample App with Mockaroo Test Data in 3 Easy Steps

Remember the car dealership in West Seattle? Let's build a realistic customer schema for the dealership on Mockaroo.

  1. Select the Data Types.

There are more than 130 different data types on Mockaroo, ranging from Chinese first names to LinkedIn skills to dummy Image URLs.

mockaroo datatype 

Let's pick the First Name, Last Name, Street Address, City, State, Email Address, Date, Car Make, Car Model, and Car Model Year data type for the customer management app.

mockaroo schema

Done? One step down, two more to go!

  1. Choose an appropriate Format.

With Mockaroo, you can define the number of rows you'd like to generate as well as the format of the schema. There are numerous data formats ranging from CSV, JSON, SQL, to a simple Excel spreadsheet.

For this app, let's import 500 number of rows into an Excel spreadsheet. 

mockaroo download

Finally, take a sip of your energy drink, and click on the green "Download Data" button.

(One second later...) 

And there you have it! 500 rows of car-related customer data.

mockaroo customer data

  1. Build your App.

Now that you’ve got the hard part out of the way, import the test data schema into AppSheet and you have a robust sample app!

mockaroo sample app

Impress Your Clients or Users with Mockaroo

Within less than 5 minutes, you have a functional customer management app to present to clients or users. Your sample app is filled with realistic looking data that keeps all stakeholders engaged.

Building app prototypes for clients or users has never been easier. With test data generators like Mockaroo, you can easily demonstrate the power of AppSheet features to stakeholders.

Ready to close another deal? Try Mockaroo today.

Other blogs you might find useful: How to Build an App to Manage Your Event, How to Create an App for Your Business, How to Improve Company Communication Using a Mobile App, Mobile Sales: How to Organize Your Info on Just One App

Stay tuned to Features, Tips & Webinars for more new features and tips of making powerful apps.

Post Comment
[Features, Tips & Webinars, Partners, Blog Article]