# Update specific rows with Excel node

**URL:** <https://community.n8n.io/t/update-specific-rows-with-excel-node/167221>\
**Category:** Questions\
**Tags:** microsoft-excel\
**Created:** [August 13, 2025, 3:37pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221 "2025-08-13T15:37:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![philipp\_wa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/philipp_wa/32/109612_2.png) [@philipp\_wa](https://community.n8n.io/u/philipp_wa)\
**Post date:** [August 13, 2025, 3:37pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/1 "2025-08-13T15:37:17Z")

</div>

Hi, I’m new to n8n and I’m trying to edit an existing Excel file using the “Microsoft Excel 365” node. Basically, I’d “just” like to replace rows 10–20 in a specific sheet. Unfortunately, the combinations/functions of “range, data mode, column to match on, value of column to match on, …” aren’t entirely clear to me. Is there more documentation or some more complex examples?

---

<div class="post-metadata">

**Author:** ![moosa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/moosa/32/108437_2.png) [@moosa](https://community.n8n.io/u/moosa)\
**Post date:** [August 13, 2025, 7:13pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/2 "2025-08-13T19:13:00Z")

</div>

you can use `Append or update` node then specify range you want to update.

---

<div class="post-metadata">

**Author:** ![philipp\_wa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/philipp_wa/32/109612_2.png) [@philipp\_wa](https://community.n8n.io/u/philipp_wa)\
**Post date:** [August 13, 2025, 9:47pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/3 "2025-08-13T21:47:36Z")

</div>

Thank you for your reply — a few questions about that:

- In “Range” it says “First row must contain column names.” However, I want to update a range without column names. Is this really the range that will be edited?
- When I choose “Map Each Column Below” in “Data Mode,” it looks to me like I have to define a condition to identify the row to be updated. But I “simply” want to replace rows 5 to 10. So I want to specify row numbers.
- And under “Values to Send,” it looks to me like I can only update a single row, right? But I want to update multiple rows at once.

---

<div class="post-metadata">

**Author:** ![moosa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/moosa/32/108437_2.png) [@moosa](https://community.n8n.io/u/moosa)\
**Post date:** [August 13, 2025, 10:35pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/4 "2025-08-13T22:35:02Z")

</div>

yes it might need to match values.  
but you can use http node to change values, as n8n has built in authentication for http request you can use same oauth which you provided while connecting to excel365:

in this I have updated 2 columns

before:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/5/d/5d77f02100184344bc70cb43dd5c6dbecad760c1.png)

after:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/d/6/d68d63b55408fc293e29e0574451e04076f93836.png)

---

<div class="post-metadata">

**Author:** ![philipp\_wa](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/philipp_wa/32/109612_2.png) [@philipp\_wa](https://community.n8n.io/u/philipp_wa)\
**Post date:** [August 13, 2025, 11:09pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/5 "2025-08-13T23:09:53Z")

</div>

Thanks. I’ll use the Graph API!

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [August 20, 2025, 11:10pm UTC](https://community.n8n.io/t/update-specific-rows-with-excel-node/167221/6 "2025-08-20T23:10:28Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
