n8n-nodes-microsoft-excel-sharepoint

An n8n community node that extends Microsoft Excel support to include files stored in SharePoint, in addition to OneDrive.

The built-in n8n Microsoft Excel node only surfaces OneDrive files in its workbook selector. This node solves that by letting you choose between OneDrive and SharePoint as the file source, with cascading dropdowns to navigate Site → Document Library → Workbook.

Features

• OneDrive + SharePoint support — toggle between sources in a single node
• Cascading SharePoint selectors — Site → Document Library → Workbook dropdowns populate dynamically based on your selections
• 7 operations — Append Row, Update Row, Read Rows, Lookup, Clear Range, Clear Table, Delete Row
• Named table support — all row operations work against Excel named tables
• Automatic Column Mapping — dynamic schema detection allows you to automap fields or manually map columns dynamically
• Pagination handled automatically — large tables are fetched across multiple pages

Operations

| Operation | Description | |---|---| | Append Row | Add a new row to a named table (uses dynamic column mapping) | | Update Row | Update all rows where a column matches a value (uses dynamic column mapping) | | Read Rows | Read rows from a table or a worksheet range | | Lookup | Return rows where a column matches a value | | Clear Range | Clear cell contents (text only) from an A1-notation range | | Clear Table | Delete all data rows from a table (wipes the table cleanly, resetting it to 0 data rows) | | Delete Row | Delete rows where a column matches a value |

Prerequisites

Azure App Registration

You need a Microsoft Azure app registration with the following delegated API permissions:

| Permission | Reason | |---|---| | Files.ReadWrite.All | Read and write Excel files in OneDrive and SharePoint | | Sites.Read.All | List SharePoint sites and document libraries | | offline_access | Allow token refresh without re-authentication |

The redirect URI for your app registration should be set to your n8n OAuth callback URL:

https://<your-n8n-domain>/rest/oauth2-credential/callback

Installation

In n8n (self-hosted or cloud)

1. Go to Settings → Community Nodes
2. Click Install
3. Enter n8n-nodes-microsoft-excel-sharepoint
4. Click Install

Restart n8n if prompted.

Setup

1. Create a Credential

1. In n8n, go to Credentials → New Credential
2. Search for Microsoft Excel SharePoint OAuth2
3. Enter your Azure app's Client ID and Client Secret
4. Click Connect to complete the OAuth2 flow — you'll be redirected to Microsoft to sign in

2. Add the Node to a Workflow

Search for Microsoft Excel (SharePoint) in the node picker.

3. Configure the Node

For SharePoint files:

1. Set Workbook Source to SharePoint
2. Select your SharePoint Site from the dropdown
3. Select the Document Library within that site
4. Select the Workbook (.xlsx file)
5. Select the Worksheet and Table

For OneDrive files:

1. Set Workbook Source to OneDrive
2. Select the Workbook from your OneDrive
3. Select the Worksheet and Table

Example: Append a Row to a SharePoint Excel Table

Node configuration:

• Operation: Append Row
• Workbook Source: SharePoint
• Site: My Team Site
• Document Library: Documents
• Workbook: Tracker.xlsx
• Worksheet: Sheet1
• Table: DataTable
• Columns to Map (Mapping Mode: Map Each Field Below):
  • Name → {{ $json.name }}
  • Status → Active
  • Date → {{ $now.toISODate() }}

Compatibility

• n8n >=1.0.0
• Microsoft Graph API v1.0
• Requires Microsoft 365 account with access to the target SharePoint site

License

MIT