Search code examples
vbaexceldata-extraction

Parsing data to tables in excel

I need to scrape the data from this page into a table format. To give you an idea, Here is what it looks like :

Final Table result

I want to see there is a way to bring this data into a table format using VBA script in excel. I can write a VBA code to do this by trimming the information into small pieces and placing it in particular cells.

I believe that's not the most efficient way and something tells me there is probably a better method out there that I just don't know off yet. Hence, I am reaching out here.

I wanted to see if you guys know of a method to do this better than trimming and pasting.

Solution

  • The data is in JSON format. You have to parse it and then decide in what way you want to present the data in Excel.

    Here it is informacion about that: