There is a site that outputs 1,000,000 single cell rankings on a daily basis (.csv). These rankings change on a daily basis. This csv file only has two things: the numbered ranking, and the name of the item.
I want an automated way to crunch this data in the following ways:
1. Find new additions to the list.
2. Biggest gainers and losers in terms of rankings. (so this process will involve yesterday's list)
I have servers available to crunch data (mysql) and would prefer this process be done there rather than a macro/script that crunches this on my desktop.
I would like the results to be outputted into excel format.