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
- Read the PDF(s) —
pdf_read(path=...), one call per file. (Find the files first withfile_search, orfinder_searchon macOS, if the user only describes them, e.g. "my March invoices".) - 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.
- Write the spreadsheet — prefer one call:
excel_create(path="<out>.xlsx", headers=["Date","Description","Amount"], rows=[[...],[...]], confirm=true).headersis required;rowsis the full data. For edits to an existing sheet useexcel_write_cell(path, cell="B2", value, confirm=true); to read one back useexcel_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_cellare preview/confirm-gated (setconfirm: trueonce the user approves the columns). - Multi-PDF: keep a
Sourcecolumn so each row traces back to its file.
04 同仓库更多 Skills
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.
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.
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.
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.
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.
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.