Analysing and Working with a Bilateral Matrix Table in a GIS

I have a bilateral matrix table of global remittances for year 2012 from World bank where the columns contain remittance-sending country and row is the Remittance-receiving country. I want to map sending and receiving countries and the volume of money and this means cleaning up the data to geocode each location to plot origin and destination of over 420 countries. I plan to make flow maps and what I have been doing is to manually assign all receiving countries per sending country and then geocode each of this for each row. Am finding this very manual and time consuming, and am wondering if there is a more clever way of doing it. The data can be found on this world bank site below.

http://ift.tt/MOjl0q