Accounts → Spreadsheet (CSV)

🤖 AI Drafted (Not reviewed)

Use this when: a page (or each page of a document) holds historical accounts — cuentas, tithe books, tribute rolls, expense lists — and you want spreadsheet rows out. Reads amounts as a paleographer (roman numerals, the U thousands mark, maravedís/pesos/reales), keeps the original text, and normalizes amounts to numbers where certain. One CSV artifact per page; open or export from the artifact.

Folder	/Extract
Steps	2
Tags	preset, extract, table, accounts, csv, paleography

Steps, in run order

1. Files

Tool: Files — Pass through input files from workflow context

2. Accounts → CSV

Tool: Table — Extract tables from images

Settings this step uses:

Option	Value
include_headers	yes
output_style	csv
prompt	Extract the account entries on this page into CSV. This is a HISTORICAL page of accounts (cuentas). Read it as a paleographer: - One CSV row per account entry, in page order. Columns: entry_text, date, concept, amount_original, amount_normalized, unit, running_total, notes. - entry_text: the entry as written, original spelling preserved (expand abbreviations with [brackets] only). - amount_original: exactly as written — roman numerals, the U/cuento thousands mark (e.g. iiiUdcccxx), or spelled-out amounts. - amount_normalized: the same amount as a plain arabic number; leave empty if the reading is uncertain rather than guessing. - unit: maravedís, pesos, reales, ducados, tomines… as the page gives it. - running_total/notes: totals (“suma”, “monta”), carried amounts, marginal checks; note [UNCERTAIN] readings here. - First line = the header row. Quote any field containing a comma. Output ONLY the CSV.
thinking_mode	long

What this step asks the model:

Extract the table data from this image as CSV format.

The first row contains column headers.

Rules:
- Use comma as separator
- Wrap EVERY field in double quotes, without exception. A ledger column full
  of dates and comma'd lists produces ragged rows the moment quoting is
  optional, and the model is the only place that can get it right — nothing
  downstream can recover the column boundaries afterwards.
- Escape a literal double quote inside a field by doubling it ("")
- Every row must have exactly the same number of fields as the header row;
  emit "" for an empty cell rather than dropping it
- First row is the header row if one is visible
- One row per line

Return ONLY the CSV content, no code fences or explanations.

If the image contains no table, output exactly NO TABLE and nothing
else. That is a correct and complete answer — never invent rows to fill the
reply.

A table is data laid out in rows and columns as part of the DOCUMENT. It is not
a measuring ruler or scale bar laid beside the page, a colour calibration
chart, a strip of page or folio numbers, a margin, or any other photographic
furniture that belongs to the act of scanning rather than to the document.