Jump to Menu

Exporting Database Design to Excel for Mass Editing

Sometime, we need to perform large scale modification or validation of database design. While the diagramming interface is good for designing and understanding database design, it's not efficient enough for performing large scale changes. This tutorial shows how to export ERD to Microsoft Excel file, modify the Excel and import it back to the ERD.
Topics
1. Export ERD to MS Excel file
2. Make changes in Excel
3. Import Excel file back to ERD

Compatible edition(s): Enterprise, Professional, Standard, Modeler

  • September 1, 2009
  • Views: 53,520
  • PDF

The database design for the Computer Sales project:

Computer Sales project ERD

  1. To export the diagram as excel, right-click on the diagram, and select Export > Export to Excel... from the pop-up menu.
  2. Specify the path of the Excel file.
    Specify file path for export to Excel
  3. Select Model Type Per Sheet as the Export Style.
    Specify style on export to Excel
  4. Open the exported file.
  5. Open the Entity sheet.
    Entity exported per worksheet in Excel
  6. Remove all the _ in the Name column, and press Save.
    Update columns name in Excel
  7. Back to the Visual Paradigm.
  8. Select File > Import > Excel... from the main menu.
  9. Select the modified Excel file.
  10. The changes are listed in the Import dialog box. Review them and click OK to perform.
    Preview changes before apply import
  11. The changes are applied to the diagram.
    Applied changes in ERD


Trademark Disclaimer

Oracle is U.S. registered trademark of Oracle Corporation


Turn every software project into a successful one.

We use cookies to offer you a better experience. By visiting our website, you agree to the use of cookies as described in our Cookie Policy.

OK