Excel can't convert xml file to xml table when there's only one row

loamylo 20 Reputation points
2024-04-26T15:27:46.35+00:00

Hello,

I get a response XML from a service. When the XML contains multiple rows of data it imports into Excel fine but if there is only one row of data the headers nothing imports. Both XML files are attached.

BidBidCap_SINGLE_LOCATION.xmlCap_MULTIPLE_LOCATIONS.xml

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,646 questions
0 comments
Accepted answer
  1. Jiajing Hua-MFST 5,155 Reputation points Microsoft Vendor
    2024-04-29T06:02:15.5733333+00:00

    Hi @loamylo

    Based on my tests, I can see the same results as yours. When I import XML with only one (single row of data), there are no column headers generated.

    Maybe the single layer XML is not reorganized as a "table". If I add the <Boady></Boady> in xml file, it seems to be OK.

    User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest