JMP enables you to import a variety of file formats and save them as data tables. By default, JMP can open numerous file types. The file formats that 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 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)
On both Windows and Apple macOS, you can open SAS data sets directly through the File > Open command. See Import SAS Data Sets.
The following file types require ODBC drivers:
• Database (dBASE) (.ndx, .mdx) is supported with a V3+-compliant ODBC driver. A .dbf file does not require an ODBC driver.
• Microsoft Access Database (.mdb) is supported with a V3+-compliant ODBC driver.
For more information for working with databases, see Import Data from a Database.
Your computer’s available memory affects data import. Very large files might load slowly or not at all. Consider splitting up large files before importing them. You can then join or concatenate the tables. See “Concatenate Data Tables” and “Join Data Tables”.
Note: You can open R code (.R) and SAS program files (.sas) in JMP, but the text opens in a Script window, not in a data table.