For the latest version of JMP Help, visit JMP.com/help.


Using JMP > Import Your Data > Import Data Using the Excel Add-In > Transfer Excel Data to a Data Table
Publication date: 11/29/2021

Transfer Excel Data to a Data Table

You can use the JMP Add In for Excel to transfer a worksheet from Excel to the following JMP destinations:

a data table

Graph Builder

Distribution platform

Fit Y by X platform

Fit Model platform

Time Series platform

Control Chart platform

You can also create models for profiling in JMP. See Excel Profiler in Profilers.

To transfer data from Excel to a JMP data table and platform

1. In your Excel worksheet, show the JMP add-in on the ribbon.

2. Click the Preferences button.

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

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

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

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

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

8. Click OK to save your preferences.

9. Select the cells to transfer into JMP, including any cells that you want to use as column names.

If you are using cells as column names, they need to be the first rows in your selection.

If only one cell (or no cell) is selected, the entire Excel worksheet is transferred to JMP.

10. Select the JMP destination from the toolbar:

Data Table

Graph Builder

Distribution platform

Fit Y by X platform

Fit Model platform

Time Series platform

Control Chart platform

JMP opens, and the selected data is placed in a new JMP data table and the selected launch window appears.

Notes:

Empty cells are imported as missing data, and dates, numbers, and strings are recognized correctly.

Your JMP windows might be hidden behind your Excel window, especially if you maximize Excel.

For more information about using the various JMP platforms, refer to the proper JMP documentation.

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