After setting up your datasource, this article will show you how to use our Awesome Table web app to create your first People Directory.

1. Connect to the web app

To use Awesome Table, you first need to create a profile with us.

To do so, click SIGN IN WITH GOOGLE (if you own a Gmail/G Suite account), or SIGN IN WITH MICROSOFT (if you own an Office 365 or Outlook/Hotmail account), and accept the permissions:

• Google Users
• Microsoft Users

2. Create a new Awesome Table app

Click on + to create a new app:

• Google Users
• Microsoft Users

3. Select your data source (spreadsheet)

Next, click the Select button:

• Google Sheets
• Microsoft Excel for Office 365

Choose the relevant Google Sheets or Excel 365 file and click Select (or Open) respectively.

• Google Drive
• SharePoint (Office 365)
• OneDrive (Outlook.com)

4. Select the relevant datasheet

Select the relevant datasheet (the tab or sheet containing all your data that will be included in your Awesome Table app) and make sure that the default data-range includes all the columns needed for your app.

Your data source (from Google Sheets or Excel 365 file) can contain several tabs / sheets but only one can be chosen as the datasheet.

• Google Sheets
• Microsoft Excel for Office 365

Once you've selected the datasheet, Awesome Table’s editor will automatically detect the filled columns (you can also manually adjust this as needed). The prescribed format for the data-range is A1:yourLastColumn (e.g., A1:I). Then click the Create button to generate your app.

5. Apply the appropriate app-type

Finally, choose the appropriate visualization type for our app:

1. Click APP CONFIGURATION
2. Select Table as the visualization
3. Optional: Limit the number of rows displayed to 4
4. Select Filters, chart layout so the filters appear on top of your People Directory
5. Click UPDATE APP for the changes to take effect

For now, your app should resemble the image below:

It doesn't look like our end-product yet, but all of these will change in our next tutorial.