1. A computer implemented method of managing an application of structured data and data mappings to a spreadsheet application, comprising: obtaining the structured data, wherein the structured data comprises one or more data definitions to associate with the spreadsheet application; parsing the structured data to determine the one or more data definitions and structure required for valid data; combining the structured data received from multiple sources to create a unified schema definition comprising data definitions and structure applicable to the structure data; selecting a root element from the unified schema definition for constructing a generalized instance; creating a map object to maintain all information about the data mappings, wherein the information about the data mappings comprises schema definitions used, name of the map, and relationship of fields to spreadsheet application cell ranges; building a generalized instance structure from of the unified schema definition, wherein the generalized instance structure presents available fields and data content of the unified schema definition that may be applied to the spreadsheet application; and displaying a view of the generalized instance structure for providing a visual representation of a valid data file wherein the view contains fields for visually representing the fields and data content of the unified schema definition that may be validly applied to the spreadsheet application.