Wrong data types when importing XML

Question

Here is small XML file as example: https://1drv.ms/u/s!AJDX987WrbwRm1I

When I import this file: Data > New Query > From File > From XML, as a result I get wrong format for numeric values.

In embedded XML Schema several numeric fields are defined as float data type. Instead Excel removes decimal separator and introduces large integer value instead.

Why is this, and how to workaround this issue?

Thanks

Answer 1

Hi,

Since your query is related to importing XML files into Excel, I kindly request you to address this in following TechNet forum for better suggestion.

http://social.technet.microsoft.com/Forums/en/excel/threads

If you have any questions related to Office products, you can always reply and I’ll be happy to assist you.

Thank you.

Answer 2

Thanks, question is now on: https://social.technet.microsoft.com/Forums/office/en-US/35632384-7e58-4ac5-857d-8ea57ce5fcc1/incorrect-data-types-when-importing-xml?forum=excel

Answer 3

Hi dejan,

In which fields do you see PowerQuery removing the decimal separator?

Can you please attach a screenshot and your Excel version?

Thanks