Using JMP > Import Your Data > Import Microsoft Excel Files
Publication date: 08/13/2020

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 and the date format of imported data might differ. For example, “10/25/2012” might be formatted as “25Oct2012” on macOS. Columns might be imported as character columns on macOS but not on Windows.

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).
.