Make your tables look professional with 50+ ready-made styles or create your own style templates.
Listing updated:September 17, 2024
Works with:
3M+
Overview
Table Styles add-on lets you quickly apply a professional and uniform look to your tables in Google Sheets.

50+ PREDEFINED STYLES IN 6 GROUPS
    1. practical
    2. monochrome
    3. light
    4. dark
    5. juicy
    6. contrasting

Just select your data and use one of the predefined styles that come with the add-on. The templates are very flexible in use as they let you apply format only of those table elements that you check off.

CUSTOMIZE EXISTING & CREATE NEW STYLES

You can edit all pre-supplied styles and save them as new templates.

Or create your formatting pattern from scratch and use it in any spreadsheet: add borders and customize their appearance, change font and background color in any table part like header or alternating rows stripe.
 
At the same time, the add-on gives you the possibility to edit or delete all your custom templates to keep them up-to-date.

APPLY WHOLE STYLE OR ONLY ITS PARTS

You can apply only parts of the style to your table. Select those you'd like to put on: 
    * font, its size, color &/or formatting
    * fill color
    * borders, their style & color
    * horizontal/vertical alignment
    * text wrapping

30 DAYS OF FREE USE

Fully functional 30-day trial period. All payments are secure and include an unconditional 30-day money-back guarantee.

If you have any questions about adding or applying table styles, please post them here:
https://www.ablebits.com/docs/google-sheets-apply-table-styles/
We'll be happy to assist!

Table Styles is a proud member of the Ablebits product family. We build add-ons that help you make the most of Google Workspace. Visit our official website to learn more:
https://www.ablebits.com/google-sheets-addons.php
––––––––––
WHAT'S NEW

***** V2.0 (14 December 2021)*****
★ New features ★
- Meet the new version! With 52 various style templates grouped into 6 main types.
- You can finally format border colors & styles and apply automatic horizontal alignment (based on the data type) to all cells.
- Apply only parts of the style to your table. Select and format all, some, or one of the following: font, its size/formatting/colors, fill colors, borders, horizontal/vertical alignment, text wrapping.
- We introduced yearly & lifetime plans. You can still enjoy a fully functional trial version of the add-on for 30 days.

Improved:
- Enjoy the new design! Everything you need is stored in a single pane now. Visit the help page for more details.
- Editing multiple table elements is finally possible. Select all necessary elements like header row + left column to edit and apply the same style to all these selected parts at once.
- More fonts are available for you to use in your styles.
Fixed:
- Didn't adjust alternating colors if you added/deleted rows inside your formatted table.

***** Version 1.5 ***** 
See bold, italics, and alignment formatting of your styles in the preview.

***** Version 1.1 ***** 
We added more default styles, try them out!
Additional information
PricingFree of charge trial
Developer
Privacy policy
Terms of service
Table Styles will ask for the permissions shown below. Learn more
Table Styles will need access to your Google account
This will allow Table Styles to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
View and manage data associated with the application
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Cuauhtemoc Chamorro
March 16, 2022
Nice tool for making professional looking tables in Google Sheets, the add on has been updated with better formatting options than the prior version and it correctly detects adding/removing rows and columns updating the formatting accordingly. Definately recommended if you need to format tables in Google Sheets or just want your documents to look more polished.
Is this review helpful?
Yes
No
Profile Picture
Brandon Zitting
December 5, 2022
Fantastic tool! Project manager here. I absolutely love how it works and use multiple pieces of the package each week. Great value for your money.
Is this review helpful?
Yes
No
Profile Picture
Pavel Diptan
April 11, 2022
Used to be good, then all of a sudden stopped working completely.
Is this review helpful?
Yes
No
Profile Picture
Ellen Lind
May 14, 2021
It's very limited and useless. It only provides the option for a handful of fonts and colors, and table settings. I would pay for an add on that could provide true table styles, but even for free this one was disappointing. It should have at least had the option of all fonts & colors available within the google sheets. For example my office has branding colors & fonts that we use (Raleway mainly).
Is this review helpful?
Yes
No
Profile Picture
Alessandro Previti
June 10, 2021
It does what it says and it does it well. Old reviews state you can't create custom styles, this is not anymore actual. Table Styles add on lets the user easily create styles with custom colors. Not all fonts are available, but the available set is sufficient for most situations. Currently there is no way to save or set table border colors, this is quite an annoying limitation, I will update the review when and if this will change.
Is this review helpful?
Yes
No
Profile Picture
Irfan Akram
August 9, 2020
Great add-on for quickly formatting table and should fulfill basic needs for most people. Some of the colour schemes are a little jarring but beggars cannot be choosers! Request to Ablebits - can this add-on be make available in Google docs? I find myself creating and formatting the table in Google Sheets and than doing a copy and paste into Google docs. Or am I missing something basic?
Is this review helpful?
Yes
No
Profile Picture
Anatolii
September 6, 2022
Time saver.
Is this review helpful?
Yes
No
Profile Picture
Scott Golas
January 10, 2022
Changed the app without notice. Lost saved formats. Poor roll out and communications.
Is this review helpful?
Yes
No
Profile Picture
Michael Smits
August 1, 2020
basic but then again that is what setting up table styles should be :) what I miss is more options like column width, row hight, border style and colors but then again, people who hunt free apps always want more Overall it's a useful shortcut on sheets options I guess good enough for me
Is this review helpful?
Yes
No
Profile Picture
A User of Table Styles
January 6, 2015
It's ok but it only formats superficially: - If you re-arrange the values of your table, guess what happens to your formatting! It all goes weird instead of keeping the formatting in place and only moving the values. - Same happens when you add/remove a line or column. Then you need to format the entire thing again. - If you select everything including the last column and there are no more columns on the right, the tool bug and has the "working" forever. It simply crashes there. So I dno't even bother waiting. I simply X it off and re-open the tool.
Is this review helpful?
Yes
No
1-10 of 36
Search
Clear search
Close search
Google apps
Main menu