Google Sheets Cozy Aesthetic Formulas

Tea timers, reading nook progress, and hygge-style trackers.

Tea steam timer

Put steep minutes left 0-10 in A1. Steam curls fade as tea finishes.

=REPT("🫖",1)&REPT("～",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" steeping"

🫖～～～～· · · · · steeping

REPT MIN MAX

Reading nook progress

Put pages read in A1 and book length in B1. Lamp glows as you read.

=REPT("📖",MIN(5,MAX(0,ROUND(A1/B1*5,0))))&REPT("🕯️",MAX(0,5-MIN(5,MAX(0,ROUND(A1/B1*5,0)))))&" p."&A1

📖📖📖🕯️🕯️ p.142

REPT ROUND MIN MAX

Cat nap counter

Put naps taken 0-5 in A1. Sleeping cats pile up on the couch.

=REPT("😺",MIN(A1,B1))&REPT("💤",MAX(0,B1-A1))&" naps"

😺😺😺💤💤 naps

REPT MIN MAX

Coffee cup fill bar

Put cups poured 0-5 in A1. Warm mugs fill your morning bar.

=REPT("☕",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" cups"

☕☕☕○○ cups

REPT MIN MAX

Hot cocoa warmth bar

Put warmth 0-10 in A1. Marshmallows melt into cozy cocoa blocks.

=REPT("🍫",1)&REPT("▁",MAX(0,B1-A1))&REPT("█",MIN(A1,B1))&" warm"

🍫▁▁▁███ warm

REPT MIN MAX

Page-turn reading progress

Put current page in A1 and total pages in B1. Corner dog-ear marks your spot.

="📕 p."&A1&"/"&B1&" "&REPT("📄",MIN(5,MAX(0,ROUND(A1/B1*5,0))))

📕 p.87/300 📄📄

REPT ROUND MIN MAX

Library mood picker

Put reading mood 1-5 in A1. Quiet shelf vibes from browsing to lost in a book.

=CHOOSE(A1,"📚 Browsing","📖 Reading","🕯️ Cozy","☕ Café read","🌙 Late chapter")

🕯️ Cozy

CHOOSE

Books on shelf cozy bar

Put books finished in A1 and shelf goal in B1. Spines fill the reading shelf.

=REPT("📗",MIN(A1,B1))&REPT("📕",MAX(0,B1-A1))&" read"

📗📗📗📕📕 read

REPT MIN MAX

Cat on lap comfort meter

Put comfort 0-10 in A1. Purring cats show peak hygge level.

=REPT("🐈",MIN(A1,B1))&REPT("🛋️",MAX(0,B1-A1))&" cozy"

🐈🐈🐈🐈🛋️🛋️🛋️🛋️🛋️🛋️ cozy

REPT MIN MAX

Dog walk progress trail

Put blocks walked 0-10 in A1. Paw prints trail through the neighborhood.

=REPT("🐾",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))&" walk"

🐾🐾🐾🐾🐾····· walk

REPT MIN MAX

Fish bowl calm meter

Put calm level 0-5 in A1. Goldfish swim when the room feels peaceful.

=REPT("🐠",MIN(A1,B1))&REPT("💧",MAX(0,B1-A1))&" calm"

🐠🐠🐠💧💧 calm

REPT MIN MAX

Blanket wrap percent

Put coziness 0-10 in A1. Blanket blocks wrap your comfort percent.

=REPT("🧣",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))&" "&ROUND(A1/B1*100,0)&"% snug"

🧣🧣🧣🧣🧣░░░░░ 50% snug

REPT MIN MAX ROUND

Candle burn tracker

Put hours burned 0-10 in A1. Flame shortens as the candle melts.

=REPT("🕯️",1)&REPT("█",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))&" burned"

🕯️████░░░░░░ burned

REPT MIN MAX

Fireplace warmth bar

Put warmth 0-10 in A1. Logs glow as the hearth heats the room.

=REPT("🔥",MIN(A1,B1))&REPT("🪵",MAX(0,B1-A1))&" toasty"

🔥🔥🔥🔥🪵🪵🪵🪵🪵🪵 toasty

REPT MIN MAX

Rainy day window mood

Put rainy-day coziness 1-5 in A1. Clouds to tea-by-the-window vibes.

=CHOOSE(A1,"🌧️ Drizzle","☁️ Gray","🌦️ Clearing","🫖 Tea break","📖 Rain read")

🫖 Tea break

CHOOSE

Fluffy cloud nap timer

Put nap minutes left 0-10 in A1. Cloud dots count down rest time.

=REPT("☁️",1)&REPT("●",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" nap"

☁️●●●●○○○○○○ nap

REPT MIN MAX

Golden hour progress

Put sunset progress 0-10 in A1. Sky warms from blue to golden hour.

=REPT("🌅",MIN(A1,B1))&REPT("🌤️",MAX(0,B1-A1))&" glow"

🌅🌅🌅🌅🌤️🌤️🌤️🌤️🌤️🌤️ glow

REPT MIN MAX

Sweater weather index

Put sweater weather 1-5 in A1. Layers from light cardigan to full bundle.

=CHOOSE(A1,"🌤️ Light","🧥 Cardigan","🧣 Scarf","🧤 Gloves","🧦 Full bundle")

🧣 Scarf

CHOOSE

Hygge evening checklist

Put hygge tasks done 0-4 in A1. Candle, tea, book, and blanket check off.

=REPT("✅",MIN(A1,4))&REPT("☐",MAX(0,4-MIN(A1,4)))&" hygge"

✅✅☐☐ hygge

REPT MIN MAX

Cozy reading candle bar

Put chapters read in A1 and book length in B1. Candle and pages glow together.

=REPT("🕯️",MIN(3,MAX(0,ROUND(A1/B1*3,0))))&REPT("📖",MIN(5,MAX(0,ROUND(A1/B1*5,0))))&" ch."&ROUND(A1/B1*100,0)&"%"

🕯️🕯️📖📖 40%

REPT ROUND MIN MAX

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

Unlock playground