LLM API Cost Calculator cover

Know your AI bill before you get it.

Type in how big your prompts are, how long the replies are, and how many requests you make a day. The spreadsheet tells you what that costs per request, per month and per year, on the model you use and on 25 others.

Not a SaaS dashboard. Not a subscription. One spreadsheet that works in Google Sheets and Excel.

WHAT WILL THIS COST ME?

Six yellow cells: model, input tokens, output tokens, requests per day, cache hit rate, days per month. Out comes:

  • Cost per request, per day, per month, per year
  • Breakdown: uncached input, cached input, output, and how much caching saves you
  • Cost per 1,000 requests, and tokens per month
  • A word-to-token estimator: paste text, see the token count and what it costs to send

SAME WORKLOAD, EVERY MODEL

The Compare tab prices your exact workload on all 26 models and ranks them cheapest to dearest, with a "vs cheapest" multiplier and a bar chart. Your model is highlighted blue, the cheapest green.

USAGE LOG AND BUDGET

Set a monthly budget. Log what you use (date, model, tokens in, tokens out) and the cost fills in. See spent this month, budget left, projected month-end at your current pace, and spend by model.

26 models, all editable

Anthropic (Fable 5.1, Opus 5, Sonnet 5, Haiku 4.5 and more), OpenAI (GPT-5, GPT-5 mini and nano, GPT-4.1, GPT-4o, o3, o4-mini), Google Gemini 2.5, DeepSeek, xAI Grok, Mistral, Llama. Every price is a yellow cell. When a provider changes prices, change the cell and every tab updates. Add your own models on the empty rows.

What you get

  • The calculator (.xlsx, opens in Google Sheets or Excel) with 4 tabs: Calculator, Compare, Usage Log, Pricing
  • Room for 1,000 log rows
  • A 2-page quick-start guide

Who it's for

Developers, founders and product people shipping anything on an LLM API, and anyone who has been surprised by an invoice.

Good to know

  • Prices are list prices per 1 million tokens as of September 2026. Check them against your provider before you bet the company; that is why they are editable.
  • No macros, add-ons or sign-ups. Works in Google Sheets (free) and Excel 2016 or newer.
  • Instant download.

Need a custom app built for your business? I build native iOS apps and web tools from prototype to launch. Services and pricing · LinkedIn

AI tools

LLM API Cost Calculator

26 Models, Google Sheets + Excel

Tokens in, tokens out, requests a day. Your AI bill per request, per month and per year, across 26 models.

Pay with card, Apple Pay and more. Download right after.

One-time price in US dollars, checkout by Stripe. After paying you land on a page with your download link. Each link works for 15 minutes, and reopening that page makes fresh ones.

  • LLM-API-Cost-Calculator.zip