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

Get Using JMP 12 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.