> ## Documentation Index
> Fetch the complete documentation index at: https://docs.langdock.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.
</Warning>

## Minimal scopes per action

<Note>
  Each Microsoft Excel connection also requests `openid`, `offline_access`, and `User.Read`. These connection scopes apply in addition to the action scopes in the table.
</Note>

<div style={{overflowX: "auto"}}>
  <table style={{width: "100%", maxWidth: "100%", minWidth: 0, tableLayout: "fixed", whiteSpace: "normal", overflowWrap: "anywhere", wordBreak: "break-word"}}>
    <colgroup>
      <col style={{width: "20%"}} />

      <col style={{width: "25%"}} />

      <col style={{width: "55%"}} />
    </colgroup>

    <thead>
      <tr>
        <th style={{width: "20%"}}>Action</th>
        <th style={{width: "25%"}}>Description</th>
        <th style={{width: "55%"}}>Minimum scopes</th>
      </tr>
    </thead>

    <tbody>
      <tr>
        <td><strong>Add sheet to workbook</strong></td>
        <td>Adds a worksheet to an existing Excel workbook.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Add table row</strong></td>
        <td>Adds a new row to the end of a table.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Clear range</strong></td>
        <td>Clears cell contents, formatting, or both from a range without deleting the cells.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Create chart</strong></td>
        <td>Creates a chart from data in a range.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Create table</strong></td>
        <td>Creates a new table from a cell range. Tables enable filtering, sorting, and structured references.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Delete column</strong></td>
        <td>Deletes a column from a worksheet, shifting remaining columns left.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Delete row</strong></td>
        <td>Deletes a row from a worksheet, shifting remaining rows up.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Delete table row</strong></td>
        <td>Deletes a specific row from a table given its row index.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Format cells</strong></td>
        <td>Applies formatting to cells including font styles, background colors, and borders.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get all table columns</strong></td>
        <td>Retrieves all columns from a table.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get item by name</strong></td>
        <td>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.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get range</strong></td>
        <td>Retrieves data from a specified cell range in a worksheet. Use this to read data that is not in a table.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get sheet by item id</strong></td>
        <td>Retrieves all worksheets of an Excel workbook.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get single table row</strong></td>
        <td>Retrieves a specific row from a table given its row index.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get table rows</strong></td>
        <td>Retrieves rows from a table with pagination support, including the table name. Use this to read data from Excel tables.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get tables</strong></td>
        <td>Retrieves all tables from a worksheet, specified by item id and sheet id.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Get workbook summary</strong></td>
        <td>Retrieves a summary of an Excel workbook including all sheets, their data ranges, tables, and charts.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Insert column</strong></td>
        <td>Inserts a new empty column to the left or right of a specified column, shifting existing columns.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

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

      <tr>
        <td><strong>Insert row</strong></td>
        <td>Inserts a new empty row above or below a specified row, shifting existing rows down.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Merge cells</strong></td>
        <td>Merges cells in a range into a single cell.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Resolve drive</strong></td>
        <td>Resolves drive metadata by ID or searches for drives by name. Returns standardized items for ID field resolution.</td>
        <td><code>Files.ReadWrite.All</code><br /><code>Sites.Read.All</code></td>
      </tr>

      <tr>
        <td><strong>Resolve item</strong></td>
        <td>Resolves Excel file metadata by ID or searches for files by name. Returns standardized items for ID field resolution.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Resolve table</strong></td>
        <td>Resolves table metadata by ID or searches for tables by name. Requires driveId and itemId.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Resolve worksheet</strong></td>
        <td>Resolves worksheet metadata by ID or searches for worksheets by name. Requires driveId and itemId.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Set alignment</strong></td>
        <td>Sets text alignment for cells (horizontal and vertical).</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Set number format</strong></td>
        <td>Sets the number format for cells (currency, percentage, date, etc.).</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Sort range</strong></td>
        <td>Sorts data in a range by one or more columns.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Update cells</strong></td>
        <td>Updates cells in a worksheet at a specified range.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>

      <tr>
        <td><strong>Update table row</strong></td>
        <td>Updates values in a specific row or range within an Excel table.</td>
        <td><code>Files.ReadWrite.All</code></td>
      </tr>
    </tbody>
  </table>
</div>

## Related pages

* [Microsoft Integration Scopes](/en/admin/manage-integrations/microsoft-integration-scopes)
* [Microsoft integrations: permissions and admin approval](/en/admin/manage-integrations/integration-setup-guides/microsoft)