Azure DevOps + Microsoft Excel

Create Azure DevOps work items from new Microsoft Excel rows

Effortlessly manage your projects with this streamlined workflow between Microsoft Excel and Azure DevOps. When a new row is added to your Excel sheet, a work item will be created in Azure DevOps, ensuring seamless collaboration and efficient task tracking. Stay organized and maintain productivity by connecting two powerful platforms with this user-friendly automation.

When this happens...
New Row
Triggers when a new row is added to a worksheet in a spreadsheet.
TriggerPolling
automatically do this!
Create Work Item
Create a new work item.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write
- ProjectRequired
- PathRequired
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
- Contains StringRequired
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
- Changed Field
Trigger
Instant
Try It
- ProjectRequired
- TypeRequired
- TitleRequired
- Area
- Iteration
- Assigned To
- Description
Action
Write
- ProjectRequired
- Work Item NumberRequired
- LinkRequired
- Comment
Action
Write
- ProjectRequired
- TeamRequired
- Would you like to setup the query here or use an existing query?Required
Action
Search

- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
- Build DefinitionRequired
- Build Status
- ProjectRequired
Trigger
Instant
Try It
- ProjectRequired
- Repository
- Branch
Trigger
Instant
Try It
- ProjectRequired
- Area Path
- Work Item Type
Trigger
Instant
Try It
- ProjectRequired
- Build DefinitionRequired
Action
Write
- ProjectRequired
- Work Item TypeRequired
- Work ItemRequired
- Do you want to supress notifications for this update?
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- ProjectRequired
- TeamRequired
- Would you like to setup the query here or use an existing query?Required
- ProjectRequired
- TypeRequired
- TitleRequired
- Area
- Iteration
- Assigned To
- Description
Action
Search or write

About Azure DevOps

Azure DevOps is where teams manage, develop, and deliver software in the cloud. Azure DevOps provides free, private Git project hosting for up to 5 users, project and test management tools, build and CI, and team collaboration. Connect using the development tools of your choice, including Visual Studio, Eclipse, Xcode, and more.

Related categories

Similar apps

GitHub

Developer Tools

Jira Software Server

Project Management

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Learn more

Azure DevOps + Microsoft Excel

Create Azure DevOps work items from new Microsoft Excel rows

New Row

New Worksheet

Add Row

Add Row to Table

Create Worksheet

Find Row

Get Worksheet by ID

Find or Create Worksheet

Code Check-In (TFVC)

New Work Item Comment

Updated Work Item

Create Work Item

Add Link to Work Item

Find Work Item

New Row in Table

Updated Row

Add Row(s)

Create Workbook

Update Row

Find Worksheet(s)

Find or Create Row

Completed Build

Code Push (Git)

New Work Item

Trigger Build

Update Work Item

API Request (Beta)

Find or Create Work Item

About Azure DevOps

Related categories

Similar apps

GitHub

Jira Software Server

About Microsoft Excel

Related categories

Similar apps

OneDrive

Smartsheet

Quip