Excel + PDFs

A live API over your Excel workbook and the documents beside it.

Connect a workbook from OneDrive or SharePoint. Each worksheet becomes a table that stays in sync with the file. Add the invoices or contracts that go with it, link them by a key column, and query everything over REST, GraphQL, or MCP.

How it works

1

Connect Microsoft 365

Sign in with Microsoft (OAuth) and pick an Excel file from OneDrive or SharePoint. Every worksheet is imported as its own table.
2

Stay in sync

DocQuery subscribes to Microsoft Graph change notifications and re-pulls the workbook when it changes. Edits made in DocQuery are written back to the sheet.
3

Add the documents

Upload the PDFs, Word, or PowerPoint files that belong to those rows. AI extraction turns them into tables.
4

Link and query

Define a relation such as invoices.customer_id → customers.id and fetch rows with their related records embedded.

What a call looks like

Rows from a worksheet, filtered on a column, with linked rows embedded via include=.

curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://docquery.io/api/v1/tables/invoices/rows?status=unpaid&include=customer_id"

Try a real call now, no signup. This uses the public read-only demo key (example customers and invoices):

curl -H "Authorization: Bearer dq_demo_readonly" \
  "https://docquery.io/api/v1/tables/example_invoices/rows?status=due&include=customer_id"

Point Claude or Cursor at the same data with the hosted MCP server. Using Airtable instead? See Airtable + PDFs.

When this is the right tool

  • Your team keeps working in Excel, and an app or AI agent needs to read it.
  • The sheet is only half the story: the numbers you need are in documents tied to its rows.
  • If you only need a JSON endpoint over a single plain spreadsheet, a simpler sheet-to-API tool may be enough.

Free plan: 5 documents and 10,000 rows, no card.