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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.