# Microsoft Excel 365

> Manage Excel workbooks, tables, and sheets with data operations and table management capabilities.

Source: https://cotera.co/docs/reference/tools/individual-tools/microsoft-excel-365

---

**Authentication Type:** OAuth\
**Description:** Manage Excel workbooks, tables, and sheets with data operations and table management capabilities.

***

## Beta Notice

**This tool is currently in beta testing and not yet available for general use.**

To get the Microsoft Excel 365 tool added to your Cotera workspace, please contact our support team at [support.cotera.co](https://support.cotera.co).

***

## Table Operations

Manage Excel tables with data manipulation and structure operations.

### Append Rows to Table

Add one or more rows to an existing table in an Excel workbook.

**Operation Type:** Mutation (Write)

### Create Table

Add a table based on a range to convert a range of cells into a structured Excel table with headers and formatting.

**Operation Type:** Mutation (Write)

### Convert Table to Range

Convert a table to a range to remove table formatting while preserving cell data and values.

**Operation Type:** Mutation (Write)

### Get Table Columns

Retrieve a list of table columns to access column names, properties, and metadata from Excel tables.

**Operation Type:** Query (Read)

### Get Table Rows

Retrieve a list of table rows to read data and values from all rows in an Excel table.

**Operation Type:** Query (Read)

### Lookup in Table

Look for rows that match a given value in a column to search and filter table data based on specific criteria.

**Operation Type:** Query (Read)

## Range Operations

Read cell values directly from a worksheet range.

### Read Range

Read a range of cells from an Excel workbook to retrieve their values (e.g. `Sheet1!A1:C10`).

**Operation Type:** Query (Read)

## Sheet Operations

Manage Excel sheets and their data.

### Get Sheets

Get a list of sheets to retrieve all worksheets in an Excel workbook with their names and properties.

**Operation Type:** Query (Read)

### Get Sheet Rows

Retrieve a list of sheet rows to read data from specific rows in an Excel worksheet.

**Operation Type:** Query (Read)

### Append Data to Sheet

Append data to sheet to add new rows to the end of a worksheet without affecting existing data.

**Operation Type:** Mutation (Write)