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 (.m, .M)
Microsoft Excel 1997 through 2011 (.xls, .xlsx on Macintosh)
Microsoft Excel 2007 through 2013 (*.xlsx, *.xlsm on Windows)
Minitab Portable Worksheet (.mtp)
Plain text (.txt)
R (.r)
SAS transport (.xpt, .stx)
SAS versions 7 through 9 on Macintosh (.sas7bdat)
SAS versions ...

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

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