Forum Discussion
Excel - Using jSON file in excel with customization
Hi All, In my one of the project, I need to use jSON file in excel in following manner so that I can tie up its columns with excel data. For example - In my workbook there is a TAB like this .. ...
TheTallman Seems to be more appropriate to use Power Query for this. Query and parse the selected JSON file and query your Excel table. Then merge them and load back into Excel. Exactly how? That depends on your real files, and my guess is that it's going to easier than with VBA. Are you familiar with Power Query?
Thanks Riny_van_Eekelen ! I'm not familiar with Power Query and also I'm making it for end user so can we make it automate in same way as i defined .
TheTallman Can't answer that question if you don't upload realistic examples of your files, but I believe it can be made in a way that is similar to what you require.
Riny_van_Eekelen I uploaded sample files. can you please help how i can move forward with discussed approach.