Search Mailing List Archives

Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[protege-discussion] import instances from spreadsheet

Jonathan Carter jonathan.carter at
Wed Mar 19 03:36:33 PDT 2008


There are some good tools for importing already in Protégé. However,
in my experience, the approach you take mostly depends on whether you
are importing into an empty project/ontology or whether you need to
map instances from your spreadsheet into an existing class hierarchy.
Based on this, I've tried a few approaches with success - ranging from
Excel->XML and then pasting the new instances into the PINS file of
the Protégé Project (a bit of a hack) to using the Script tab to add
instances through the API (more robust).

However, I'd recommend taking a look at the DataMaster Tab. It can
import instances from any JDBC or ODBC database. You can of course
present your Excel spreadsheet as an ODBC source. If you set up your
spreadsheet so that the columns in your sheet match the target
classes of the instances you want to import then it will bring them
all in for you.

If you need a more complex intepretation of the data you have in the
spreadsheet - i.e. a simple mapping isn't possible, then you could
look at exporting the spreadsheet as XML and then doing some XSLT
over it to create the script that will add the instances you need.

Hope this helps


Jonathan Carter - Head of Technical Architecture
Enterprise Architecture Solutions Ltd
Mobile: +44 (0) 7904 198295
Email: jonathan.carter at

Assess your EA maturity at:

-----Original Message-----
From: protege-discussion-bounces at
[mailto:protege-discussion-bounces at] On Behalf Of
Paul Smith
Sent: 19 March 2008 08:13
To: protege-discussion at
Subject: [protege-discussion] import instances from spreadsheet


I need a suggestion from experienced. I want to import some data,
that I have in Excel, as instances in to an OWL-Ontology, there are
of course strict conceptual relationships between the dataset and the
ontology. Which way to import the data from the spreadsheet into the
ontology? shall I involve a reasoner (thinking to a Realization
Reasoning Service) or via XML ???  

Every solution is welcome

protege-discussion mailing list
protege-discussion at

Instructions for unsubscribing:

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the protege-discussion mailing list