Help! Unable to import Contacts , get below Invalid Format error message

(0) Share

Report

Posted on by Community Member

Hi ,

I am trying to create new contacts for existing accounts in CRM.

For this I extracted the Import Template of Contacts from CRM and entered my data but when I am attempting to import the file I get the below message :

I have successfully imported several times for leads , where am I going wrong with contacts , please help!

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

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

PS 23,577 on at

Like (0)

Report

Have you exported the xml from settings>>data management>>template for imports

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, did exactly that

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

Check if you have two columns with same name or any special characters in the sheet

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

No, everything is good , not sure what is wrong!

Was this reply helpful? Yes No
PS 23,577 on at

Like (0)

Report

Can you download the import template again and paste the data from the source file.

Also, tell me the file extension of your current file? is it xml?xlsx or csv?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, I have done that atleast thrice now but no luck, I will just open a case with Microsoft maybe :(

Thanks for all your help.

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

Hope you have not saved it in xls or xlsx format

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Please verify if you have A B C columns that are hidden. Check column names ABC aee like below:

Was this reply helpful? Yes No
Suggested answer

Nausher Sayeed 522 on at

Like (0)

Report

Hi,

Download the template again and put your data in that template again.

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

Hello Experts,

can we remove the non required columns from the template and only required columns are filled with data and will it be possible for us to import the data.

Was this reply helpful? Yes No