|
•
|
Comma-separated (.csv)
|
|
•
|
.dat files that consist of text
|
|
•
|
ESRI shapefiles (.shp)
|
|
•
|
|
•
|
JSON (.json)
|
|
•
|
MATLAB (.m, .M)
|
|
•
|
Microsoft Excel 1997 through 2016 (.xls, .xlsx on Macintosh)
|
|
•
|
Microsoft Excel 2007 through 2016 (*.xlsx, *.xlsm on Windows)
|
|
•
|
|
•
|
Plain text (.txt)
|
|
•
|
R (.r)
|
|
•
|
|
•
|
SAS versions 7 through 9 on Macintosh (.sas7bdat)
|
|
•
|
|
•
|
SPSS files (.sav)
|
|
•
|
Tab-separated (.tsv)
|
|
•
|
|
•
|
|
•
|
xBase data files (.dbf)
|
On both Windows and Macintosh, you can open SAS data sets directly through the File > Open command. See Import SAS Data Sets for details.
Another option is connecting to a SAS server by selecting File > SAS > Browse Data. See Open SAS Data Sets through a SAS Server for details.
|
•
|
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.
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. In JMP, you can then join or concatenate the tables. For more information, see Concatenate Data Tables in Reshape Data and Join Data Tables in Reshape Data.
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.