Using JMP > Import Your Data > Import Multiple Files

Publication date: 07/08/2024

Import Multiple Files

Multiple File Import (MFI) imports files from one directory and stacks them in a data table or imports them in separate data tables. You can save the import settings as a script and then run the script when the data is updated in the future.

Multiple File Import supports the following file types:

• XLS

• XLSX

• XLSM

• CSV

• TSV

• DAT

• TXT

• SAS7BDAT

• XML

• JMP

• JSON

• PNG

• JPG

• GIF

• PDF

Multiple File Import can also import only one file. Table 3.3 can help you decide whether to use the standard Text Import, Multiple File Import, or JSL.

Table 3.3 Choosing Between the Text Import Wizard and MFI
Import Characteristics	One File	Multiple Files
CSV, TSV, DAT	Text Import has a preview wizard to help name the columns, pick date formats, and subset the data.	MFI can stack similar files automatically. You can change formatting later.
Unstructured text	MFI, possibly in JSL with Load Text File().	MFI
Large files over 100MB	You can use the Source script from a previous Text Import to speed up the next import.	MFI imports in parallel and might be much faster than Text Import.
Unsure about format	Text Import might be able to guess. The preview wizard lets you see the results before the text is imported.	MFI does not guess. You specify the tab delimiters. There is no preview, but select Keep dialog open, and it is easy to try different import settings.
Pictures	Try the JSL Open() function.	MFI understands PNG, JPG, and GIF files. You will get a table with a picture column.
JMP, XLSX, and JSON	Try the JSL Open() function.	MFI opens JMP, XLSX, and JSON files using JSL Open() and will stack them if requested. MFI does not keep the table and column scripts when it opens JMP tables, so you might need to use Files In Directory() and Open() if you need all of those scripts.

To import multiple files, follow these steps:

1. Place the files that you want to import in the same directory.

This example uses import data found in the JMP Samples/Import Data folder.

2. Select File > Import Multiple Files (Windows) or File > Open Multiple (macOS).

3. Browse to select the JMP Samples/Import Data folder.

4. In the Select Files by name or extension box, type UN*.csv and press Enter.

In this example, the files have the UN prefix and are CSV files.

The Files list updates to show which files have been selected.

Specify multiple file names and extensions by separating them with semicolons, or click Add Extension and select an extension.

Figure 3.19 Selected CSV Files

Selected CSV Files

Notice that the Refresh button Image shown here flashes if the files have changed in the directory since the last refresh.

5. Specify the columns that you want added to the data table.

By default, no extra columns are added. You might like a File Name column to show the names of the imported files. Select Add file name column.

Note: The Text Data Files preferences do not determine which options are selected in the CSV settings, although the settings are similar.

6. Keep Stack Similar Files selected because these CSV files have the same columns.

7. Click Import.

JMP applies the file name, file size, and file date and time filters to stack the files. Data with columns that contain the same column headings are imported in the same data table. If the columns do not match, the mismatched columns are imported into a separate data table.

Figure 3.20 Imported CSV Data

Imported CSV Data

Notes:

• To import hidden files, select Include hidden files.

• To import files that are in subdirectories, select Include subfolders.

• To import files in a certain size range, in the Select files by size box, type the lower and upper file size limits.

Consider specifying the limits if you don’t want to import large files over a certain limit.

Specify file sizes in KB (kilobytes). One KB equals 1,000 bytes.

• To import files that were modified during a certain date and time range, in the Select files by date and time box, click the calendar button Image shown here to specify the range.

• (Unstructured text files) Select Text, Whole File on One Row or Text, One Line Per Row based on how the file is structured.

Notes:

– These two options are not supported for XLSX, JSON, and JMP files.

– When you select Text, Whole File on One Row, the import includes the whole file and does not skip lines before the first data line.

JMP creates a data table that lists the files that could not be imported (for example, SAS datasets).

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).