Setup
Click Enable on the Connections page and authorize with your Microsoft account.Capabilities
- Create workbooks — Generate new Excel workbooks to store reports, logs, or structured output.
- Manage worksheets — Add new worksheet tabs, list existing tabs, and rename them to organize data across logical sections within a workbook.
- 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.
- Append rows — Add new rows after the last occupied row in a table or range without overwriting existing content, keeping running logs and datasets growing cleanly.
- Import from CSV — Overwrite a range of cells from a CSV file already in the assignment workspace, replacing existing data in a single operation.
- Append rows from CSV — Add rows from a workspace CSV file onto an existing table or range, merging new records without disturbing what is already there.
- Clear cells — Remove values, formatting, or both from one or more ranges in a single operation — useful for resetting templates or wiping stale data before a fresh run.
- Format cells — Apply number formats when writing data — currency symbols, thousands separators, percentages, date patterns, and more — so values display correctly without manual reformatting.
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.
Finding Workbooks
Assignments can open any Excel workbook you have access to — paste a URL or refer to the workbook by name, and Duvo locates the right file. Supported locations include personal OneDrive, SharePoint team sites, Microsoft Teams-connected sites, and root SharePoint libraries. Standard page links and “Copy link” share links from the Excel UI both work.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.