Abstract: This invention is for a method to make sense of XML (Extensible Markable Language) data when it is imported into spreadsheets without the use of a stylesheet and to accurately capture that data automatically into the appropriate fields. When it is imported into spreadsheets without a stylesheet, the rows and columns are unspecifiable, and even for similar XML files having different sets of data, the rows and columns may not always correspond exactly, as it would with form data where each data field always has a place holder. The method developed by this claim uniquely addresses the issue of absorbing this data by cross indexing all descendant elements and attributes pillared around a mandatory element and attribute for one direction, and keeping an open spring like data sensing mechanism in the vertical direction, with resulting data read being instantly captured accurately, associated with the proper data field and validated.