Awesome Table templates

Personalize your apps using your own code (HTML, CSS, and/or Javascript). You can also choose what data to display using template markers and how your data is rendered.

1. Create a template sheet

Google Sheets
Microsoft 365

Click the Add Sheet button to insert a blank sheet.

Rename the new sheet. In our example, we named it Template.

Click the New sheet icon to insert a blank sheet.

Then, rename as needed (In our example, we named it Template).

2. Set up the template sheet

Your template must be set up like your datasheet and must follow specific preparations to be configured correctly. Your template sheet can contain just one or all template types or components (depending on your specifications).

The following table lists the different types of template available.

Template	Description
HTML	HTML templates contain the HTML code that gives framework or structure to your app and the relevant {{markers}} that make your template dynamic. Templates enhance your Awesome Table app and improve the user experience: use HTML code to specify the layout or the way you want to present your data use markers if you also want to make your template dynamic: {{markers}} Google Sheets Microsoft 365 Learn more about HTML templates.
CSS	Cascading Style Sheet (CSS) templates contain the styling code that gives your Awesome Table app its desired look and layout. CSS lets you customize colors, font, size and placement of elements (headings, paragraphs, images, and lists). Google Sheets Microsoft 365 Learn more about CSS templates.
Javascript	JavaScript templates let you add sophisticated behaviors or actions to your Awesome Table app. For example, you can: include dynamic changes or updates to your content manipulate and/or animate images and other HTML elements perform operations or form validation Google Sheets Microsoft 365 Learn more about Javascript templates.
Header	Header templates are static elements displayed on top of your Awesome Table app. These templates can be fully customized with HTML (text, images, hyperlinks). Header templates are mainly used to: insert logos or icons, map legends or titles in your Awesome Table app link your own external CSS, fonts, icons (for example, Font Awesome) and import CSS or JavaScript libraries (for example, BootStrap and Material Design) Google Sheets Microsoft 365 Learn more about Header templates.