This article walks through creating a DSN for JSON services in iODBC and accessing JSON services in Microsoft Excel, all on a machine running Mac OS X. The query editor will close and the data will appear as a table in Excel.Microsoft Excel features calculations, graphing tools, pivot tables, and a macro programming language that allows users to work with data in many of the ways that suit their needs, whether on a Windows machine or a Macintosh machine. Step 3: Bring the Table Back Into ExcelĬlick Close and Load to bring the data back into Excel as a Table.

Select the columns you want Excel to make use of and then click OK. Click the arrow icon to expand the table. To do so, double click the name and type a new one. You may want to rename the table before doing this. Click the icon with two arrows pointing away from one another to expand the table.

Once you have the list as a table, you need to specify which columns you want excel to make use of as well as have the opportunity to specify how any inner lists (array fields) may be dealt with. Click “To Table” to convert the list to a table. One you have found the list you are looking for, the list needs to be converted to a table for Excel to use. Click through the record to see what’s inside Once you find the list, go ahead and click it to open it. Click through any single records until you find a list. This should fetch the file and bring you into the query editor. To do this, instead of clicking “From JSON”, click “From Web” and enter the URL. If you are using a web API, you may choose instead to import the data directly from the web. This should bring you into the query editor. Find the file on your disk and click Import. When clicking “From JSON”, you will be presented with a file browser. Step 1: Open The Data in the Query Editor

Load json into excel