Microsoft Excel 365Install

Summary

Reads rows from a selected Excel workbook sheet, optionally limiting the read to a specified A1-style range. By default, it maps rows into objects using the header row; RAW Data returns the response as raw values instead.

Inputs

• Workbook (required) — Choose a workbook from the list or enter its ID.
• Sheet (required) — Choose a sheet from the list or enter its ID.
• Select a Range — Enable to read a specific range; when disabled, the operation reads the entire sheet.
• Range — A specific A1-style range such as A1:B5. Leave blank to return the entire sheet.
• Header Row — Zero-based row index, relative to the selected range, containing column names. Default: 0.
• First Data Row — Zero-based row index, relative to the selected range, where data begins. Default: 1.
• Options — RAW Data returns values without mapping them to header keys. When enabled, Data Property names the output property for raw data (default: data), and Fields can specify comma-separated response fields.

Output shape

A list of items, one per returned row in parsed mode; raw mode returns the unparsed range data in the configured data property.

Parsed rows use the configured header row for object keys and start at the configured first data row. Range selection is optional; the declared range format requires a specific A1-style range.

Links

• n8n community nodes installation guide