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).
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.
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
Different views to match your specific needs
Choose one of the Awesome Table views depending on your needs: