AppSheet builds an app based on the “table” structure of data in your spreadsheet. AppSheet will attempt to understand the structure of your spreadsheet and there are simple ways to help with that. The more complex your structure is, the more difficult it is for AppSheet to translate it into a working mobile app. For example, pivot tables don’t work well with AppSheet’s system.
First, you’ll want to make sure your spreadsheet is neat and tidy. Make sure your columns are clear and if possible, add a couple of rows of data before you publish. Your spreadsheet should also have a defined set of columns and corresponding headers. AppSheet will read the table in the first worksheet of your spreadsheet to translate it into a mobile app. You’ll have the chance to utilize other worksheets in the workbook later.
Assign meaningful headers to the columns in your spreadsheet-- this will help AppSheet identify the values in those columns. Try to use common titles in English (we plan to support more languages in future releases). For example, if you are adding a column with telephone numbers, it helps AppSheet identify the values in that column as telephones if the title (header) of the column is called Telephone, or Telephones, or Phone Number.
AppSheet will more quickly recognize the columns if the format of each cell in the column is the same. For example, if you have a column with dates, make sure that all of the dates in the column share the same format.
Finally, new data should be added as new rows, not as columns.
In the next section, we'll show you the different ways you can begin creating apps.