Use the Excel JMP add-in to transfer data from an Excel worksheet into a JMP data table or to launch basic JMP analysis platforms from within Excel.
Note: Add-in is only available for Windows Operating System. A locally installed version of Microsoft Excel must be on the computer at the time of installing JMP for the Excel Add-in to be added. The add-in will not be installed if Excel is only run from a virtual environment. See Microsoft Help to learn how to install Excel locally.
If there is no JMP ribbon present after you’ve installed JMP and a local version of Microsoft Excel is also installed, then you will need to reinstall JMP. During the JMP installation process, make sure Excel Add-In is selected.
The Excel Add-In: Passing Data to JMP
This JMP ribbon will be accessible in Excel. You may need to click on the JMP tab for the JMP ribbon to appear.
- Preferences: Use to specify
- The name to use for the JMP data table;
- Whether to use the first row as column names (checked by default);
- The number of rows to use for column name (up to four can be used);
- Whether to transfer hidden rows and/or columns.
- Data Table: Send selected data to JMP. A JMP data table will be created containing the selected data.
Tips:
• If the data table does not automatically display, bring JMP to the foreground.
• Review the moeling types in JMP – variables will be assigned either Continuous or Nominal modeling types.
• JMP will recognize dates and other Excel formats.
- Graph Builder: Send selected data to JMP and launch the Graph Builder. Interactively create graphs, including line plots, splines, box plots, bar charts, histograms, mosaic plots and geographic maps.
- Analysis Platforms (Distribution, Fit Y by X, Fit Model, Time Series, Control Charts
Sends selected data to JMP and launches the chosen platform.
Visit Using JMP > Import Your Data > Import Data Using the Excel Add-in in JMP Help to learn more.