Excel Import and Export

dragon1 excel import export

Dragon1 supports direct import of Microsoft Excel files (XLSX and CSV) and saving the imported data as entity objects in the repository via the Architecture Repository or Visual Designer web application.

Upload your Excel File Directly

Dragon1 is the SaaS platform for Enterprise Architecture. On the platform you create blueprints, landscapes and roadmaps to support decision-making and to guide innovation projects.

Many people are familiar with using Excel to collect data and create reports, and professional software solutions provide excel data exports, so you too may have a lot of data available in Excel.

You can directly upload or import this data from these Excel files. Just create a trial account on Dragon1, login, go to the Import Application, the Architecture Repository or the Visual Designer and Click on the import feature. Select your Excel file (CSV or XLSX) and with one click on the button your Excel is imported.

If your Excel file (XLSX) has multiple tabs, it will use the first tab in the file to import. With Dragon1 Excel import you will have a data lossless import of your data.

Example Excel File

Here is an example Excel file you can use to check the Import/Upload feature for Excel on Dragon1.

Example Excel File (CSV)

dragon1 import excel

This screenshot shows the Import/Upload of the example Excel file on Dragon1.

Saving Data As Entity Objects In The Repository

Dragon1 automatically creates entity objects in the repository from your imported/uploaded Excel.

For that you need to tag the data correctly. You do that by having at elas the following columns present in your import file:

  • uniqueid
  • name
  • title
  • description
  • class
  • type
  • bitmapimage
  • note

Other or extra fields will be mapped into the data attribute of an entity in the repository in JSON format.

The class name you should use is one of the 300+ predefined Dragon1 entityclasses you can choose from.

Export File to Excel (XLSX or CSV)

You cannot only import/upload Excel and save data as entity objects. You can also do a full round trip: you can export any document or visualization you create as Excel so that it can be opened and edited in Microsoft Excel and next you can import the edited file from Excel again.

You can do that by choosing File > Export > Excel (XLSX / CSV) in the Architecture Repository and Visual Designer.

Architecture Center

Many user organizations use Dragon1 as Architecture Center. They create a consistent set of about 20 visualizations on the platform, publish them in the Architecture Center and embed them on their own intranet.

Often this is hard to do without the ability of the Excel Data Import/Upload and with the imported data create models, views and architecture visualizations.

Because the feature is available on the Dragon1 platform, you can always succeed in reusing your Excel data or exported data from other systems and quickly and easily creating an Architecture Center on your intranet with it.

dragon1 architecture center

This screenshot is an example Architecture Center.

Want To Use Dragon1?

If you want to start using Dragon1, you can create a Free Trial Account here or contact us via info@dragon1.com or call us at +31(0)317 411 341.