Create an AppSheet App from Excel

Before you begin, make sure you have:

• Google Account — for accessing AppSheet
• Excel file (.xlsx) with your data
• Google Drive — for storing your file

Excel file requirements:

• First row must contain column headers
• Each column must have a unique name
• Data should be structured (no merged cells)
• Ideally have a column with unique identifier (ID)

First, you need to upload your Excel file to Google Drive:

1. Open Google Drive (drive.google.com)
2. Click the "+ New" button in the top left corner
3. Select "File upload"
4. Find and select your Excel file (.xlsx)
5. Wait for the upload to complete

Tip: We recommend creating a separate folder for AppSheet files to keep everything organized.

Now let's create a new app in AppSheet:

1. Go to appsheet.com and sign in with your Google account
2. Click the "Create" button at the top of the screen
3. Select "App" → "Start with existing data"
4. Enter a name for your application
5. Select a category (or leave default)
6. Click "Choose your data" to select your Excel file

Important: The app name will be displayed to users, so choose a clear and descriptive name.

Connect your Excel file to the application:

1. On the data selection screen, click "Google Sheets"
2. Find your Excel file in the list or use search
3. Select the file and click "Select"
4. AppSheet will automatically analyze the file structure
5. Verify that tables and columns are correctly identified

Note: If your Excel file has multiple sheets, AppSheet will create a separate table for each sheet.

AppSheet automatically detects data types, but you should verify and adjust them:

1. Go to "Data" → "Columns"
2. Review each column and its data type
3. Change types as needed:
   • Text — for text data
   • Number — for numbers
   • Date — for dates
   • Email — for email addresses
   • Phone — for phone numbers
   • Image — for images
4. Mark the KEY column (unique identifier)
5. Configure LABEL — the column that will display as record name

Tip: Proper data type configuration improves app functionality and data validation.

Now let's configure how data will be displayed to users:

1. Go to "UX" → "Views"
2. AppSheet has created basic views automatically
3. Click on a view to edit it
4. Choose display type:
   • Table — table view
   • Deck — cards
   • Gallery — gallery (for images)
   • Map — map (for geolocations)
   • Calendar — calendar (for dates)
5. Configure which columns to display
6. Add sorting and filters as needed

Create convenient forms for adding and editing data:

1. Go to "UX" → "Views" and find the form
2. Or create a new form: "+ New View" → "Form"
3. Arrange field order (by dragging)
4. For each field you can configure:
   • Display name — name users see
   • Description — field hint
   • Required — if field is mandatory
   • Show? — whether to show the field
5. Add data validation as needed

Tip: Hide system fields (e.g., auto-generated IDs) to avoid confusing users.