Microsoft Excel 365Install

Summary

Finds rows in a selected Excel worksheet by a match column and value, then updates them with supplied data; if no row matches, it appends a row. Choose whether to map incoming item fields automatically or set destination columns explicitly.

Inputs

• Workbook (required) — Select a workbook from the list or enter its ID.
• Sheet (required) — Select a worksheet from the list or enter its ID.
• Select a Range — Enable to limit the operation to a specific worksheet range.
• Range — A specific A1-style range such as A1:B5; leave blank to use the used range. The first row must contain column names.
• Data Mode — Choose Auto-Map Input Data to Columns to match incoming item fields to destination column names, or Map Each Column Below to provide column and value pairs.
• Column to match on (required) — Worksheet column used to find rows to update. Its value is not changed by the operation.
• Value of Column to Match On (required) — Value used to find the row or rows to update.
• Values to Send — In Map Each Column Below mode, specify destination columns and their values.
• Append After Selected Range — When using a selected range, append new rows after that range instead of after the used range.
• RAW Data — Return worksheet data as raw values instead of parsing it into fields based on the header row.
• Data Property — Property name for raw worksheet data; shown when RAW Data is enabled.
• Update All Matches — Update every matching row; when disabled, update only the first match.

Output shape

A list of n8n items representing worksheet rows.

Rows are returned as parsed fields based on the header row by default. With RAW Data enabled, the raw values are placed in the configured Data Property. When no match is found, the operation appends data; the exact returned row shape depends on the selected data mode.

Links

• n8n community nodes installation guide