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

Question

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

Answer 1

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.

---

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.

---