Excel: add country codes to a list of languages

We need to show a country flag next to a language in our system, but we only have the ISO language codes.

We have an Excel file that contains a list of LANGUAGE CODES with languages and for each of the 177 entries we need a corresponding ISO-2 country code to be able to show a COUNTRY FLAG next to the language name.

In case there is no matching flag --> e.g. English-Carribean (not one country) then use xx code instead.

In case the language does not contain a country code, then use the most likely country - eg. en --> gb (to show british flag for english). In case the language is used in multiple countries (like afrikaans) use the largest country/most likely country)

In case there are doubts, you can add comments in a separte colums for us to decide.

e.g.

af Afrikaans ---> za

en-au English - Australia ---> au

en-bz English - Belize --> bz

en-ca English - Canada --> ca

en-cb English - Caribbean --> xx

en-in English - India --> in

You have the list of country codes here:

https://www.iban.com/country-codes

List of language codes:

https://en.wikipedia.org/wiki/List_of_ISO_639-1_codes