Fill in Country Data from Wikipedia

This project was successfully completed by Ibrahim185 for $100 AUD in 4 days.

Get free quotes for a project like this
Project Budget
$30 - $250 AUD
Completed In
4 days
Total Bids
Project Description

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.

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online