Hi,
I would like to convert a json file with a list of Skype chats to an excel file. I did the following:
I opened Excel to the Data tab and navigated to Get Data > From File > From JSON.
I selected the json file > Excel then opens the Power query editor > i selected "to table"
Excel then created a table with 2 columns and 3 rows. The cel in the second column and third row states "list". When i click on this cel there appears a list on the lower side of the screen, as shown in the screenshot.
What di i need to do in order to create the excel file with all the Skype conversations to be visible in a table?
Any input is much appreciated!
Bookmarks