2. The method of claim 1 , whereby the step of rendering the data file in the spreadsheet document includes rendering the data file in the spreadsheet document whereby any user data associated with the plurality of fields are positioned in the spreadsheet document according to the layout.
1. A method of utilizing hierarchical data in an extensible Markup Language formatted in a spreadsheet document, comprising: selecting a data file containing the hierarchical data for importing into a spreadsheet document whereby the data file has applied hierarchical data mapped to the spreadsheet document, wherein the applied hierarchical data includes a plurality of fields; identifying a hierarchical data mapping whereby each of the plurality of fields of the hierarchical data applied to the data file is mapped to an associated schema file for defining data definitions for the plurality of fields applied to the spreadsheet document; parsing the hierarchical data mapping to obtain pointers associated with the plurality of fields applied to the data file pointing to the applied plurality of fields of the associated schema file, whereby parsing the data mapping includes: parsing the hierarchical data mapping to obtain pointers referenced to positions in the data file associated with each field of the plurality of fields applied to the data file for pointing each field of the plurality of fields applied to the data file to a corresponding data definition in the associated schema file; and parsing the hierarchical data mapping with a parser and obtaining an address for pointing to a particular node in the hierarchical data for each field of the plurality of fields applied to the data file from the associated schema file; executing each pointer to find locations of the plurality of fields applied to the data file; executing each pointer to the associated schema file to obtain hierarchical data definitions applicable to the plurality of fields according to the schema file; populating the locations of each field of the plurality of fields with any associated user data and the corresponding plurality of fields and hierarchical data definitions from the associated schema file; determining a layout for rendering the data file to the spreadsheet document based on the locations of each field of the plurality of fields applied to the data file; and rendering the data file in the spreadsheet document by converting the data from a hierarchical structure to a flattered data structure for rendering the data in the spreadsheet document, and by formatting any user data rendered in the spreadsheet document according to the data definitions associated with a field in the plurality of fields applied to the location of the any user data according to the associated schema file, whereby the plurality of fields in any user data associated with the plurality of fields are positioned in the spreadsheet document according to the layout.