Turn plain English into working Excel formulas with a small language model tuned just for spreadsheets.
The Granite Excel Formula Assistant is a fine-tuned small language model that translates natural language instructions into valid Excel formulas. It’s built on IBM’s Granite family and trained on tens of thousands of real instruction–formula pairs, then deployed as a lightweight, GPU-friendly model you can integrate into your own tools.
If you’ve ever stared at a blank cell wondering “Was it SUMIF or SUMIFS again?”, this model is built for you.
What this model does
The Granite Excel Formula Assistant focuses on one job and does it well:
Input: a short, natural language description of what you want in Excel
Output: a single-cell Excel formula that does it
Examples of the kinds of tasks it handles:
- Conditional totals:
“Sum values inB2:B20where region isNorthinA2:A20”
→=SUMIF(A2:A20,"North",B2:B20) - Counting with criteria:
“Count how many cells inA2:A100contain the textError”
→=COUNTIF(A2:A100,"Error") - Average with filters:
“Average sales inD2:D50where channel inC2:C50isOnline”
→=AVERAGEIF(C2:C50,"Online",D2:D50) - Lookups:
“Return the value fromC2:C100whereA2:A100matchesE2”
→=XLOOKUP(E2,A2:A100,C2:C100) - Logical checks:
“If value inB2is greater than 1000, showBonus, otherwise blank”
→=IF(B2>1000,"Bonus","")
It’s not a general chat model. It’s a focused SLM that specializes in Excel logic.
Try the live demo
🔗 Live demo on Hugging Face Spaces
https://huggingface.co/spaces/benkemp/granite-excel-formula-demo
Use the demo to:
- Type an instruction in plain English
- Get a suggested Excel formula
- Run a small built-in benchmark to see current accuracy
Please send comment of request for changed to support@nanolanguagemodels.com