Open Data File Options

Note: For more details about opening files, see the Import Your Data topic.

To open a data file, select File > Open and select the file type. Some file types have additional features and options that appear in the Open Data File window. See Table 2.1.

Tips:

•

Windows only: To open the same file type every time, select the Select this filter the next time this window is invoked check box.

•

Open a file by dragging it onto the JMP Home Window.

•

To change which directory the File > Open command looks in, see File Locations in JMP Preferences.

Table 2.1 File > Open Options by File Type

File Type

Additional Features and Options

JMP Data Tables

Table notes, the number of columns (Cols), and the number of rows appear.

Use the Select Columns option to select which columns are imported into the data table. On Windows, click the arrow next to Open and then use the Select Columns option to specify which columns are imported into the data table. On Macintosh, you can select which columns to import after you click Open.

Excel Files

•

Import the file in the Excel Import Wizard by default to customize the layout and preview the data before you import it.

•

Click the arrow next to Open and then select one of the options. Convert the first spreadsheet row into column headings.

Text Files

•

To automatically determine data arrangement, select one of the following options:

–

Open as data using preferences

–

Open as data using a best guess