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)
• Hierarchical Data Format, Version 5 (.h5)
• HTML (.htm, .html)
• JSON (.json)
• MATLAB (.m, .M)
• Microsoft Excel 1997 through 2016 (.xls, .xlsx on Macintosh)
• Microsoft Excel 2007 through 2016 (*.xlsx, *.xlsm on Windows)
• Minitab Portable Worksheet (.mtp)
• Plain text (.txt)
• R (.r)
• SAS transport (.xpt, .stx)