Manually re-formatting the data is an incredibly awkward and tedious process...
Fortunately, there are now some tools available which expedite the process of converting from Excel to JSON. Here are some examples:
These convert Comma Separated Values (CSV) data – which can be easily exported from Excel – to a JSON format which can be readily displayed in Google Maps.
Have a play with doing this. When you are happy, move onto Geo-coding.