What is Awesome Table?

Transform any plain and boring data into beautiful, dynamic, & functional views with our Awesome Table web app. This article explains how to simply & easily create interactive views using data stored in Google Sheets (and now, Microsoft Excel 365).

info Starting in October 2019, you can now use Excel files as datasource from a Microsoft account. To know more, read our Getting Started with Microsoft Excel 365 article.

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, G Suite) or a Microsoft account (Office 365, Outlook, Hotmail).

For Google users, you can easily collaborate with others to update your datasheet by simply applying the appropriate sharing settings in Google Sheets.

Easily 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 views. 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.

This means you can create a fully functional view using just keywords!

Embed your view on any website

Awesome Table view 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
Publish 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 views

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 views.

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 G Suite domain.

warning Please note that our add-ons are not compatible with Microsoft Excel 365.

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

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

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

Different views to match your specific needs

Choose one of the Awesome Table views 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 view