Import Microsoft Excel Files

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

Using JMP • Import Your Data • Import Microsoft Excel Files

•

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:

•

Password-protected Microsoft Excel files cannot be opened in JMP.

•

Between Windows and Macintosh, 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 Macintosh. Columns might be imported as character columns on Macintosh 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.

•

Help created on 7/12/2018