The Scenario
The new quarter starts in four days. Your VP of Sales built the pipeline tracker in Excel over the last six weeks — 80 deals, each with a name, estimated value, close date, and the account it's attached to. Now she wants all of it in Dynamics 365 before the QBR. She handed it to you with one instruction: "Get it in by Friday."
Nobody documented how Dynamics 365 expects opportunity fields to be structured. You've never used the Data Import Wizard for opportunities before — leads, yes, but opportunities have a required account link and a currency field and a probability that the wizard may or may not populate automatically.
The bad version:
- Look up the Dynamics opportunity entity schema in Microsoft docs to figure out which fields are required and what format the close date needs to be in
- Build the import CSV with the correct column names, discover the account ID column needs to reference an existing Dynamics account record ID (not the account name from the workbook)
- Run the import, get 18 errors for opportunities where the account ID was a name string instead of a GUID — go back and resolve each account name to its Dynamics record ID manually
Friday is 72 hours away. You are not a Dynamics administrator. You are the person who got handed the workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your pipeline tracker, understands the columns, and creates opportunity records in Dynamics 365 directly — no entity schema research required, no import wizard, no GUID lookup step.
For every deal in my Excel table with columns for name, revenue estimate, currency, close date, and account ID, create a Dynamics CRM opportunity and record each new ID in column F
What You Get
- One Dynamics 365 opportunity created per row, with name, value, close date, and account linkage populated
- Column F filled with the new opportunity ID for each deal
- Rows that fail (invalid account ID, missing required field) surface an error in column F rather than dropping silently
- The workbook becomes a live manifest: every deal has either a Dynamics opportunity ID or an error explaining why it didn't
What If the Data Is Not Quite Ready
Close dates are in inconsistent formats across rows
For each row in my Excel table, standardize the close date column to ISO 8601 format (YYYY-MM-DD), then create a Dynamics 365 opportunity using all five columns and write the opportunity ID to column F
Some rows have estimated values in mixed currencies
Create a Dynamics 365 opportunity for each row in my Excel table using name, revenue estimate, currency, close date, and account ID — if the currency column indicates GBP, convert the revenue estimate to USD using today's exchange rate before sending — write the opportunity ID to column F
Some account IDs are account names instead of GUIDs
For each row in my Excel table where the account ID column contains a text name instead of a GUID, look up the matching Dynamics 365 account record by name and replace the value with the account ID, then create the opportunity and write the opportunity ID to column F
Normalize all fields, resolve account names, and create all 80 opportunities in one shot
Standardize close dates to YYYY-MM-DD, strip currency symbols from revenue estimates, resolve any account names in the account ID column to their Dynamics account record IDs, skip rows where the account ID could not be resolved and flag them in column G, then create a Dynamics 365 opportunity for every remaining row and write the opportunity ID to column F
One prompt covers the full chain. No intermediate export, no pre-processing step.
Try It
Get the 7-day free trial of SheetXAI and open the Excel pipeline tracker, then ask it to create all 80 opportunities in Dynamics 365 before the QBR on Friday.
Also see: Bulk Create Dynamics 365 Accounts From Excel and Export Dynamics 365 Invoices to an Excel workbook.