What is sheet art in Google Sheets?

Sheet art is visual output built inside a cell with formulas. Progress bars, star ratings, emoji scenes, and status icons made from CHAR, REPT, IF, and related functions. No images, charts, or add-ons required.

How is sheet art different from conditional formatting?

Conditional formatting changes cell color. Sheet art renders glyphs and emoji as text, so the result stays visible in exports, prints, and shared views where color rules may not travel.

Do I need an account to copy formulas?

No. Every formula in the playground library is free to browse and copy. Paste into any Google Sheet in seconds.

Does sheet art work in Excel?

These formulas are built for Google Sheets full Unicode support. Excel CHAR only covers codes 1 through 255, so many sheet art patterns will not translate.

Sheet art for Google Sheets

Visual formulas built with CHAR, REPT, and IF. See every result before you paste.

Plain cells are the status quo

Most trackers show raw numbers. Stakeholders skim past them. Conditional formatting adds color but not glyphs. Stack Overflow answers cover one pattern at a time. Sheet art is the composed layer: CHAR for symbols, REPT for bars and meters, IF for status switches, all rendered as text inside the cell.

See it before you paste

Better Sheets is the only library where every formula shows you what it looks like before you paste. Browse 1,828 copy-paste examples with live preview, category filters, and one-click copy. No add-on. No character map hunt.

The CHAR + REPT pattern

Start with a number in A1. Layer CHAR for block or star glyphs. Repeat them with REPT to fill a bar or rating row. Wrap with IF when status should change. The playground labels which functions each card uses and links to CHAR, REPT, and related guides when you want the syntax.

Browse by category

1800+ formulas across progress bars, ratings, emoji scenes, status icons, timers, and themed trackers.

Progress Bars Ratings Scenes Status Timers Pickers Layout Counters Writing Star Wars Lord of the Rings Gamers Kawaii Cozy Bullet Journal D&D Vaporwave Arts & Crafts Fantasy Sports Gym Money Habits Sales School Pokémon Holidays

Try a few favorites

Block progress bar

Put current value in A1 and goal in B1 (use 100 for percent). Ten blocks fill from empty to done.

=REPT("█",MIN(10,MAX(0,ROUND(A1/B1*10,0))))&REPT("░",MAX(0,10-MIN(10,MAX(0,ROUND(A1/B1*10,0)))))

████████░░

REPT

Star rating (5 stars)

Put current count in A1 and goal in B1 (e.g. 5).

=REPT("★",MIN(A1,B1))&REPT("☆",MAX(0,B1-A1))

★★★☆☆

REPT

X-wing Death Star trench run

Put lap position 0-10 in A1. Fighter closes on the Death Star.

=REPT("・",A1)&"＞🛸＜"&REPT("・",MAX(0,B1-A1))&"🌑"

・・＞🛸＜・・・・🌑

REPT MAX

Traffic light status

Put red, yellow, or green in A1.

=IF(A1="red","🔴",IF(A1="yellow","🟡","🟢"))

🟢

Common questions

What is sheet art in Google Sheets?: Sheet art is visual output built inside a cell with formulas. Progress bars, star ratings, emoji scenes, and status icons made from CHAR, REPT, IF, and related functions. No images, charts, or add-ons required.
How is sheet art different from conditional formatting?: Conditional formatting changes cell color. Sheet art renders glyphs and emoji as text, so the result stays visible in exports, prints, and shared views where color rules may not travel.
Do I need an account to copy formulas?: No. Every formula in the playground library is free to browse and copy. Paste into any Google Sheet in seconds.
Does sheet art work in Excel?: These formulas are built for Google Sheets full Unicode support. Excel CHAR only covers codes 1 through 255, so many sheet art patterns will not translate.

Open the full library

Copy any formula free. Members get courses on CHAR, REPT, and dashboard design when you want to go deeper.

Browse 1,828 formulas CHAR character table