Bow cats, bubble tea meters, and pastel mood bars.

Kawaii star eyes mood

Put mood 1-5 in A1. Star eyes brighten as happiness rises.

=CHOOSE(A1,"😿","🥺","😊","🤩","✨🤩✨")

🤩

Bubble tea progress bar

Put pearls added 0-10 in A1. Tapioca fills the cup as you sip.

=REPT("🧋",1)&REPT("⚪",MAX(0,B1-A1))&REPT("🟤",MIN(A1,B1))&" boba"

🧋⚪⚪⚪🟤🟤🟤 boba

Bow cat happiness bar

Put happiness 0-10 in A1. Pink bows fill the cute counter bar.

=REPT("🎀",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))&" kawaii"

🎀🎀🎀🎀🎀🤍🤍🤍🤍🤍 kawaii

Kawaii whisker dots counter

Put count 0-10 in A1. Whiskers grow with each cute tally.

=REPT("・",MIN(A1,B1))&"🐱"&REPT("・",MIN(A1,B1))&" "&A1

・・・🐱・・・ 3

Pink bow mood picker

Put mood 1-5 in A1. Bow colors shift from shy to sparkling.

=CHOOSE(A1,"🎀","💗","💖","💕","✨🎀✨")

💖

Strawberry milk bar

Put sweetness 0-10 in A1. Pink blocks fill the strawberry milk glass.

=REPT("🍓",1)&REPT("░",MAX(0,B1-A1))&REPT("█",MIN(A1,B1))&" milk"

🍓░░░███ milk

Sparkle explosion counter

Put sparkle level 0-5 in A1. More sparkles mean maximum kawaii.

=IF(A1>0,REPT("✨",MIN(A1,5))&" kawaii!","")

✨✨✨ kawaii!

Plush bear HP bar

Put plush health 0-10 in A1. Teddy hearts show cuddly HP left.

=REPT("🧸",1)&REPT("💗",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))&" plush HP"

🧸💗💗💗🤍🤍🤍 plush HP

Rainbow gradient mood meter

Put mood tier 1-5 in A1. Pastel rainbow picks your vibe color.

=CHOOSE(A1,"🩷 Soft","🧡 Peachy","💛 Sunny","💚 Mint","💜 Dreamy")

💛 Sunny

Candy heart rating

Put rating 0-5 in A1. Candy hearts fill your sweetness score.

=REPT("💗",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))&" sweet"

💗💗💗🤍🤍 sweet

Bunny ear mood picker

Put mood 1-5 in A1. Bunny faces hop from shy to joyful.

=CHOOSE(A1,"🐰","🐇","😊","🥰","🌸🐰🌸")

🥰

Pudding wobble timer

Put minutes left 0-10 in A1. Pudding dots wobble down to done.

=REPT("🍮",1)&REPT("●",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))&" wobble"

🍮●●●●○○○○○○ wobble

Kawaii flower crown counter

Put flowers earned 0-5 in A1. Cherry blossoms crown your progress.

=REPT("🌸",MIN(A1,B1))&REPT("🌿",MAX(0,B1-A1))&" bloom"

🌸🌸🌸🌿🌿 bloom

Macaron stack progress

Put macarons baked 0-5 in A1. Pastel treats stack toward your goal.

=REPT("🍪",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" macarons"

🍪🍪🍪⬜⬜ macarons

Kawaii cloud happiness bar

Put happiness 0-10 in A1. Fluffy clouds fill the pastel sky.

=REPT("☁️",MIN(A1,B1))&REPT("🌤️",MAX(0,B1-A1))&" fluffy"

☁️☁️☁️☁️🌤️🌤️🌤️🌤️🌤️🌤️ fluffy

Pastel pink progress bar

Put progress 0-10 in A1. Soft pink blocks fill the kawaii meter.

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

█████░░░░░ 🩷 50%

Kawaii bow rating stars

Put rating 0-5 in A1. Bows and stars show your cute score.

=REPT("🎀",MIN(A1,B1))&REPT("⭐",MAX(0,B1-A1))&" cute"

🎀🎀🎀⭐⭐ cute

Hello-style bow face status

Put vibe 1-3 in A1. Bow-face mood from quiet to party.

=CHOOSE(A1,"🎀😊","🎀😄","🎀🥳")

🎀😄

Soft plush mood faces

Put mood 1-5 in A1. Plush faces from sleepy to super happy.

=CHOOSE(A1,"😴","🥱","😊","😍","🧸✨")

😊

Kawaii sticker sheet counter

Put stickers placed 0-10 in A1. Sparkle stickers fill the sheet.

=REPT("✨",MIN(A1,B1))&REPT("⬜",MAX(0,B1-A1))&" stickers"

✨✨✨✨✨⬜⬜⬜⬜⬜ stickers

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
Ads keep the free stuff free. Members browse ad-free — log in or see pricing.
Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.