Import ER from Excel

Import ER models from Excel to Astah all at once.

Details

Compatible with
Astah Professional 7.1 and later
Latest Version
1.2.0 (July 22, 2019)
Developer
Astah
Support
No technical support is provided.

How to Install

  1. Download the Plug-in file.
  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]. If the pop-up below opens, restart Astah.
    Astah Plugin Install
  3. If you see the [Import ER Domain/models from Excel] option under [Tools] – [ER Diagram], your installation is complete!
    ER Data Import options

 

 

Import ER Domains from Excel

  1. Go to [Tools] – [ER Diagram] – [Import ER Domain from Excel].
    Import ER Domain
    ※The supported format is the Entity Definition Report exported by Astah (from [Tools] – [ER Diagram] – [Export Entity Definition Report] or sample template. If you customize the format, you will need to specify the rows and columns to import items accordingly.

 

 

Import Entities and Attributes from Excel

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

 

What are you looking for?