This article is part of our VLOOKUP Week. Read more.
Excel Tables, a newly introduced feature in Excel 2007 is a very powerful way to manage & work with tabular data. I really like tables feature and use it quite often. If you are new to tables, read up Introduction to Excel Tables.
In this short video tutorial I explain how to combine VLOOKUP, INDEX, MATCH formulas with Excel Tables.
Sample File
Download Example File – Using Lookup Formulas with Excel Tables
More Resources
- What is VLOOKUP Formula and how to use it?
- Using INDEX + MATCH Combination to fetch values from left
- What is Excel Tables feature and how to use it
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.