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


Using JMP > Import Your Data > Import XML and JSON Files > Import JSON Files Directly
Publication date: 04/30/2021

Import JSON Files Directly

A JSON file consists of name and value pairs that are imported as column headings and data. You can import a JSON files with the XML Import Wizard (Preview and Import the XML or JSON Data) or directly.

To open a JSON file directly, follow these steps:

1. On Windows:

Select File > Open.

Set the file type to JSON Data Files.

Select the file.

Select Data (Best Guess) next to Open as.

2. On macOS:

Select File > Open and select the file.

Click Options on the lower left corner of the window.

Select Data (Best Guess).

3. Click Open.

The file opens as a data table.

Notes:

The imported JSON file does not contain date, time, currency, geographic, percent, and scientific information to determine the column format. If you want to use any of these formats, right-click the numeric column, select Column Properties, and change the format in the Data Type list.

Member names in name-value pairs are case insensitive.

The JSON import code does not use the JSON file’s numeric, Boolean, or string distinction. Instead, it determines the entire column can be numeric or not. You can explicitly specify the column as character if the guess is not what you want.

For nested items, JMP repeats the outer item for each row.

The file cannot have an empty array element. The name must be quoted before the colon in the name-value pair.

The JSON standard accepts decimal numbers with decimal points.

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