Monday, 18 May 2015 12:57

Synchronize Excel to EA using MDG Office Integration

Written by
Rate this item
(3 votes)

MDG Office Integration for excel supports the following

Import from Excel 

  • Importing artifacts from MS Excel documents
  • Synchronizing subsequent changes (additions, modifications) from the MS Excel document into EA 

Export to Excel

  • Export Enterprise Architect contents into a (pre-formatted) Excel spreadsheet

Please follow the following steps to try synchronization

  1. Import an Excel document using the profile defined for the respective worksheet
  2. Check ‘Enable Synchronization’ in the Importer dialog

  1. You will be prompted with the following dialog
    1. You can request EA to write sync data into the original file that is imported
    2. Or write the synch data to a backup file (which will then become your master copy in which subsequent changes must be done)
  2. Once you choose the backup file path and synch settings, click Apply

  1. Click Preview and Import in the Importer dialog
  2. Upon successful completion of import, the synch data will be added to the output file

  1. Make changes to the synchronization file (where the Synch information has been written)
  2. The Synchronization file, which becomes your masterfile, must be reimported using the same steps as above to ensure the contents are synchronized.
  3. You will notice that the EA artifacts are ‘Updated’ instead of ‘Added’

Read 10150 times Last modified on Tuesday, 19 May 2015 06:18

Sparx System India (Consultant & Coach)

Nabil Saleem works as Consultant in Sparx System India. He is highly proficient in Enterprise Architect tool. He has trained and assisted several teams to roll-out their Architecture modelling practices using Sparx Enterprise Architect. He has worked with solution and enterprise architects, assisted them in migration of their solution/enterprise As-Is and To-Be view into Sparx Enterprise Architect from various enterprise tools. He has highly involved in Product Demonstration, Gathering EA requirements, providing efficient solutions, defining Blue Prints, migrating artifacts from MS OFFICE, MS Excel, MS Visio, Scripting, Deployment of Sparx EA in cloud, Customized Reports generation & Code generation. He is an ardent blogger with special interests in scripting, architecture modelling (UML, BPMN 2.0, SysML 1.3 and Archimate 2.0) and MDG customization of Enterprise Architect. He has assisted various leaders in Telecom, Embedded System, Automotive, Insurance and Banking industry to define architecture using customized blue prints. He publish articles about Enterprise Architect in Sparx Systems India blog at and also posts tips in LinkedIn ( and Twitter(
Login to post comments