Import data from XML spreadsheet causing mapping issues not able to resolve

(1) Share

Report

Posted on by DebbieAG

Hi all, I am having issues with importing from a template into Dynamics 365 sales enterprise.

I have tried multiple times to import data from a lead excel template and get the same error that a field is not mapping correctly and when I choose ignore I get this message "The XML passed to the platform is not well-formed XML." I also cannot see what field/column is not mapping correctly.

Is this a new issue, as I have imported from a template in the past with no issues?

Categories:

Microsoft Dynamics CRM

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Tom_Gioielli 3,096 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Are you working from an old template maybe, and something in your table has changed? Try going into Advanced Settings > Data Management > Download template for grab a new one.

Otherwise, do other imports work for you? When did this one start failing? Are you able to import data from your own spreadsheet doing manual mapping successfully?

Was this reply helpful? Yes No
DebbieAG 50 on at

Like (0)

Report
Copy link

Link copied!

Hi Tom, yes I have downloaded a new template and populated the data. Since it is a lead, there are few required fields on that form. It keeps saying a field is not mapped, but it does not identify which field is not mapped. I said ignore,, and it does nothing. No attempts to import anything so there are no successes or failures?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Import data from XML spreadsheet causing mapping issues not able to resolve

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Import data from XML spreadsheet causing mapping issues not able to resolve

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Meet the Microsoft Dynamics 365 Contact Center Champions

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates