Share via

Wrong data types when importing XML

Anonymous
2016-06-29T15:37:30+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-06T10:02:44+00:00

    Hi dejan,

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

    Can you please attach a screenshot and your Excel version?

    Thanks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2016-06-30T07:19:10+00:00

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-06-29T19:47:09+00:00

    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.

    Was this answer helpful?

    0 comments