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 XML and 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 Info, 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.
• 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.