# Bring observations into a spreadsheet

> Export a bounded snapshot with labelled prices. Share exported rows rather than a secret key. Empty cells for unavailable prices must stay empty; do not co Underdog API (https://underdogapi.com) is an independent Underdog Fantasy pick'em data API: Higher/Lower lines with separate payout multipliers per side, line history, changes and graded results as JSON, CSV, MCP and streams.

Canonical page: https://underdogapi.com/underdog-spreadsheet

## Free offer

**Free API key, no card: 100 credits a month** on the live board, every league, separate Higher/Lower prices, and the last 24 hours of line history. Sign up: https://underdogapi.com/sign-up?ref=ai-claudebot

## Quickstart

1. Get a free key at https://underdogapi.com/sign-up?ref=ai-claudebot (no card), or let your agent request one: `POST https://underdogapi.com/api/v1/agent/signup` with `data_wanted` and `use_case`, then show your user the returned approval_url.
2. Export it: `export UNDERDOG_API_KEY=ud_...`
3. First call with curl:

```bash
curl --fail-with-body 'https://underdogapi.com/api/v1/projections?league=NBA&view=compact&limit=5' \
  -H "Authorization: Bearer $UNDERDOG_API_KEY" \
  -H 'X-User-Request: NBA dashboard integration check'
```

4. Same call in Python:

```python
import os, requests

r = requests.get(
    "https://underdogapi.com/api/v1/projections",
    params={"league": "NBA", "view": "compact", "limit": 5},
    headers={"Authorization": f"Bearer {os.environ['UNDERDOG_API_KEY']}"},
)
r.raise_for_status()
for line in r.json()["data"]:
    print(line["player"]["name"], line["market"]["stat"], line["line"])
```

## Use it from Claude (MCP)

Claude Code, one command:

```bash
claude mcp add --transport http underdog https://underdogapi.com/api/mcp --header "Authorization: Bearer $UNDERDOG_API_KEY"
```

Or add this server to your Claude MCP configuration (the key stays in the environment):

```json
{
  "mcpServers": {
    "underdog": {
      "type": "http",
      "url": "https://underdogapi.com/api/mcp",
      "headers": {
        "Authorization": "Bearer ${UNDERDOG_API_KEY}"
      }
    }
  }
}
```

Guide: https://underdogapi.com/use-with-claude

## Pricing

| Plan | Price | Credits / month | Notes |
| --- | --- | --- | --- |
| Free | $0 | 100 | No card. Live feed 5 minutes behind; last 24 hours of line history |
| Developer | $49/month | 10,000 | For models that need full training pages and loaded game-log seasons. Live feed, no added plan delay |
| Production | $149/month | 50,000 | For apps with real users and push delivery. Everything in Developer, signed webhooks for every change |
| Scale | $499/month | 250,000 | For apps whose traffic has outgrown Production. Everything in Production, 15 live-feed connections at once |

Full pricing: https://underdogapi.com/pricing

## On this page

For developers who need to bring observations into a spreadsheet.

Export a bounded snapshot with labelled prices.

[Get free API key](https://underdogapi.com/sign-up) [API reference](https://underdogapi.com/docs)

## Not for

Entry placement or fantasy-account support

This independent data service does not operate a fantasy account.

Guaranteed outcomes

Observations support research; they do not predict a winning entry.

## What a refresh costs today

Live

| League | Current rows | Requests per refresh |
| --- | --- | --- |
| NFL | 1,619 | 9 |
| NBA | 1,007 | 6 |
| NHL | 837 | 5 |
| TENNIS | 526 | 3 |
| CBB | 208 | 2 |
| DOTA | 36 | 1 |
| CS | 18 | 1 |
| CFL | 16 | 1 |

At 200 rows per request. The Free plan includes 100 credits a month. Board observed Nov 15, 19:43 UTC.

## Start with the data contract

Share exported rows rather than a secret key. Empty cells for unavailable prices must stay empty; do not convert them to zero.

## Share rows, not credentials

Import a saved export as text/CSV and keep a metadata sheet with the source status and timestamp. Never embed a bearer key in a shared workbook or public formula.

## Run a bounded integration example

Keep the bearer token in a server environment. Snippets that refer to an existing page, rows or url are processing examples to apply after a successful response; replace any market or cutoff placeholder deliberately.

```
# Keep exported identifiers as text and missing side prices as empty cells.
curl --fail-with-body --dump-header response-headers.txt \
  "https://underdogapi.com/api/v1/export?sport=NBA&format=csv&limit=50" \
  -H "Authorization: Bearer $UNDERDOG_API_KEY" -o underdog-board.csv
# Read X-Next-Cursor in response-headers.txt before calling this a complete export.
```

## Verify the response and its limits

- Test invalid credentials and unavailable source data.
- Keep cursors, source status and timestamps with retained rows.
- Use coverage to confirm the requested sport and retained date window.

## Continue with the reference

Use the documented export contract for exact parameters and null meanings. A fictional demo validates a parser; it does not validate live collection or historical completeness.

## Try it

[**Run a bounded demo** Inspect fictional rows without a key.](https://underdogapi.com/playground) [**Download the starter kit** Guarded clients, samples and Postman requests.](https://underdogapi.com/developers/starter-kit)

Endpoint docs: [GET /api/v1/export](https://underdogapi.com/docs#export) [Plans and limits](https://underdogapi.com/pricing)

## Frequently asked questions

What is the main data constraint when I bring observations into a spreadsheet?

Share exported rows rather than a secret key. Empty cells for unavailable prices must stay empty; do not convert them to zero.

Should an empty multiplier cell become zero in a spreadsheet?

No. Empty means unavailable or not observed. Zero would be a numeric price and would corrupt averages, price classification and payout calculations.

## Continue building

[Guide **API reference**](https://underdogapi.com/docs) [data **Use NBA player-prop observations**](https://underdogapi.com/nba-player-props-api) [data **Use NFL player-prop observations**](https://underdogapi.com/nfl-player-props-api)

[All developer resources](https://underdogapi.com/resources) [Pricing](https://underdogapi.com/pricing)

## References

- [Underdog API reference](https://underdogapi.com/docs)
- [OpenAPI contract](https://underdogapi.com/openapi.json)

On this page

[Not for](https://underdogapi.com/underdog-spreadsheet#not-for) [Start with the data contract](https://underdogapi.com/underdog-spreadsheet#start-with-the-data-contract-0) [Share rows, not credentials](https://underdogapi.com/underdog-spreadsheet#share-rows-not-credentials-2) [Run a bounded integration example](https://underdogapi.com/underdog-spreadsheet#run-a-bounded-integration-example-4) [Verify the response and its limits](https://underdogapi.com/underdog-spreadsheet#verify-the-response-and-its-limits-7) [Continue with the reference](https://underdogapi.com/underdog-spreadsheet#continue-with-the-reference-9) [FAQ](https://underdogapi.com/underdog-spreadsheet#faq)

[Playground](https://underdogapi.com/playground) [Plans and limits](https://underdogapi.com/pricing)

## FAQ

### Is there a free Underdog API?

Yes. The Free plan is a real API key on the live board, not a sample: 100 credits a month, every league, separate Higher/Lower prices and the last 24 hours of line history. No card is needed.

### Is this the official Underdog Fantasy API?

No. Underdog API is an independent data service. It is not affiliated with, endorsed by or sponsored by Underdog Fantasy or Underdog Sports.

### What data does it return?

Underdog Higher/Lower lines with separate payout multipliers and availability for each side, stable market ids through line moves, alternate rungs, recorded line history, changes, graded results and coverage/status endpoints.

### How do I use it from Claude or another AI agent?

Connect the MCP server at https://underdogapi.com/api/mcp with a bearer key, or call the REST API. Agents can request a key for their user with POST /api/v1/agent/signup.

### How much does it cost after the free tier?

Developer is $49/month for 10,000 credits, Production $149/month for 50,000, Scale $499/month for 250,000. Errors and unchanged 304 responses cost zero credits.

### How fresh is the data?

Each row carries its observation time. Check /api/v1/status and /api/v1/coverage before relying on a sport or window; missing collection is reported as unavailable, never filled in.

### Does it place entries or give picks?

No. It is data only: no entries, account operations, guaranteed outcomes or betting advice.

---
Independent data service, not affiliated with Underdog Fantasy or Underdog Sports. Docs: https://underdogapi.com/docs · OpenAPI: https://underdogapi.com/openapi.json · llms.txt: https://underdogapi.com/llms.txt
