MS OneDrive BusinessInstall

Summary

Read rows from an Excel worksheet, returning each row as an object with column headers as keys.

Inputs

• driveType — Type of drive to access: User Drive, SharePoint Site Drive, or Shared Folder Link.
• userId — User email or ID for User Drive; leave empty to use the authenticated user.
• siteId — SharePoint site to access when driveType is Site.
• sharedLinkUrl — Sharing link for the shared folder when driveType is Shared Folder Link.
• fileSelection — How to specify the Excel file: Browse, By Path, or By ID.
• browseFolder1 — First level folder or file when browsing.
• browseFolder2 — Second level folder or file when browsing.
• browseFolder3 — Third level folder or file when browsing.
• browseFolder4 — Fourth level folder or file when browsing.
• browseFolder5 — Fifth level folder or file when browsing.
• filePath — File path when fileSelection is By Path (e.g., /Documents/file.xlsx).
• fileId — File ID when fileSelection is By ID.
• worksheet (required) — Worksheet name or ID to read from.
• useRange — Whether to read a specific range instead of the used range.
• range — A1-style range to read (e.g., A1:B2). Required when useRange is true.
• keyRow — Zero‑based index of the row containing column headers within the range. Default 0.
• dataStartRow — Zero‑based index of the first data row within the range. Default 1.
• options.rawData — If true, returns the raw 2‑D array instead of parsing into objects.
• options.dataProperty — Property name to store the raw data when RAW Data is enabled. Default 'data'.

Output shape

array of objects

Each object represents a row. Keys are column headers from the header row, values are cell values. An additional _row_number field contains the 1‑based row index in the worksheet. If RAW Data is enabled, each output item contains a single property (named by options.dataProperty) holding the 2‑D array of cell values.

Links

• n8n community nodes installation guide