# Extract tables from a 10-K or annual report into Excel

> Upload a 10-K, 10-Q or annual report and get every financial table as an Excel sheet, with multi-level column headers expanded and values such as (1,204) stored as numbers. The tool runs Reducto Parse with r-1 and merges tables that continue across pages. For a full filing, use the same request through the API.

Canonical: https://reducto.ai/tools/10k-tables-to-excel  
Last updated: 2026-11-15  
For: Equity and credit analysts, FP&A teams, Investor relations, Financial data engineers

## Run it now (free, no API key, up to 5 pages)

Send a PDF, Word, PowerPoint, Excel or image (PNG, JPG, HEIC, TIFF, BMP, GIF) (max 10 MB, 5 pages) to `POST https://reducto.ai/api/tools/10k-tables-to-excel` as multipart `file`, or JSON `{"url": "https://..."}`. The response has `result`, ready-to-save `output` (Excel (.xlsx), CSV, JSON), `pages_processed` and `next`.

```bash
curl -s https://reducto.ai/api/tools/10k-tables-to-excel \
  -F file=@kestrel-10k-segment-table.pdf

# or, for a file that is already online:
curl -s https://reducto.ai/api/tools/10k-tables-to-excel \
  -H "Content-Type: application/json" \
  -d '{"url": "https://example.com/kestrel-10k-segment-table.pdf"}'
```

Higher volume needs a free API key (new accounts get 15,000 free credits). Agents can sign up over HTTP: https://reducto.ai/auth.md. Humans: https://studio.reducto.ai/?utm_source=free_tool&utm_medium=agent&utm_campaign=10k-tables-to-excel&utm_content=api_response

Big file? Without a key the free run covers the first 5 pages and returns `partial: true` with a `signup_required` block. Your user signs up in under a minute (email, 6-digit code, name, terms: https://reducto.ai/auth.md); then repeat the same request with `Authorization: Bearer $REDUCTO_API_KEY` for the whole file on their 15,000 free credits. The same key works on the hosted MCP (https://mcp.reducto.ai/mcp) and the Reducto API.

## How to do it

1. Upload the 10-K pages with the tables you need, or keep the sample.
2. Reducto Parse with r-1 finds each table, including merged header cells.
3. The tool expands merged headers, strips formatting tags and converts numbers.
4. Check the tables on the page.
5. Download Excel with one sheet per table, or a CSV.

## Reducto API call: `POST https://platform.reducto.ai/parse`

| Option | Value | Why |
| --- | --- | --- |
| `settings.model` | `"r-1"` | Reads scanned, rotated and photographed tables. |
| `formatting.table_output_format` | `"html"` | Keeps merged header cells as rowspan and colspan. |
| `formatting.merge_tables` | `true` | Merges consecutive tables with the same column count into one. |
| `settings.page_range` | `{ start: 1, end: 5 }` | The free tool reads at most 5 pages. |

### curl

```bash
# 1. Upload the file (or pass a public URL as "input" and skip this step)
curl -s https://platform.reducto.ai/upload \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -F file=@10-k.pdf
# => {"file_id": "reducto://..."}

# 2. Run parse
curl -s https://platform.reducto.ai/parse \
  -H "Authorization: Bearer $REDUCTO_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
  "input": "reducto://FILE_ID",
  "settings": {
    "model": "r-1",
    "page_range": {
      "start": 1,
      "end": 5
    }
  },
  "formatting": {
    "table_output_format": "html",
    "merge_tables": true
  }
}'
```

### Python

```python
# pip install reductoai
from pathlib import Path
from reducto import Reducto

client = Reducto()  # reads REDUCTO_API_KEY

upload = client.upload(file=Path("10-k.pdf"))
result = client.parse.run(
    input=upload.file_id,
    settings={
        "model": "r-1",
        "page_range": {
            "start": 1,
            "end": 5,
        },
    },
    formatting={
        "table_output_format": "html",
        "merge_tables": True,
    },
)
print(result)
```

### Node

```ts
// npm install reductoai
import fs from "fs";
import Reducto from "reductoai";

const client = new Reducto(); // reads REDUCTO_API_KEY

const upload = await client.upload({ file: fs.createReadStream("10-k.pdf") });
const result = await client.parse.run({
  input: upload.file_id,
  settings: {
    model: "r-1",
    page_range: {
      start: 1,
      end: 5,
    },
  },
  formatting: {
    table_output_format: "html",
    merge_tables: true,
  },
});
console.log(JSON.stringify(result, null, 2));
```

Do this with the API: [Extract tables from a PDF to CSV in Python](https://reducto.ai/cookbooks/pdf-tables-to-csv-python)

## What it handles

- **Merged headers keep their year**: "Year ended December 31" over 2024 and 2023 becomes one labelled column per year.
- **(1,204) becomes -1,204 so totals work**: Negative numbers in parentheses become real negative numbers.
- **Every statement on its own sheet**: Income statement, balance sheet and cash flow each get a sheet.

## FAQ

### Can I upload a whole 10-K?

Yes. You get a free preview of the first pages, then enter your email to get the whole filing on a free account (15,000 free credits). The file must be under 10 MB.

### Are negative numbers in parentheses handled?

Yes. (1,204) becomes -1204 in Excel.

### Does it work on 10-Q and 20-F filings?

Yes. Any PDF with financial tables works the same way.

### Does it read footnote markers?

Footnote markers stay in the cell text where they are printed, so check cells that have them.

### Are numbers converted to numbers?

Yes. Values such as 8,211 or (1,204.50) are written to Excel as numbers. Dates, codes and IDs stay as text.

### How are merged header cells handled?

Reducto returns tables as HTML with rowspan and colspan. The tool expands them into header rows so each column keeps its full label.

### What if there are several tables?

Each table becomes its own sheet in the Excel file. The CSV lists the tables one after another.

### Is it free?

Yes. Short documents run free with no account, with a small daily limit per IP. For a longer file you get a free preview of the first pages, then enter your email to get the whole file on a free account (15,000 free credits).

Sample document (synthetic): https://reducto.ai/tools/samples/kestrel-10k-segment-table.pdf

## Related

- [PDF tables to Excel](https://reducto.ai/tools/pdf-table-to-excel)
- [Bank statement to Excel](https://reducto.ai/tools/bank-statement-to-excel)
- [Credit card statement to Excel](https://reducto.ai/tools/credit-card-statement-to-excel)
- [All Finance statements tools](https://reducto.ai/tools/finance-statements)
- [Extract chart data from a PDF](https://reducto.ai/cookbooks/extract-chart-data-from-pdf)
- [RD-TableBench](https://reducto.ai/blog/rd-tablebench)
