Microsoft SharePoint ExcelInstall

Summary

Retrieves rows from a named Excel table in a SharePoint-hosted workbook through the Microsoft Graph workbook API. Returns one item per row as keyed objects, or a single item with arrays when raw mode is on.

Inputs

• Site (required) — SharePoint site, chosen from a searchable list or entered by ID (e.g. contoso.sharepoint.com,site-guid,web-guid).
• Drive (required) — Document library/drive containing the file, chosen from a list or entered by ID.
• File (required) — The .xlsx file, chosen from a list or entered by ID. The list only shows .xlsx files in the drive's root folder; use By ID for files in subfolders.
• Table (required) — Name of the Excel table, chosen from a list or entered by name.
• Return All — Defaults to true. When false, a Limit applies.
• Limit — Max rows to return (default 50, min 1). Shown only when Return All is off. The limit is applied after all rows are fetched, and before empty rows are dropped.
• Options > RAW Data — Return arrays of values instead of keyed objects.
• Options > Data Property — Property name that holds the rows array in raw mode (default 'data').
• Options > Fields — Comma-separated column names to include (e.g. Name, Email, Status). Empty returns all columns. Names are matched exactly, with whitespace trimmed.

Output shape

Default: one item per table row, with column headers as keys and cell values as values (missing values are null). With RAW Data: a single item containing headers (the output column names) and an array of row arrays under the Data Property name.

Rows where every selected column is empty are skipped. If nothing remains, a single item {message: 'No rows found in table'} is returned. The rows endpoint is requested once with no pagination handling, so very large tables may be truncated by Graph's default page size. Errors (such as a locked file or Graph failures) throw, or are returned as {error} when Continue On Fail is on. The node reads only the first input item's parameters and runs once, regardless of input item count.

Examples

Example 1: Pull all rows of a 'Customers' table into the workflow

Select Site, Drive, File and Table 'Customers'; leave Return All on and Options empty.

Example 2: Fetch only a few columns of the first 10 rows

Return All off, Limit 10, Options > Fields = 'Name, Email'.

Example 3: Get table data as a compact array for a Code node

Options > RAW Data on, Data Property 'rows'; output has headers and rows.

Links

• n8n community nodes installation guide