Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
ryandewitt
Community Manager Community Manager

Using the Excel Import Wizard

 

Using the JMP Excel Import Wizard

 

In JMP 12 for Mac and earlier versions of JMP for Windows, opening a Microsoft Excel file launches the Excel Import Wizard.

 

The Wizard is especially helpful when the structure of Excel data is irregular.

 

For example, you might want to exclude columns or convert the text in the third row to JMP column headings.

 

To open a Microsoft Excel file

 

Select File then Open.

 

Then select an Excel File file type

 

Since Excel does not have dedicated Column name labels, and it’s

pretty common to use the first row in Excel as the Column names.

We’ll want to convert this in JMP.   To convert text in the first row to column headings, select Always next to Always enforce Excel Row 1 as labels.

 

Click Open.

 

The Wizard window launches and we can see a preview of what our new JMP table will look like.

 

You can see that the Column names were created from the 1st row in Excel.

 

JMP has separate column labels as headers, which is a distinguishing feature from Excel and you need to have your 1st row in Excel labeled appropriately.

 

We can also set the Preview to update in the wizard with any changes that we make here.   This is set on by default. 

 

This option provides real time feedback and let’s adjust all options like what is the range of rows we’re importing.

 

We can cycle thru the rows in our Excel document until we find the row that we want to be the column headers, we can even set multiple rows collectively to a column header.

 

We can determine what row the data starts on, in case we have blank rows or anything else we don’t want in our new JMP data table.

 

If the first column in our excel spread sheet is not data we want, set the data to start on column 2.

 

The excel import wizard can also Concatenate and match columns if necessary.

 

Select Next for a second page of options, like what rows and columns the data ends in excel at. 

 

You can also select to suppress hidden rows or columns, or suppress empty columns.

 

When you’re done select import.

 

That’s it. Thanks for watching and enjoy using JMP.

Article Tags
Contributors