Transform any data into beautiful, dynamic, and functional apps with our Awesome Table web app. This article introduces how to easily create interactive apps using data stored in Google Sheets and Microsoft Excel 365.

2

Watch the video to know what Awesome Table can do for you.

Awesome Table is perfectly integrated into the Google and Office 365 environment. The only requirement for using Awesome Table is to have either a Google account (Gmail, Google Workspace) or a Microsoft account (Office 365, Outlook, Hotmail).

Display always up-to-date information effortlessly

For Google users, you can easily collaborate with others to update your datasheet by applying the appropriate sharing settings in Google Sheets and Microsoft Excel. Awesome Table will always use the most up-to-date information from your spreadsheet. Add new data to your spreadsheet and refresh your Awesome Table app.

Quickly sort out data with our interactive filters

Add several filters to view and retrieve easily the data you want. You can use either a simple filter or multiple filters:

• Date filter
• Category filter
• String filter and more!

The simplicity and power of keywords (no coding skills required)

You don't have to be a coder to create Awesome Table apps. Keywords specify the way you want to handle and display your data.

For instance, you can tell Awesome Table that you want an entire column to be displayed either as an image, link, button, charts, etc. - all without writing a single line of code.

That means you can create a fully functional app using just keywords!

Embed your app on any website

Awesome Table app can be embedded on any website like the Classic or New Google Sites, WordPress.org, Joomla, Weebly, and many other CMS and website builders:

• Copy the embed code
• Paste it to your web page
• Embed your page

How to use Awesome Table?

1. Choose a template from our gallery

Our template gallery is useful for:

• New Awesome Table users
• Users who want to import and display their data using Awesome Table apps 

2. Use add-ons to uncover new possibilities

Awesome Table add-ons are smaller but easy-to-use scripts that automate the creation of some of the most frequently used apps.

You can install our add-ons directly within the Google Sheets user interface. Add-ons answer to specific needs like geocoding addresses, listing files or folders from Google Drive, and listing Google Sites on a Google Workspace domain.

3. For advanced users: manage layout and style with templates 

If you want to separate data and layout to customize apps, then read our article: Awesome Table Templates

In another sheet, write HTML, CSS, and JavaScript to create apps more to your liking. With templates, you can decide what to display and how to display it.
 

Different apps to match your specific needs

Choose one of the Awesome Table apps depending on your needs:

Copy this template

What's next?

Start using Awesome Table with our Getting Started articles: How to create your very first Awesome Table app.