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)
Support
No technical support is provided.

How to Install

  1. Download the Plugin 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.
    Plugin installation confirmation dialog in Astah
  3. If you see [Import ER Domain from Excel] and [Import ER models from Excel] under [Tools] – [ER Diagram], your installation is complete.
    Import ER Domain and Import ER models menu items under Tools - ER Diagram

Import ER Domains from Excel

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

Import Entities and Attributes from Excel

  1. Go to [Tools] – [ER Diagram] – [Import ER models from Excel].
    Import ER models from Excel menu
  2. A dialog box appears.
    Import ER models from Excel dialog
  3. Select the file you want to import and click [Import].
    ※The supported format is the Entity Definition Report exported by Astah (from [Tools] – [ER Diagram] – [Export Entity Definition Report]) or the sample template.
  4. By default, names are imported as logical names. To import both logical and physical names, choose the second option and specify the row and column.
    Options for importing logical and physical names
  5. When the import completes successfully, a confirmation dialog opens. Click [OK].
    Import completed dialog
  6. To create an ER diagram from the imported models, select an ER model in the structure tree and click [Auto Create ER Diagram].
    Auto Create ER Diagram in the structure tree
Back to Plugin List