Extensible markup language data in an extensible markup language (such as
XML) is associated with a schema file for defining data types and data
type definitions for applying data to the document. A map is prepared
that relates that any extensible markup data applied to the document back
to corresponding elements or attributes defined in the associated schema
file. When the document is imported into a spreadsheet application grid,
the data map is parsed to find XPATHs which determine the location, data
types and user data for each cell or list object in the document related
to the schema file. The cells and lists are populated with the extensible
markup data and user data, and rendered according to formatting dictated
by the extensible markup data applied to the document. The document may
be exported such that the extensible markup data is maintained for
subsequent import and use.