Sample output · 1 of 2
A table in the text layer of a PDF becomes a workbook somebody can work on: the cells are the cells that were there, the quantities are stored as quantities, a header spread over two rows is flattened into one row of titles, and a picture of the source sits next to the sheet.
The first task in a new project also sets up its computer (about 3 min).
Turn a table in a file or photo into Excel
Try this prompt
Use the Table to Excel skill on the price list in the PDF I give you: take the table on the first page, store the prices as numbers so I can total them, and give me the workbook and a picture of the table beside it.
Two files for one table: table.xlsx, a single sheet with a row of column titles, the rows that were found and the quantities stored as quantities, and check.png, a 1240x1754 picture of the table as it was found beside the table that was written. Plus a page image of the sheet and a QA report.
| Field | Required | Hint |
|---|---|---|
| kind | Yes | pdf: a PDF is read by the script (a picture of a table is not taken) |
| path | Yes | The file, at most 200 characters, named inside the input folder; never absolute, never climbing out |
| bytes | Yes | The size of that file in bytes, a whole number; the build refuses a file of another size |
| pages | No | The pages to read, like 1-3 or 2,4-6, at most 50 of them |
| tableIndex | No | Which table of the document to take, counting from 1; the first one is the default |
| headerRows | No | How many rows the header takes: 1 (the default) or 2 |
| table | No | For a picture: the titles of the columns and the rows that were read, every row as wide as the titles |
| sheetName | No | The name of the sheet, at most 31 characters; the default is Table 1 |
| numberFormat | No | The format a quantity column carries: number (the default) or currency |
| numberColumns | No | The titles of the columns that are quantities even when nothing in them says so |
You say
Use the Table to Excel skill on the price list in the PDF I give you: take the table on the first page, store the prices as numbers so I can total them, and give me the workbook and a picture of the table beside it.
None
Node 20+; Python with openpyxl and pdfplumber; Chromium (playwright-core) to draw the pictures; the build never touches the network
None
kind (pdf: a PDF is read by the script (a picture of a table is not taken)), path (The file, at most 200 characters, named inside the input folder; never absolute, never climbing out), bytes (The size of that file in bytes, a whole number; the build refuses a file of another size)
onlypro, claude-code, codex, cursor