Converting a JSON File to Excel

Article: https://www.howtogeek.com/775651/how-to-convert-a-json-file-to-microsoft-excel/

Video: https://watch.screencastify.com/v/XkKAO1INKNiSbOr4Tau1

To convert your JSON file to Excel:

1. Connect Excel to your JSON data
2. Review the JSON data
3. Select the columns you’d like to bring to your Excel file
4. Load the data into an Excel spreadsheet
5. Save that spreadsheet as an XLSX file.

To Import a JSON File into an XLSX File:

1. Open Microsoft Excel
2. Start a new spreadsheet
3. Click Data tab in Excel's top ribbon:

4. Select Get Data > From File > From JSON from Get & Transform Data section:

5. In the standard Import window, open the folder where your JSON file is located
6. Double-click the file to connect it to Excel:

7. Excel will open a “Power Query Editor” window. Here, you will decide how JSON’s data will be loaded in your spreadsheet. First, at the top of the window, click To Table. This turns your data into a table:

8. In the To Table prompt, click OK:

9. Choose which columns to keep in your spreadsheet. Next to Column1, click the double-arrow icon:

10. In the menu that opens, choose the columns you’d like to keep
11. Deselect the Use Original Column Name as Prefix option
12. Click OK:

13. Your JSON file’s data is now visible in Excel-style columns and rows.
14. Add your JSON data to your Excel spreadsheet: click Close & Load in the window’s top-left corner:

15. Your Excel spreadsheet now has your JSON data in it. You can play around with this data however you want.  
16. Save this JSON data in Excel format.