This version of the Help is no longer updated. See JMP.com/help for the latest version.

.
Publication date: 07/30/2020

Transfer Data from Excel

You can use the JMP Add In for Excel to transfer a spreadsheet from Excel to JMP:

a data table

Graph Builder

Distribution platform

Fit Y by X platform

Fit Model platform

Time Series platform

Control Chart platform

Set JMP Add In Preferences in Excel

To configure JMP Add In Preferences:

1. In Excel, select JMP > Preferences.

The JMP Preferences window appears.

Figure 3.6 JMP Add In Preferences 

2. Accept the default Data Table Name (File name_Worksheet name) or type a name.

3. Select to Use the first rows as column names if the first row in the worksheet contains column headers.

4. If you selected to use the first rows a column headers, type the number of rows used.

5. Select to Transfer Hidden Rows if the worksheet contains hidden rows to be included in the JMP data table.

6. Select to Transfer Hidden Column if the worksheet contains hidden columns to be included in the JMP data table.

7. Click OK to save your preferences.

Transfer to JMP

To transfer an Excel worksheet to JMP:

1. Open the Excel file.

2. Select the worksheet to transfer.

3. Select JMP and then select the JMP destination:

Data Table

Graph Builder

Distribution platform

Fit Y by X platform

Fit Model platform

Time Series platform

Control Chart platform

The Excel worksheet is opened as a data table in JMP and the selected platform’s launch window appears.

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).