Google Sheets Kawaii Formulas

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,"😿","🥺","😊","🤩","✨🤩✨")

🤩

CHOOSE

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

REPT MIN MAX

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

REPT MIN MAX

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

REPT MIN

Pink bow mood picker

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

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

💖

CHOOSE

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

REPT MIN MAX

Sparkle explosion counter

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

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

✨✨✨ kawaii!

IF REPT MIN

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

REPT MIN MAX

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

CHOOSE

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

REPT MIN MAX

Bunny ear mood picker

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

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

🥰

CHOOSE

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

REPT MIN MAX

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

REPT MIN MAX

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

REPT MIN MAX

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

REPT MIN MAX

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%

REPT MIN MAX ROUND

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

REPT MIN MAX

Hello-style bow face status

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

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

🎀😄

CHOOSE

Soft plush mood faces

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

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

😊

CHOOSE

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

REPT 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.

See membership options