Abstract: Spreadsheet is intuitive for many non-technical users. But there arc two difficulties in operating xml data on spreadsheet, One is how to represent xml data in spreadsheet, and the other is how to express complex query with simple opcrations,such as copy,pastc and move. A spreadsheet like construct was proposed to represent XML data and to express complex query using a group of simple operations. XML Schema was represented as nested-table in spreadsheet like construct and users’operations on spreadsheet were transformed into XQuery statements on xml schema. The spreadsheet like construct was implemented in an information convergence system to query complex data distributed in heterogeneous data sources. Compared with popular XQuery constructing tools, spreadsheet is suitable for users with little or no experiences in programming to query complex data.

Key words: Spread sheet, XQuery, Information integration, Information resource convergence