Better Sheets All add-ons

Better Formulas

A free Google Sheets™ add-on

Built by Better Sheets · Free on the Google Workspace Marketplace · No account needed

What Better Formulas does

Better Formulas adds custom formulas to Google Sheets™. TITLECASE() is a better PROPER(), and CHECKEMAIL() checks an email address.

  • ✅ TITLECASE(): PROPER() turns "don't stop" into "Don'T Stop". TITLECASE() gives you "Don't Stop", with no capital letter after an apostrophe.
  • ✅ CHECKEMAIL(): checks the structure of an email address and its ending, and gives you TRUE or FALSE.
  • ✅ OPENAI(): connect your sheet to the OpenAI API with a single formula, using your own API key.
  • ✅ To use them, type =TITLECASE(A1) or =CHECKEMAIL(A1) in any cell.
TITLECASE() compared with PROPER() on the text "don't stop"

How Better Formulas uses your Google data

  • Adds the CHECKEMAIL(), TITLECASE() and OPENAI() custom functions to your spreadsheet.
  • CHECKEMAIL() and TITLECASE() work only on the values you pass them, inside Google Sheets™.
  • OPENAI() runs only when you use it: it sends the prompt in that formula to OpenAI with your own OpenAI API key and writes the answer back.
  • Asks for your Google account email and basic profile to identify your account. Better Sheets does not share them.

Google permissions it asks for

See and change the spreadsheet it is installed in https://www.googleapis.com/auth/spreadsheets.currentonly
See your Google account email address https://www.googleapis.com/auth/userinfo.email
See your basic profile info (name and picture) https://www.googleapis.com/auth/userinfo.profile
Show its menu and sidebar inside Google Sheets™ https://www.googleapis.com/auth/script.container.ui

Full details: Better Formulas Privacy Policy · Terms of Service

Google Sheets™ is a trademark of Google LLC.