AGENT SKILL

local-mcp-pdf-to-sheet

Use when the user wants to pull data out of one or more PDFs (invoices, bank/credit-card statements, receipts, reports, tables) and put it into a spreadsheet. pdf_read is one of the most-used tools; this codifies the read-PDF → structure → write-Excel workflow. Powered by LMCP on macOS and Windows.

License 许可
Apache-2.0
最近更新
2026-11-14
Stars
★ 1.6k
Forks
491

01 前言 Front Matter

name
local-mcp-pdf-to-sheet
description
Use when the user wants to pull data out of one or more PDFs (invoices, bank/credit-card statements, receipts, reports, tables) and put it into a spreadsheet. pdf_read is one of the most-used tools; this codifies the read-PDF → structure → write-Excel workflow. Powered by LMCP on macOS and Windows.

03 SKILL.md 正文

PDF → spreadsheet

Reading PDFs and turning them into structured data is one of the highest-volume things LMCP users do. This skill codifies the end-to-end flow: read the PDF(s) on the user's computer (macOS or Windows), extract the rows, and build an Excel sheet. The tools execute on the device; the extracted text goes to the user's AI provider as part of the conversation.

The flow

  1. Read the PDF(s) — pdf_read(path=...), one call per file. (Find the files first with file_search, or finder_search on macOS, if the user only describes them, e.g. "my March invoices".)
  2. Extract the structured rows from the text — identify the columns the user wants (e.g. for statements: Date, Description, Amount; for invoices: Vendor, Invoice #, Date, Total). Normalize dates and numbers. If several PDFs, combine into one consistent table.
  3. Write the spreadsheet — prefer one call: excel_create(path="<out>.xlsx", headers=["Date","Description","Amount"], rows=[[...],[...]], confirm=true). headers is required; rows is the full data. For edits to an existing sheet use excel_write_cell(path, cell="B2", value, confirm=true); to read one back use excel_read(path).

Good practice

  • Confirm the columns with the user before building the sheet ("I'll pull Date, Description, Amount — want a Category column too?").
  • Build the whole table in memory, then write it in a single excel_create (one row per record) — don't write cell-by-cell unless editing an existing file.
  • Watch totals: if the PDF has a stated total, add a check row or verify your sum matches.
  • Keep money as numbers (not "$1,234.50" strings) so the sheet can compute.
  • Write the output next to the source or to a path the user names; excel_create/excel_write_cell are preview/confirm-gated (set confirm: true once the user approves the columns).
  • Multi-PDF: keep a Source column so each row traces back to its file.

04 同仓库更多 Skills

hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-review-with-annotations

Create, inspect, reply to, update, or resolve situated Worktable annotations. Use when feedback belongs to a Doc section, block, text range, or HTML Doc, or when the user asks to address existing review feedback and coordinate a requested artifact edit.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-find-and-synthesize-context

Find, assess, and synthesize context from Worktable Docs and Records. Use when the user asks what a workspace contains, wants workspace-backed research, needs current facts reconciled across artifacts, or requests a cited synthesis without changing workspace state.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-update-docs

Create, edit, rename, or maintain narrative Worktable Docs. Use for plans, decisions, briefs, notes, research syntheses, and other durable prose when the user requests a new artifact or a safe update to an existing one.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-manage-records

Organize repeated structured information as durable Worktable Records. Use for research datasets, inventories, directories, pipelines, trackers, and other collections whose items need identity, fields, filtering, links, validation, or individual updates.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-manage-interactive-html

Create or improve durable visual and interactive artifacts in Worktable. Use for dashboards, trackers, calculators, mini apps, slide presentations, and other requests that benefit from a polished HTML Doc.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-collaborate-threads

Read, answer, and hand off messages through durable Worktable threads with users or other authenticated participants. Use when the user asks to check addressed messages, reply to a participant, continue a thread, request another agent's help, wait briefly for a response, or watch for comments and messages sent to the agent.

★ 1.6k