News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Error during Excel imp...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Error during Excel import, Input string was not in a correct format.

(0) Share

Report

Report

Posted on by Sumaira Noor

1,081

Hello Community Experts,

I'm facing this error every time i try to import the data, in settings>Data Managements> Import > Input string was not in a correct format.

Please help me resolve this issue, I'm facing this from quite long.

Best Regards,

Sumaira Noor

All responses Img

All responses (6)

Answers Img

Answers (2)

Sumaira Noor 1,081 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

Hi ydynamics

What issue are you facing in import

Please share

I followed the steps lu has mentioned and that helped me resolve the problem

Regards

Sumaira
ydynamics 102 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

Hi How did you solve it?
Sumaira Noor 1,081 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

Thanks Lu and T.I.A

It is solved
Verified answer

T.I.A 1,760 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

what kind of data is in the column causing it to fail?
Sumaira Noor 1,081 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

Thanks a lot for the response Lu, I'm still not able to import.

Kindly help

Best Regards,

Sumaira Noor
Verified answer

LuHao 40,876 on at

Like (0)

Report

RE: Error during Excel import, Input string was not in a correct format.

Hi partner,

You may have entered a value that does not match the field data type and format.

When you open a field's settings interface, you'll see its Data Type and other formats.

All the data you enter in Excel must match the format of its fields.

For example, if the field is Single Line of Text and the Maximum Length is 160, then all values in this column in Excel cannot exceed 160.

If the field is Whole Number, the Maximum Length is 1,000,000,000 and the minimum value is 0, then all values in this column in Excel can only be integers and they must be between 0 and 1,000,000,000.

The format of these fields can be seen on the downloaded Excel template. When you click on the cell, it will display the format requirements of this cell, so the data you input needs to meet this requirement.

So, I recommend you use an import template or export a view as a static worksheet.

1. import template

Go to Advanced Settings > Data Management > Templates for Import, select the entity, download the template, enter the data in it, import it.

2. export a view as a static worksheet

Go to the view, click Export to Excel > Static Worksheet, download the Excel and enter the data in it, import it.

Finally, please pay attention to the language. If your environment is set to English, you can only type in English in Excel and you cannot enter any text in other languages.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,307 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans