Export an Excel Sheet from Graph Modeling
Export an Excel Sheet from Graph Modeling
The section contains the necessary steps you have to follow to export an Excel file.
Take the following rules into account when using the Graph Modeling Excel export function:
The exported files will comply to the Graph Modeling Excel format.
The Excel export option is available on all levels of a project: You can export the whole project, a custom scheme or a subtree.
Data is always exported in the default language of the project.
For multilingual projects the additional languages can be selected in the respective field.
Important
Custom relations can be imported using Graph Modeling’s tabular import operation, but Graph Modeling tabular export does not support relations of any kind. Specifically, the relation skos:related, SKOS “semantic alignment” relations such as skos:exactMatch, and custom relations are not included in the output of tabular export. Hierarchical relationships (broader/narrower) are represented implicitly in the structure of the exported hierarchy. We are working to support tabular export of relationships in future releases.
You have to follow the steps below in order to export data. The output will be an Excel file with an .xls or .xlsx extension.
Open your project in Graph Modeling.
Select the tree level you want to export: The first node, a custom scheme, a top concept or a concept.
Click Project in the main menu, to expand it.
Select Export, in the submenu select Excel Project Export.
When exporting from a subtree entry, the submenu will be called Excel Subtree Export .
A new dialogue will open displaying a list of available languages.
Select the languages you want to export in addition to the default one.
Multi-select languages by using the Ctrl or the Shift keys.
When you click Export, Graph Modeling takes a moment to collect data, then the default Save Asdialogue of the browser you are using will let you choose a location to save the file.
uri | concept | concept | concept | concept | altLabel@en | altLabel@de | hiddenLabel@en |
|---|---|---|---|---|---|---|---|
http://my.com/Cocktails | Cocktails | ||||||
http://my.com/Aperitif_and_digestif | Apéritif and digestif | ||||||
http://my.com/Spritz_Veneziano | Spritz Veneziano | ||||||
http://my.com/Wine_Cocktail | Wine Cocktail | Cocktails with wine | Cocktails mit Wein |
Tip
If you would like to learn more about this topic, please watch this Graph Modeling Academy Tutorial video: