Do you want to enable developer ribbon and use VBA in Excel? Follow these simple steps:
Step 1: Right click any ribbon name
Step 2: Select “Customize Ribbon”
Step 3: This opens the Excel Options. From here, Check the “Developer” option in the right side panel
Step 4: Click ok.
Your developer ribbon is now enabled. You can use it to record macros, view VBA Editor and customize code. You can use the developer ribbon to access form controls or spreadsheet properties window.
See the whole process in this quick video.
Related: How to use VBA in Excel?
If you want to learn VBA coding, check out my free 4 part VBA tutorial. Learn how to write macros and build automations with VBA in Excel.
One Response to “Easily Convert JSON to Excel – Step by Step Tutorial”
Great guide! You mentioned that "Power Query in Excel offers a quick, easy and straightforward way to convert JSON to Excel." This is very true for simple structures. For those dealing with deeply nested JSON that Power Query struggles with, I've found a few tips helpful: 1) Flatten the JSON structure before importing if possible, 2) Use Python for more complex transformations as you suggested.