Excel Import and Export

dragon1 excel import export

Dragon1 supports directly importing Microsoft Excel files (XLSX, XLS, and CSV) and generating architecture diagrams in the Viewer. Dragon1 also supports saving the imported data as entity objects in the repository via the Architecture Repository web application.

Upload your Excel File And Generate Diagrams in the Viewer

dragon1 generate using XLSX

Dragon1 is the SaaS platform for Enterprise Architecture.

On the platform, you create blueprints, landscapes, and roadmaps to support decision-making and guide innovation projects.

Popular diagrams to generate are:

  • Strategy Map
  • Business Model Canvas
  • Customer Journey Map
  • BPNM Process Diagrams
  • ArchiMate Diagrams
  • UML Diagrams (like Use Cases)

Many people are very 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 and generate a diagram with it, like the one above.

How to generate an architecture diagram using an Excel sheet

To generate an architecture diagram:

  • Create a trial account
  • Login
  • Download an example Excel Sheet
  • Edit the Excel Sheet as instructed.
  • Go to the Import Application: www.dragon1.com/import
  • Click on the upload button
  • Select your Excel file (f.i. XLSX)
  • Download the .dragon1 File.
  • Go to the Viewer: www.dragon1.com/viewer
  • Upload the .dragon1 File.

Generating architecture diagrams using Excel as input is possible because of the built-in visualization templates.

The Dragon1 Chatbot uses the native AI Engine to check your data, find the right visualization templates to use, and generate diagrams and dashboards in the Viewer.

If your Excel file (XLSX) has multiple tabs, it will use all tabs 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 to check the Import/Upload feature for Excel on Dragon1.

Example Excel File

dragon1 import excel

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

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 least 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 entity classes 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 make a complete 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 intranet.

Often, this is hard to do without the ability of the Excel Data Import/Upload and with the imported data to 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 of 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.

Architecting Solutions

DEMO: Concept Mapping Software

How to generate diagrams using Excel on Dragon1 EA Tool

Learn to generate diagrams using repositories
DEMO: BPMN Onboarding Process Example

DEMO: BPMN Onboarding Process Diagram - Measure Rules Compliance

Manufacturing, Financial Solutions
DEMO: Enterprise Architecture Blueprint Template

DEMO: Generate an Enterprise Architecture Blueprint to discover and solve RISK

Banking, Logistics, Healthcare
DEMO: Data Mapping Software

DEMO: Generate Application Landscape for SECURITY

Automotive, Financial Services, Health Care
DEMO: Strategy Mapping Software

DEMO: Generate Strategy Map for CLOUD ADOPTION

Government, Logistics, Banking
DEMO: Process Application Map

DEMO: Generate Process Application Landscape for RPA

Retail, Agriculture, Energy, Oil & Gas