ArchiMate®, ERD, and UML® model data can be imported from an Excel workbook into Enterprise Studio using an Excel connection.
If import feedback has been activated for the connection, import may take more time.
Before you start importing data from Excel, make sure that the objects in your model and the mappings of your Excel connection do not have trailing spaces in their names. The same goes for the objects and worksheets in your Excel file. This is to prevent any unwanted matching issues during the import (see also Exporting model data to an Excel workbook). During the import from Excel, any trailing spaces in object and worksheet names will be removed and can cause issues.
For example, if object names do not match, new (unwanted) objects may be created upon the import. If workbook/mapping names do not match, import will not be possible. If they have trailing spaces at both sides (in Enterprise Studio and in Excel), import will fail because the trailing space from Excel side will be removed.
The import function does not check for collaboration conflicts. If one or more of the objects you are importing were claimed when the import is running, no data will be imported. However, this is not explicitly reported by the import. It will only show the message that the import has finished, and the Messages window will show any collaboration conflicts. Because of these, all changes will be reverted.
So please make sure there are no outstanding claims by removing other users' claims or have users commit their changes before you start importing.
- In the connection view, select the Excel connection, and then click
- Navigate to the Excel file you want to import, select it, and click Open. A message appears announcing the import.
- Click OK to start the import.
Upon import, the connection is validated first. If validation is (partly) successful, import from Excel starts. If the import is completed, a message confirming this appears. Click OK to close the message.
If validation fails, a message appears indicating errors have been found in the definition of the connection. Make your choice:
Click Yes to resolve the validation errors and warnings. After that you can start the import again.
Click No if you want to continue the import without resolving the errors. It may result in an incomplete data import, or no import at all.
Click Cancel if you want to cancel the import process.
If reporting has been activated in the connection settings, the Import from Excel window appears showing a summary of the import in a table.
Table with a summary of an import from Excel
If import feedback has been activated in the connection settings, then the Excel file is also opened. It contains feedback on the data you have imported with different colors and comments in the worksheets.
Example of feedback in an Excel file after import
ArchiMate® is a registered trademark of The Open Group.