Free 

templates 

for Google 

Sheets™

Install the add-on and get your template in 2 clicks.

Charts

Vector bars with rounded corners made of 1 formula

It dynamically adjusts based on the values in column A.

Each bar is colored according to the hex codes in column B, creating a stunning gradient effect.

Made of 1 formula and 1 conditional formatting rule

This dynamic Google Sheets template updates instantly when you modify the numbers in row 103.

Easily customize colors through the conditional formatting menu.

Simple bar chart formula based on char '|' repetition

Horizontal bar charts created entirely with formulas.

The secret lies in using the right font—Dela Gothic One—which makes the repeated "|" characters appear as a solid bar. This technique ensures that the chart looks clean and professional while remaining customizable.

Percentage values using square grid charts

Each grid is filled based on formulas and conditional formatting rules, dynamically updating to represent varying percentages for different groups.

This approach is ideal for visually tracking group performance or progress at a glance.

Vector filled/outlined bars with made of 1 formula

This chart uses a technique that combines filled and outlined bars by adjusting the width parameter.

Setting the width to 0 creates filled bars, while non-zero values generate outlined bars

Bubble charts with custom color, size, and fill

The formula uses three arrays for sizes, fills, and colors to create a visual representation of data with vector bubbles.

It leverages the SPARKLINE function to generate an array of colorful, circular shapes.

100+ unique patterns for bar charts

This formula generates dynamic pattern bars with characters overlaid, creating a visual representation using values and colors.

The example uses over 100 distinct patterns, making it highly customizable for data visualization.

Vector-scalable donut charts formula.

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

Star percent chart

Vector-scalable heart charts formula

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

Heart percent chart

Vector-scalable heart charts formula

Easily create multiple charts at once by copying the formula, with customizable colors to match data values.

Unlike standard charts, this formula enables mass chart production with vector scalability, perfect for automatic plotting in table rows.

SPARKLINE bars with labels

Custom labels at the end of bars to level up your bars

Add custom formula-based or hand-written labels for your SPARKLINE.

Play with different font colors, bold-italic options. Add hundreds of bars.

🔴Live Animations

Live animated Summer Olympics gold medal stats

Watch as Google Sheets comes to life with dynamic animations driven entirely by formulas!

This live visualization displays the Summer Olympics gold medal statistics over 30 periods.

Tools

Conditional borders based on column A values

Add a new value in column A: a dotted border automatically separates it from the previous section.

This feature provides a clear visual distinction between stages or actions, ensuring data is neatly organized and easy to follow.

Conditional borders based on column A values

When a new value appears in column A, a dotted border automatically separates it from the previous section.

This feature provides a clear visual distinction between stages or actions, ensuring data is neatly organized and easy to follow.

Experimental radio buttons made of formulas

The radio buttons are created using an experimental technique, which isn't natively supported.

This innovative solution uses formulas to simulate interactive radio button behavior within Sheets, pushing the boundaries of what is typically possible in this environment.

Checklist to help you start a new project

This checklist template includes a progress bar that visually tracks completion, providing motivational support as items are checked off.

It features an auto-color rule for task groups, making it easy to organize tasks and start new projects quickly.

Sheets Teble of Contents

List of all sheet in your Spreadsheet

Searchable list of all sheets.

Search by sheet name or sheet color (blue, red, etc.)

Refresh the list on demand.

Find this feature in the Tools menu of Cooltables Add-on.

Install the add-on and get your template in 2 clicks.

😎Get done more with Cooltables!

Try Sheets to BigQuery Integration and other key features

Cooltables is an essential tool designed to simplify your experience with Google Sheets™. Whether you're dealing with massive datasets or need advanced chart customization like the one above, Cooltables is packed with features to help you optimize your workflow.

Key Features:

With the Cooltables Add-On, you're not just limited to BigQuery integration—you can create visually appealing charts, manage data efficiently, and access upcoming features that will continuously enhance your Sheets experience.

Try the Cooltables Add-On today and discover how it makes working with Google Sheets™ easier, faster, and more enjoyable!

Install the add-on and get your template in 2 clicks.