# Xml data mapping issue excel

**URL:** <https://forum.kirupa.com/t/xml-data-mapping-issue-excel/245326>\
**Category:** Uncategorized\
**Created:** [November 28, 2007, 4:36pm UTC](https://forum.kirupa.com/t/xml-data-mapping-issue-excel/245326 "2007-11-28T16:36:45Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![brndn](https://avatars.discourse-cdn.com/v4/letter/b/dec6dc/32.png) [@brndn](https://forum.kirupa.com/u/brndn)\
**Post date:** [November 28, 2007, 4:36pm UTC](https://forum.kirupa.com/t/xml-data-mapping-issue-excel/245326/1 "2007-11-28T16:36:45Z")

</div>

hey and I know, “why the F\*\*\*K would anyone want to use excel to drive an application.”

anyway I have imported a very simple xml file.  
it all spans within the talbe structure.

The issue is when I come to validate or export it errors with “\*denormalised data”

excel 2007

here is the xml structure.

\<?xml version=“1.0” encoding=“UTF-8” standalone=“yes”?\>  
\<results xmlns:xsi=“[http://www.w3.org/2001/XMLSchema-instance](http://www.w3.org/2001/XMLSchema-instance)”\>  
\<sizeOfMarket\>  
\<data\>  
\<date\>\</date\>  
\<current\>\</current\>  
\<target\>\</target\>  
\<benchmark\>\</benchmark\>  
\<market\>\</market\>  
\</data\>  
\</sizeOfMarket\>  
\<volume\>  
\<data\>  
\<date\>\</date\>  
\<current\>\</current\>  
\<target\>\</target\>  
\<benchmark\>\</benchmark\>  
\</data\>  
\</volume\>  
\</results\>

any light to share would be very much appriciated.