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

September 1, 2009
Views: 63,967
PDF Download
Compatible: Enterprise, Professional, Standard, Modeler

The database design for the Computer Sales project:

Computer Sales project ERD

  1. To export the diagram as an Excel file, right-click on the diagram and select Export > Export to Excel... from the pop-up menu.
  2. Specify the path for 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 underscores (_) in the Name column and press Save.
    Update columns name in Excel
  7. Return to Visual Paradigm.
  8. Select File > Import > Excel... from the main menu.
  9. Select the modified Excel file.
  10. The changes will be listed in the Import dialog box. Review them and click OK to apply.
    Preview changes before apply import
  11. The changes are applied to the diagram.
    Applied changes in ERD
Resources
  1. ComputerSales.vpp
Related Links
Trademark Disclaimer

Oracle is a U.S. registered trademark of Oracle Corporation.