Microsoft Excel + Microsoft Dynamics 365 CRM

Add new Microsoft Dynamics 365 CRM opportunities to Microsoft Excel rows

Streamline your sales process with this seamless integration between Microsoft Dynamics 365 CRM and Microsoft Excel. Once a new opportunity is identified in the Dynamics 365 CRM, a row will be instantly added to your Excel sheet. This automation enables you to keep close tabs on potential sales opportunities and ensures your record-keeping is consistent and timely. Save time, increase efficiency, and focus more on closing deals.

When this happens...
New Opportunity
Triggers when a new opportunity is created.
TriggerScheduled
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
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

New Account
Triggers when a new account is created.
Trigger
Scheduled
Try It
New Contact
Triggers when a new contact is created.
Trigger
Scheduled
Try It
- Custom EntityRequired
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It

- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It

- Info
Trigger
Scheduled
Try It
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- Customer typeRequired
- Status
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- OrderRequired
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- State Code
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

- Info
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Scheduled
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Scheduled
Try It
New Lead
Triggers when a new lead is created.
Trigger
Scheduled
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Scheduled
Try It
New Order
Triggers when a new order is created.
Trigger
Scheduled
Try It
- Info
Trigger
Scheduled
Try It
- Owner
Action
Write
- Owner
Action
Write
- Custom EntityRequired
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Owner
Action
Write
- Info
- Custom Entity ActionRequired
Action
Write
- Info
- InvoiceRequired
Action
Write
- Info
- OpportunityRequired
Action
Write
- Apply standard error handling?Required
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Additional Request Headers
- Body
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- Info
- Info Field Enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

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