Create a Mobile App from Your Data

AppSheet automatically creates a mobile app:

  1. Based on your data.
  2. Designed for a mobile device.


Based on Your Data

AppSheet automatically creates a mobile app based on the structure of your data. 

AppSheet automatically infers the structure of your data from the spreadsheet you provide. AppSheet creates a 'table' for each worksheet. A 'table' is a collection of rows with uniformly structured columns.

AppSheet automatically infers the data type of each column in your spreadsheet, such as text, number, date, time, image, etc. It recognizes more than 20 data types. AppSheet also automatically groups related columns to form composite columns. For example, FirstName, MiddleName, and LastName are recognized and treated as a 'Name'. Street, City, State, Zip, and Country are recognized and treated as an 'Address'. These inferences happen automatically but you can override them.

Data values are automatically displayed based on their type. For example:

  • An address column is geocoded and shown on a map.
  • A phone number column can be dialed or texted.
  • A numeric column can be displayed in a chart.

If you permit data to be added or updated, AppSheet automatically generates an input form based on the column types. For example:

  • An image column automatically launches the camera.
  • A drawing column captures a digital sketch.
  • A signature column captures a digital signature.
  • A text or number column can be bar code scanned.

AppSheet automatically creates views of your data. You can customize these views.

In short, the app creator defines the structure of data; AppSheet creates an app based on that structure.

Your app will not look like a mobile spreadsheet. Your spreadsheet is a data source, but you are creating a real mobile app.


Designed for a Mobile Device

AppSheet creates an app designed for a mobile device.

  1. Mobile devices have limited screen sizes, so each data row is presented using mobile-optimized patterns.
    • Most data views are summary views that expand to show the full details when an entry is clicked/tapped.
    • In summary views, we show the key value and as many other columns as possible.
    • Actionable values (that launch actions when you tap them) like phone numbers and emails are preferentially shown.
    • Columns on the left of the spreadsheet are considered more important than columns on the right.

  2. Mobile-appropriate input controls are provided for different column data types.
  3. Apps that require connectivity and constantly utilize the network significantly reduce battery life. AppSheet apps are designed for offline access with only occasional synchronization over the network. The data used by the app therefore is cached locally on the device. This does constrain the volume of data that can be used in an app-- for this reason, in the current version of AppSheet, avoid extremely large spreadsheets. All updates on the device are made locally and pushed to the backend spreadsheet only during synchronization.

  4. Each app can be branded in a variety of ways, including with a logo. When you distribute your app to your users, you will control the brand experience for your users.
Have more questions? Submit a request


Article is closed for comments.