Export an Excel Sheet from PoolParty
Export an Excel Sheet from PoolParty
The section contains the necessary steps you have to follow to export an Excel file.
Take the following rules into account when using the PoolParty Excel export function:
The exported files will comply to the PoolParty 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 PoolParty’s tabular import operation, but PoolParty 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 PoolParty.
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, PoolParty 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 PoolParty Academy Tutorial video: