In addition to the native JMP File Types, JMP also supports importing additional file types that are industry standards or from other software products. For more information on data import, please see the JMP Help section on About Importing Data.
Below is a list of supported file types JMP can import 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 2019 on Apple macOS (.xls, .xlsx)
- Microsoft Excel 2010 through 2019 on Windows (*.xlsx, *.xlsm)
- Minitab Portable Worksheet (.mtp)
- Plain text (.txt)
- R (.r)
- SAS transport (.xpt, .stx)
- SAS versions 7 through 9 on Apple macOS (.sas7bdat)
- SAS versions 7 through 9 on Windows (.sas7bdat, .sas7bxat)
- SPSS (.sav)
- SQLite 3.0 or higher (.sqlite, .db, .sqlite3, .db3)
- Tab-separated (.tsv)
- Teradata database (.trd)
- Triple-S (.sss, .xml)
- xBase data files (.dbf)
- XML data files (.xml)
If you need additional help with importing data into JMP, please contact JMP Technical Support.