The Excel Import/Export Wizards
The Excel Import/Export wizard supports two file formats: XLS and XLSX.
Import Wizard
The file imported from Excel in HOPEX enables you to:
• create or modify a list of objects,
• connect objects by a given link.
Data contained in the import file should be clearly structured so as to be correctly interpreted in HOPEX. This being so, it is recommended that a previously exported file be used as a model.
The import result file indicates anomalies encountered.
Export Wizard
The HOPEX export wizard generates an Excel file in which you can work before importing objects into the source repository or another repository.
HOPEX offers two types of export to Excel:
• Excel Export from a list of objects,
This type of export is available from a list of objects only. See Exporting an object list in Excel format.• wizard-export based, which enables you to parameterize exported data format in order to import those data later, see Using the Excel Export Wizard.
Exporting an object list in Excel format
You can export an object list in Excel format.
For example, using the All organizational processes tile of the desktop home page, you can display the list of all organizational processes.
To export objects and the displayed attributes:1. Select the objects that interest you.
2. In the menu bar of the list, click Excel 
.
.The contents of the Excel file depend on the selected HOPEX options.
For more details on these options, see Using the import/export wizards.• If the option Export Excel: Availability in listviews is not selected, the Excel file contains exported objects in rows and the displayed attributes in the initial list in columns. This file cannot subsequently be re imported into HOPEX.
• If the Export Excel option: Availability in listviews is selected, the Excel file contains exported objects in rows and some of the editable attributes in columns.