Big Data Fetching from API / external mdb

Get the original data from External source in csv or excel file and duplicate the pivot table available as shown in the excel file available in the link. I need to understand the process and need program, if it is used. [login to view URL] Tried with excel. It generates pivot table, which is linked to external mdb. There is an API. Let me know the possibilities. Once u can confirm me that u r able to fetch the data, ping me. Else, the bids are spammed. Budget:30AUD.