Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock (
) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
and USDA
JSON, or JavaScript Object Notation, is a commonly used format for passing data to and from web APIs. While some software work well with JSON, you may wish to convert this data to a spreadsheet for easier viewing, manipulation, and analysis. This guide walks through converting DSID API results from a JSON file to an Excel sheet.
Disclaimer: This guide is specific to the JSON data structures used for the DSID API and will not universally convert any JSON file.
Open an Excel file. It does not need to be blank since this process will create a new sheet.
Go to the Data tab → Get Data → From File → From JSON
Browse and select the JSON file you want to convert. This will open the Excel Power Query Editor.
In the Power query editor, click the “To Table” button in the top left.
Then in the “To table” popup, leave the options as-is and click OK.
Click the 
symbol to expand the table columns.
Uncheck the bottom checkbox “Use original column name as prefix” and click OK.
You should now see the expanded columns of the API results, with one row per query in your request.
Click “Close and Load” in the top-left to move this data into your Excel spreadsheet and exit the Power Query Editor.
Your results should appear in their own Excel sheet, which is named based on the filename of the JSON file you selected (i.e. output_file.json creates a sheet called “output_file”).
