Fill in Country Data from Wikipedia

In Progress

I have a Google Sheets data set with 257 countries listed in the rows. The first 21 are already completed. All information is to gathered from [url removed, login to view], and everything can be copy/pasted from there. There are 22 columns of data that are empty, and need to be populated with data like population, major religion, language, and also three that are html links form [url removed, login to view] (e.g Right click on map, copy URL and paste URL into sheet.). It is acceptable to leave blank data that is not available on that Country's [url removed, login to view] page (occasionally the HDI rating, or rank or similar things are not available.) It takes me under 3 minutes to do each country, therefore 13 hours of work. Prefer Google user, who can share the Sheet so that I can check progress is satisfactory

Some rules of thumb for working through tricky categories.

- some countries don't fit nicely into Region category - just pick the closest.

- Population rank is in blue after population, and sometimes missing

- The Premier is the highest ranking government official, not appointed by a monarch (e.g. the Prime Minister, President, etc. or King/Prince in monarchies, ignore Governor general and British Queen of Commonwealth countries)

- National Anthem (Not national song, motto, or royal Anthem) is in local language, not English Translation.

- Bordering countries usually found in first paragraph of article, just copy the description, including directions.

- If no national language, use official language and vice-versa, if multiple national languages, just put the first one.

- Take care to recalculate GDP values if not in billions (i.e. 450 million should be [url removed, login to view] in the GDP_billions column)

- calling code without the plus sign (does funny things to spreadsheets otherwise.)

- right click on flag and map to copy URL

- If national anthem is available, click on menu, share icon (3 people) and copy the "Embed on page" code

- Religiosity is usually found further down in the article. Use a quick search, or find the short cut to religion.

Skills: Data Entry, Excel, Web Scraping

See more: work for wikipedia, rules icon, rating country, rating by country, rank of country, ranking of country, ranking countries, ranking by country, rank country, rank by country, national general, is one a prime, i need a wikipedia page, icon the king of, highest ranking, government Data, funny categories, first commonwealth, find wikipedia, find language and translation, data government, data entry form without excel, country rating, country ranking, countries rating

Project ID: #4878654

Awarded to:


ready to start

$100 AUD in 4 days
(34 Reviews)

8 freelancers are bidding on average $158 for this job


I’m posting the bid as an expression of interest and appreciate further discussion in private message board.We are waiting for your message to communicate further in this regard.Thanks

$206 AUD in 4 days
(212 Reviews)

Hi My name is Neha from The AeroDynamic Team based in UK. We are experts in high end Internet marketing, Web designing, SMM, SEO, Data entry, Article writing, Web scrapping, Virtual assistant, Fan page designing More

$144 AUD in 3 days
(22 Reviews)

Hi, I'm proficient in web scraping and Excel and I'm able to provide you great accuracy for this project. Please check out my previous reviews and let's start a collaboration with mutual benefits. Thanks.

$140 AUD in 5 days
(14 Reviews)

Hello I'm really able to do this job Best

$189 AUD in 2 days
(3 Reviews)

I'm excited to work on this project! I follow instructions really well. Please contact me for the assignment, which I want to deliver in three days top.

$222 AUD in 3 days
(0 Reviews)

I am interested in this project.

$166 AUD in 3 days
(0 Reviews)

Experienced web searcher and data scraper Looking forward to working with you!

$99 AUD in 4 days
(0 Reviews)