Convert JSON to Excel - Microsoft Excel Power Query

#jsontoexcel #microsoftexcel #excelpowerquery
Convert JSON to Excel - Microsoft Excel Power Query

In this video let us see how to use Microsoft Excel Power Query to convert the JSON data to an excel sheet.

Most of the time while working with data, we may have the scenario to convert JSON data to excel format, the first option to consider is converting through online tools but this is not the recommended option if the data is sensitive, the other option is using some tools or apps, some of the tools required licensing to use it also unknown external tools may not be the recommended option for sensitive data.

Power Query for Excel is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources, and a Power Query Editor for applying transformations. Power Query for Excel supports hundreds of data sources with built-in connectors.

Power Query can be used to convert JSON data to an excel sheet.

[jobythomas]

Explanation with a suitable example. Really great.
Thank you.

[dennisdsebastian]

Thanks. It helped me. One point, if your excel has no 'From Json' option as mine, you can still do it by Data->New Query -> From File -> From Text and then select the json file and you will get the power query window.

[JobQuestUnveiled]

Sorry but I don't have <-- |--> option to expand my records. What should I do?

[nickfiek]

Got me going. Nothing made sense before. Afterwards, I loaded the JSON data I sought. A few mis-steps as I figured out when to expand a cell's list to rows, and when to use comma-separated values in a single cell.

[indrajitm]

Hi, I am not getting the expand (button) after converting it to table.