The Scenario
The data enrichment vendor delivered the output file this morning. 250 leads from your Dynamics 365 CRM — pulled two weeks ago, sent to the enrichment service, and now returned with corrected phone numbers, updated job titles, and lead scores. It's all sitting in an Excel table: lead ID in column A, corrected phone in column B, job title in column C, rating in column D.
You're the RevOps analyst. Your job is to get these corrections back into Dynamics before the sales team's outreach wave starts tomorrow. Not the 18 leads that came back clean — all 250.
The Dynamics Data Import Wizard can update existing records, but you've used it for updates before. It requires a specific column naming convention for match keys, it can overwrite fields you didn't intend to touch if the import template isn't scoped correctly, and it gives you one shot per import job — a partial failure means a partial update and no clean way to retry just the failed rows.
The bad version:
- Spend 40 minutes building and validating an import template that targets only the three fields you want to update without touching anything else
- Run the import, get 22 errors for records where the lead ID in column A didn't match a Dynamics record — figure out which of those are deleted records versus typos in the export
- Fix what you can, re-run, get 4 new errors for records where the job title exceeded character limits
250 records is not a lot until you're on your third import cycle at 4:30 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the enrichment output, matches on lead ID, and pushes the corrected values back into Dynamics 365 through its built-in integration — one pass, targeted to the three fields you specified, nothing else touched.
Read my Excel enrichment table and update each Dynamics CRM lead record with the corrected data in columns B through E, matching on lead ID in column A
What You Get
- Each Dynamics 365 lead updated on the three fields you specified — phone, job title, rating
- No other fields modified on those records
- A result logged per row: success confirmation or an error message indicating why the row failed (record not found, field validation, etc.)
- You have a clean audit trail of what changed and what didn't — useful if a sales rep asks why their lead record looks different
What If the Data Is Not Quite Ready
Some lead IDs in column A don't match live Dynamics records
For each row in my Excel table, check whether the Dynamics 365 lead in column A still exists before attempting the update — if the record is not found, mark the row as "not found" in column E and skip the update — update phone, job title, and rating for all rows with a valid match
Job titles in column C exceed Dynamics field length limits
For each row in my Excel table, truncate the job title column to 100 characters if it is longer, then update the Dynamics 365 lead matching column A with the truncated title, phone from column B, and rating from column D — note any truncation in column E
Phone numbers in column B have inconsistent formats
For each row in my Excel table, normalize the phone column to digits-only format before pushing the update, then update the Dynamics 365 lead in column A with the normalized phone, job title from column C, and rating from column D
Validate IDs, normalize phones, truncate titles, and update all 250 records in one pass
Check each lead ID in column A against live Dynamics 365 records — skip and flag any that are not found in column E. Normalize phone numbers in column B to digits-only format. Truncate job titles in column C to 100 characters if needed. Then update phone, job title, and rating for every valid lead record and log the update result in column E.
One prompt does the validation, normalization, and update chain. No intermediate import template, no partial retry.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your enrichment output, then ask it to push all the corrections back into your Dynamics 365 lead records before tomorrow's outreach wave.
Also see: Bulk Create Dynamics 365 Leads From Excel and Export All Dynamics 365 Leads to an Excel workbook.