Excel: add country codes to a list of languages

Closed job

Recent jobs from category Jobs for students

  • no avatar
    fabryka_naukowcow 12 deals
    Roblox - instructor/class instructor
    Proposed by freelancer
    4
    14d
    We are looking for a person to lead online classes for children in Roblox. We are looking for a person who is responsible, punctual, well versed in the world of Roblox and who enjoys sharing knowledge and has experience working with children. An open-minded, communicative person who can impart knowledge in an interesting and engaging way and is great at problem solving and working under time pressure. Classes are in the form of a course (15 meetings x 1.5 h), held in the afternoon and on weekends. Classes conducted according to detailed lesson plans. If interested, please send information on: - knowledge of Roblox - experience in working with children/youth - availability - expected remuneration for classes/courses Information from Useme: Settlement of the execution of this order will be possible for those who have: - valid student or school ID (up to 26 years of age); - employment on the basis of a contract of employment or commission (with at least minimum wage); - own business activity.
  • no avatar
    M brands sp z o o Daktyli.pl
    Company Description daktyli.pl is Poland's largest online seller of fresh dates. As we continue to grow, we are looking for a reliable Junior Orders Fulfillment Associate to join our warehouse team. This role is key in ensuring that customer orders are packed, labeled, and shipped efficiently. Location: [Warsaw - Metro Bródno] Job Type: Part-time (4 hours per day) +\- Working Hours: 8:00 AM - 12:00 PM Role Description This is a role for a Junior Orders Fulfillment Associate at Daktyli.pl. The role involves tasks such as packing, unloading, sorting, and basic computer skills to generate shipping labels and request courier pick-up. Qualifications Packing, Unloading, and Sorting skills. Ability to communicate in Polish and English. Attention to detail and accuracy in order fulfillment. Reliable and punctual, starting daily at 8:00 AM. Able to lift and move packages up to 20kg. Previous experience in a similar role is a plus, but not required. Compensation: This position pays per hour at the minimum wage rate in Poland, in accordance with local labor laws. We will cover your monthly public transport card. How to Apply: Please send your CV in English. Information from Useme: The settlement of this order will be possible for people: - who have a valid student or school ID (up to 26 years of age); - who are employed on the basis of an employment contract or a contract of mandate (with at least the minimum wage); - who run their own business.
Procurence Sp. z o.o.
Procurence Sp. z o.o.
Employer
Job category:
Other
Expected budget:

Negotiable

Published:
Finished

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