home > library > publications > topic maps from excel the easy way using the constructor

close subject identifiers for Topic Maps from Excel the easy way using the Constructor
  • http://www.topicmapslab.de/publications/topic_maps_from_excel

Topic Maps from Excel the easy way using the Constructor

Paper, was published by Terry Badger at 2006-08-07

This paper is about createing topic maps with Excel.

External Link: more information

Using Excel Professional 2003 save as XML and a series of XSL Stylesheets called the “Constructor” an XML Topic Map is immediately created. What makes this work is that one of the sheets in the Excel workbook, Constructor, is used by the customer (with help I find!) to specify where information needed to generate topics and associations will be found in other sheets. The process assumes that topics or associations are generated for each and every row of any sheets mentioned in the Constructor. It is possible to create associations with multiple members with each member playing a different role. The column of one sheet may be used to enumerate the column heads of another sheet to create a join. This eliminates the need to write any XSL to create a Topic Map thus freeing up time to write the application XSL based on the generated topic map. This has been successfully used in a couple of small in-house projects.

Presented at


Follow us on Twitter


As a former information scientist, I am fascinated since 1999 by the capabilities for building Topic Maps-based knowledge systems having the potential to augment human mind. One can model arbitrary knowledge organization systems, deal with semantic heterogeneity, collocate all facts about one subject in one logical place, and with TMQL have semantic retrieval on federated semantic networks. Therefore I expect bright prospects for business concepts building on the exchange of such knowledge snippets via semantic knowledge services.

Alexander Sigel
Topic Maps Lab auf der Cebit 2011

Graduate from the Topic Maps Lab