Opening Excel Files in the Worksheet Design Window

This section describes the Worksheet Design window.

You can open an Excel worksheet in Worksheet Design via one of two ways:

• Drag the Excel worksheet into Monarch Data Prep Studio and select Yes when the Excel Import Options dialog displays:



 

• Go to Open Data > Spreadsheet > Excel Worksheet Design in the Start page or Add > Spreadsheet > Excel Worksheet Design in the Prepare window.

Notes:

• If you open a password-protected worksheet, Worksheet Design displays the Enter Password dialog:



 

You will need to enter the correct password before you can proceed.

• Worksheet Design displays all fields, including fields that are hidden in the worksheet.