Microsoft Excel 365Install

Summary

Update values in a worksheet range or update rows by matching an existing column. Choose the workbook and sheet, then provide data as raw arrays, mapped input fields, or explicitly defined column values.

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 this to target a specific range using A1 notation. Leave the range blank to use the worksheet’s used range.
• Range — Optional A1-style range, such as A1:B2. Generic ranges such as A:B are not supported. In raw mode, the supplied array dimensions must match the target range.
• Data Mode — Choose Auto-Map Input Data to Columns to use incoming item fields matching column names, Map Each Column Below to set values for selected columns, or Raw to send a JSON array of row arrays for the selected range.
• Data — In Raw mode, provide JSON array-of-arrays values, with one array per row and dimensions matching the selected range.
• Column to match on — For mapped updates, select the worksheet column used to find rows to update; this column is not changed.
• Value of Column to Match On — Value to find in the selected match column.
• Values to Send — For Map Each Column Below, choose destination columns and the values to write.
• Options — Can return raw response data under a configurable property, select response fields when returning raw data, and update all matching rows instead of only the first match. Update All Matches is available outside Raw mode.

Output shape

Updated worksheet data returned as n8n items.

The response can be parsed into fields or returned raw using the RAW Data option. When updating by a match column, Update All Matches controls whether all matching rows or only the first match are updated.

Links

• n8n community nodes installation guide