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


Using JMP > Import Your Data > Import Microsoft Excel Files
Publication date: 11/10/2021

Import Microsoft Excel Files

Microsoft Excel files open in the Excel Import Wizard by default. The wizard shows a preview of the data. You can then modify the settings before importing the data. For example, you might indicate which row the data begin on and whether the worksheet contains column headers or hidden rows or columns. Microsoft Excel .xls, .xlsm, and .xlsx file formats are supported.

For information about opening a Microsoft Excel file outside the wizard, see Import a Microsoft Excel File Directly.

Notes:

Between Windows and macOS, the number of digits after a decimal point might differ.

Consider setting the Autosave timeout value in the General preferences to automatically save open data tables. This autosave value also applies to other JMP document types.

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