web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Service | Customer Service, Contact Center, Fie...
Unanswered

Importing Excel Spreadsheet Into Dynamics 365

(0) ShareShare
ReportReport
Posted on by 5

I have tried to import an Excel Spreadsheet Into Dynamics 365 and I continue to get the following error:

The import file does not have the format that Dynamics 365 uses to map the data to Dynamics 365 fields. It is possible some hidden sheets that the system uses have been modified or corrupted. Try again with a file exported from Dynamics 365.

I have changed the file format in different ways, including trying .cvs format with UTF 8, windows .cvc,, and .xlsx 

I also downloaded a template from Dynamics 365 and copied a sample data on the spreadsheet template, but for some reason it said that it imported the records and when I search for the imported records it shows one with just the first name and the last name.

There isn't any guidance on what the actual format is needed. 

HELP!

I have the same question (0)
  • LeoAlt Profile Picture
    16,331 Moderator on at
    RE: Importing Excel Spreadsheet Into Dynamics 365

    Hi partner,

    1.Please make sure that you download the template from Settings->Data Management -> Templates for Data Import.

    pastedimage1588298716746v1.png

    2.Check if there is any hidden columns in your template.

    3.Try all columns one by one to find out which column did not map to the field.

    Best Regards,

    Leo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 70

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 22 Super User 2025 Season 2

#3
mk1329 Profile Picture

mk1329 16

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans