# Microsoft Excel

Microsoft Excel is a spreadsheet application within Microsoft 365. Connecting it to Duvo lets your assignments read, write, and analyze spreadsheet data stored in OneDrive or SharePoint, turning static workbooks into dynamic data sources for automated workflows.

## Setup

Click **Enable** on the [Connections page](https://app.duvo.ai/integrations) and authorize with your Microsoft account.

## Capabilities

* **Create workbooks** — Generate new Excel workbooks to store reports, logs, or structured output.
* **Read spreadsheet data** — Retrieve values from workbooks stored in OneDrive or SharePoint for use in assignment workflows.
* **Update cells** — Modify individual cell values to keep records current.
* **Batch update cells** — Write to multiple cells in a single operation for efficient bulk data entry.

## Key Benefits

* **Central data hub** — Connect assignments to the Excel workbooks your team already relies on in OneDrive or SharePoint.
* **Flexible data operations** — Read individual values or batch-update hundreds of cells in a single step.
* **Real-time record keeping** — Keep workbooks current with automated data entry instead of manual updates.
* **No database required** — Use familiar Excel workbooks as your assignment's data source without standing up a separate database.

## Works Well With

* **Microsoft Outlook** — Pull data from incoming emails and log it directly into tracking spreadsheets, or send summary emails based on spreadsheet contents.
* **Microsoft SharePoint** — Combine document management with spreadsheet data to maintain project dashboards and shared records in one ecosystem.
* **Microsoft OneDrive** — Store and organize the workbooks your assignments read from and write to, keeping file access seamless.