How to use data retrieved from a web API?

I have a simple concept where I want to retrieve a table from a website and use it in that exact format. This can be for example imported into Excel. This is the website that I want to get the table from: http://www.dota2.com/leaderboards/#europe

This is the API that the website uses to get the data: http://www.dota2.com/webapi/ILeaderboard/GetDivisionLeaderboard/v0001?division=europe

In all the ways I attempted to get the data from the website, it is poorly formatted into one line, and I was wondering what is the best way to format/use this data through code or other tools available. I have tried:

-Excel web importing

-Writing a simple VB program to read each line (but it reads it all as one line)

-Copy and pasting the table to Notepad to try format it by line(still one single line)

Any tips/suggestions regarding any form of website data retrieving is very much appreciated.