Import ER models from Excel

Import Entities, Attributes and Domains for ER Diagrams directly from Excel.

   Versions





   How to Install

  1. Download the Plug-in file by clicking the blue Download button at the top of this page.
  2. After the download is complete, drag the downloaded .jar file to an open instance of Astah. A pop-up will appear asking you to confirm installation, choose [Yes].

  3. If the pop-up below opens, restart Astah.
    astah plugin menu
    The [Plugin] menu exists in version 7.2 or later. if you are using version 7.1 or earlier, read this FAQ.
  4. If you see the [Import ER Domain/models from Excel] option under [Tools] - [ER Diagram], your installation is complete!
    ER Models Excel Import

   Import ER Domains from Excel

  1. Go to [Tools] – [ER Diagram] – [Import ER Domain from Excel].
    ER Models Excel Import
  2. A dialog box appears.
    ER Models Excel Import
  3. Select a file you want to import and then click [Import].

  4. The supported format is the Entity Definition Report exported by Astah (Export one from [Tools] – [ER Diagram] – [Export Entity Definition Report] or download template).
    If you customize the format, you will need to specify the rows and columns to import items correctly.

   Import Entities and Attributes from Excel

  1. Go to [Tools] – [ER Diagram] – [Import ER models from Excel].
    ER Models Excel Import
  2. A dialog box appears.
    ER Models Excel Import
  3. Select the file you want to import and then click [Import].
    The supported format is the Entity Definition Report exported by Astah (Export one from [Tools] – [ER Diagram] – [Export Entity Definition Report] or download template).
    By dafault, it imports as logical name. If you'd like to import both logical and physical names, choose the second option and specify the row and colum.
    ER Models Excel Import
  4. When import completes successfully, a confirmation dialog opens. Click [OK].
    ER Models Excel Import
  5. To create an ER diagram with imported models, select a ER Model in the structure tree and click [Auto Create ER Diagram].
    ER Models Excel Import