Alternative EA Integration for Microsoft® Office – Excel Importer

Create a Template element

• Start by opening a package containing a single example of the element type you want to import (your Template element).
• Make this element ‘complete’, by adding data to the fields and TVs that are important.
• Then create a diagram with this element and add all its relationships/related elements – eaSheets will use this template as the standard pattern for the data you want to import.

Open the Smart Sheet

• In the Project browser, right click on the Package containing your template element, and select specialize – eaSheets – open Smartsheet
• The sheet opened shows a row with your element data – it includes a column each for the element name, type and stereotype, any fields and tagged values populated, and a column for each related element.

Add your data

• Now you can use standard spreadsheet functions (type, drag, copy/paste) to add new elements, their fields and TVs and their related elements.
• When you are ready, select “Import to EA”.

The result

• All the new elements will be created in your Package, and all the connectors to related elements will be created too.
• If EA can’t find the related elements, they will be added as new elements in the package as well.
• Simple.