Forum Discussion

Copper Contributor

Jun 13, 2020

Help automating the import and processing of JSON files

I currently receive a large number of JSON files and I need to import them into excel and process the data. Each JSON file has 3 tables to import, expand and save. Each of the JSON files has a differ...

Excel Desktop

Need Help

Abiola1

MVP

Jun 13, 2020

Hello,

You can watch the video in the link below on how to import Jason files into excel using Power Query

https://youtube.com/watch?v=CjnsX81qWUg

SteveCswc

Copper Contributor

Jun 13, 2020

Abiola1

Thanks, yes, I have watched that video and it is very informative; however, I am trying to automate that process so I don't have to go through the manual steps for every for every table within every file. So I want to do everything he did but in a 'macro' or VBA process.

Again, thanks for the response.