In my old job, I often had spreadsheets with (sometimes misspelled) country names, but I needed to feed data into something with country codes, be it ISO-2, ISO-3, OECD, AidData, whatever kind of code.
Finally, I hammered out a little web app with Ruby’s Sinatra web framework to help with this problem. You can upload a (small- or medium-sized) CSV spreadsheet and it will:
- Identify unique country names
- Allow you to pick which kinds of codes you need
- Suggest matches
- Allow you to add new matches (in case it doesn’t have your country name already)
- Allow you to download your spreadsheet.