Templates
Free Templates for Google Sheets™ by Cooltables
Enhance your Google Sheets experience with powerful, visually appealing, and functional templates, my collection offers innovative solutions that push the boundaries of what Sheets can do. From interactive radio buttons to advanced formula-driven features, these templates are designed to simplify complex tasks and add a polished, professional touch to your workflow.
To access and use these templates, install the Cooltables Add-on and navigate to the templates via the Add-ons menu, bringing the power of these custom creations to your fingertips.
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.
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.
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.
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.
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.
😎Get done more with Cooltables!
Cooltables Add-On for Google Sheets™: Elevate Your Spreadsheets
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:
Sheets to BigQuery Integration: Load your Sheets data into BigQuery without worrying about cell limits or long loading times. Set it up once, and the add-on remembers your configurations, making future tasks a breeze.
Task History: Track up to 30 previous tasks, easily rename them for quick identification, and replay or modify tasks whenever needed.
Custom Charts & Visualization: Beyond standard features, Cooltables allows you to create stunning visualizations like the SPARKLINE-filled bar chart with rounded corners shown earlier. Customize colors, gradients, and layouts effortlessly.
Innovative Data Detection: Using the built-in "Tabler" script, Cooltables automatically detects table positions, headers, and column data types from your sheets.
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!