Using the Excel Import Wizard

PowerDesigner’s built-in ability to import metadata from Excel files is unmatched  by other mainstream data modelling tools. No scripting skills are required — the Excel import is aware of the underlying metamodel for the model you’re creating or updating, and suggests likely targets for your content (based on the Excel sheet and column names).


Course Topics

    • How to trigger the Excel Import wizard
    • How to create or update a model using the Excel Import wizard
    • The Excel conventions that make your life simpler
    • How to change the way the Excel Import behaves, using the Import Options
    • Importing non-standard content
    • Best practices for using Excel export and import to ‘round-trip’ content
    • How to deal with Special Cases, such as importing data types or lists of values or package hierarchies, and importing Barker notation subtype hierarchies
    • The ‘gotchas’ to look out for
    • What to do if your Excel file changes

Watch the Excel Import  Wizard create and draw a complete data model.

Click here to book this course



Access to the full course material, a glossary of terms, and all the downloadable files is available for a small 6-month subscription:


Australian Dollars Canadian Dollars Euros US Dollars
£40 $72 $44

See a free preview of the content at www.PowerDesigner.Training

  • click on Log In in the top-right corner
  • click on Log in as a guest
  • On the Home page pick the course called Sample material from “Using the Excel Import Wizard” from the list of courses. Follow the instructions to log in as a Guest

Click here to book this course

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: