cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

JMP Library

Choose Language Hide Translation Bar
Importing Data

When your data are saved in a computer file that's not a JMP data table, you can import it into JMP in order to create a JMP data table. The original source file might be a text file, a Microsoft Excel workbook, or a file saved from a relational database. Whether your data are stored in a JMP data table or some other file format, you use the Open function to access your data. When you use the Open function, JMP automatically determines the file type based on the file extension at the end of the character string. The file types that JMP can recognize include text files, Microsoft Excel workbooks, Microsoft Access databases, SAS data sets and transport files, picture file s, JSON files, Python files, and HTML files. There are optional arguments for the Open function that you can use to specify the file characteristics that are different from the defaults.

Recommended Articles