Excel: add country codes to a list of languages

Closed job

Recent jobs from category Jobs for students

  • no avatar
    MSStudio
    Sock design
    Proposed by freelancer
    3
    30d
    We are looking for a creative soul to design a minimalist version of Pilates-themed socks. We already have some visions, we need more of an idea artist.
  • no avatar
    maciej.sienkiewicz
    One Page Website
    Proposed by freelancer
    49
    2d
    Hi, I'm looking for someone to embrace HTML and CSS for my One Page Website. I have a prepared design - no water features. A simple headline, two pictures, with four sentences of text and that's it. The site is not supposed to scroll on a PC and is supposed to be responsive.
  • no avatar
    W pełni ja
    Creating in canva
    Proposed by freelancer
    79
    2d
    I need a person who will also apply already created texts to video on already created template in canva. I am looking for a person who can start doing this on the spot. I have about 90 micro projects to create per month
Procurence Sp. z o.o.
Procurence Sp. z o.o.
Employer
Job category:
Other
Expected budget:

Negotiable

Published:
Valid until:

Job description

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

The job in figures:

177 languages codes to link to a respective country code and to find the local name of the country