For the latest version of JMP Help, visit JMP.com/help.

.dat files that consist of text
HTML (.htm, .html)
JSON (.json)
MATLAB (.m, .M)
Microsoft Excel 1997 through 2016 (.xls, .xlsx on Macintosh)
Microsoft Excel 2010 through 2016 (*.xlsx, *.xlsm on Windows)
R (.r)
SAS transport (.xpt, .stx)
SPSS (.sav)
SQLite 3.0 or higher (.sqlite, .db, .sqlite3, .db3)
Triple-S (.sss, .xml)
Database (dBASE) (.ndx, .mdx) is supported with a V3+ compliant ODBC driver. .dbf files do not require an ODBC driver.
Microsoft Access Database (.mdb) is supported with a V3+ compliant ODBC driver.
See Import Data from a Database for details for working with databases.
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.

Help created on 3/19/2020