Read spreadsheet
Module · Stable
Read rows from an .xlsx, .xlsm, or .csv file into structured records.
Reads a spreadsheet binary (Excel .xlsx/.xlsm or .csv) into a list of row dicts keyed by the header row — e.g. rows[0].item_code, rows[0].base_price. Excel cells keep their native type (numbers stay numeric so prices compare cleanly; dates become ISO strings); CSV values come back as trimmed strings. Pick the worksheet with ‘sheet’ and the header position with ‘header_row’. The output ‘rows’ list feeds straight into a Foreach loop or an Ask AI compare step.
When to use
Section titled “When to use”Use when a spreadsheet arrives from an upstream step — an email attachment, an uploaded file, or a prior step’s output — and you need its rows as structured data: a master price list, a product catalogue, a CSV export, an inventory sheet. This is the reader that turns an Excel/CSV “source of truth” into rows you can match, diff, or loop over downstream.
When not to use
Section titled “When not to use”For a scanned document or photo (JPEG/PNG) use OCR; for a native PDF with selectable text use Extract Proposal Field. This node reads spreadsheet binaries only — it does not parse PDFs or images. To fetch a remote file over HTTP first, use Fetch URL and pass the saved local path here.
Inputs
Section titled “Inputs”Configured per use: file_path, sheet, header_row, max_rows.
Outputs
Section titled “Outputs”Auto-generated from the skill registry (load_skills()). Do not edit by hand.