About Importing Data to JMP
You can import many file formats into JMP and save them as data tables. JMP opens many files by default. The file formats which JMP does not support by default require specific Open Database Connectivity (ODBC) drivers.
The Following File Formats Are Supported by Default:
Comma-separated (.csv)
.dat files that consist of text
ESRI shapefiles (.shp)
Flow Cytometry versions 2.0 and 3.0 (.fcs)
HTML (.htm, .html)
MATLAB Portable Worksheet (.mtp)
Microsoft Excel 1997–2003 (.xls)
Microsoft Excel 2007 through 2013 (*.xlsx, *.xlsm) (Windows without an ODBC driver installed)
Minitab worksheets (.mtp)
Plain text (.txt)
R (.r)
SAS transport (.xpt, .stx)
SAS versions 7–9 on Macintosh (.sas7bdat)

Get Using JMP 11 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.