Microsoft Excel

Review the minimum OAuth scopes for every Microsoft Excel action.

Review the minimum standard delegated scope mapping for every Microsoft Excel action. The mapping covers workbook sessions, worksheets, tables, rows, columns, cells, formulas, formatting, and drive discovery.

Warning

Files.ReadWrite.All is the platform standard for all Excel actions, including read actions. Microsoft Graph lists Files.ReadWrite as the least privileged permission for resolving a workbook from a sharing URL (GET /shares/{u!}/driveItem). Files.Read and Files.Read.All are not enough for that API.

While personal /me/drive workbooks can technically execute with Files.Read or Files.ReadWrite, Excel workbooks frequently reside in SharePoint document libraries, Microsoft 365 Groups, or are accessed through direct file URLs. Removing .All restricts access exclusively to personal OneDrive files and breaks access to workbooks stored in SharePoint document libraries or shared via links.

Microsoft Graph does not support Sites.Selected or Files.SelectedOperations.Selected for Excel /workbook/ session operations.

Minimal scopes per action

Action Description Minimum scopes

Add sheet to workbook Adds a worksheet to an existing Excel workbook. Files.ReadWrite.All

Add table row Adds a new row to the end of a table. Files.ReadWrite.All

Clear range Clears cell contents, formatting, or both from a range without deleting the cells. Files.ReadWrite.All

Create chart Creates a chart from data in a range. Files.ReadWrite.All

Create table Creates a new table from a cell range. Tables enable filtering, sorting, and structured references. Files.ReadWrite.All

Delete column Deletes a column from a worksheet, shifting remaining columns left. Files.ReadWrite.All

Delete row Deletes a row from a worksheet, shifting remaining rows up. Files.ReadWrite.All

Delete table row Deletes a specific row from a table given its row index. Files.ReadWrite.All

Format cells Applies formatting to cells including font styles, background colors, and borders. Files.ReadWrite.All

Get all table columns Retrieves all columns from a table. Files.ReadWrite.All

Get item by name Searches for Excel files by name or resolves a direct URL. Returns file ID, driveId, name, URL, and metadata for use with other Excel actions. Files.ReadWrite.All

Get range Retrieves data from a specified cell range in a worksheet. Use this to read data that is not in a table. Files.ReadWrite.All

Get sheet by item id Retrieves all worksheets of an Excel workbook. Files.ReadWrite.All

Get single table row Retrieves a specific row from a table given its row index. Files.ReadWrite.All

Get table rows Retrieves rows from a table with pagination support, including the table name. Use this to read data from Excel tables. Files.ReadWrite.All

Get tables Retrieves all tables from a worksheet, specified by item id and sheet id. Files.ReadWrite.All

Get workbook summary Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts. Files.ReadWrite.All

Insert column Inserts a new empty column to the left or right of a specified column, shifting existing columns. Files.ReadWrite.All

Insert formulas Inserts Excel formulas into cells at a specified range. Use this to add calculations like =SUM(), =AVERAGE(), =IF(), etc. Files.ReadWrite.All

Insert row Inserts a new empty row above or below a specified row, shifting existing rows down. Files.ReadWrite.All

Merge cells Merges cells in a range into a single cell. Files.ReadWrite.All

Resolve drive Resolves drive metadata by ID or searches for drives by name. Returns standardized items for ID field resolution. Files.ReadWrite.AllSites.Read.All

Resolve item Resolves Excel file metadata by ID or searches for files by name. Returns standardized items for ID field resolution. Files.ReadWrite.All

Resolve table Resolves table metadata by ID or searches for tables by name. Requires driveId and itemId. Files.ReadWrite.All

Resolve worksheet Resolves worksheet metadata by ID or searches for worksheets by name. Requires driveId and itemId. Files.ReadWrite.All

Set alignment Sets text alignment for cells (horizontal and vertical). Files.ReadWrite.All

Set number format Sets the number format for cells (currency, percentage, date, etc.). Files.ReadWrite.All

Sort range Sorts data in a range by one or more columns. Files.ReadWrite.All

Update cells Updates cells in a worksheet at a specified range. Files.ReadWrite.All

Update table row Updates values in a specific row or range within an Excel table. Files.ReadWrite.All

Minimal scopes per action

Related pages