Skip down to main content

Preparing data to create your own interactive map

Published on
24 Oct 2012
Written by
Scott A. Hale

Behind every visualization is data. After some extensive internal testing we are preparing to release a wizard to create map visualizations next week. This wizard will require the data in spreadsheet form as a Google Spreadsheet. (We’d welcome suggestions on future formats and sources). An example of the data for the current visualization on literacy is available as a Google Doc for you to view and adapt to your own data. The first two columns are required along with at least one additional column of data. The first column is a country code (e.g. ES for Spain) while the second is the label to display when this country is clicked (e.g. Spain or España). Any additional columns are custom columns to hold data to shade countries by or to display as a bar graph or text label in the right-hand panel. There is a row for each country for which data is available. If all data points are unavailable for a given country, it is safe to delete the row for the country. Lastly, it is optional to add a “world” row which is optionally shown when the visualization first loads.

So, open the spreadsheet on Google, save it to your account, and change the data to your own in preparation for creating your own map visualization next week! Lots of data that could be displayed is at the CIA World Facebook or at the World Bank if you need inspiration.

Data

Resulting Visualization (updated and slightly different from image below)

Privacy Overview
Oxford Internet Institute

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookies
  • moove_gdrp_popup -  a cookie that saves your preferences for cookie settings. Without this cookie, the screen offering you cookie options will appear on every page you visit.

This cookie remains on your computer for 365 days, but you can adjust your preferences at any time by clicking on the "Cookie settings" link in the website footer.

Please note that if you visit the Oxford University website, any cookies you accept there will appear on our site here too, this being a subdomain. To control them, you must change your cookie preferences on the main University website.

Google Analytics

This website uses Google Tags and Google Analytics to collect anonymised information such as the number of visitors to the site, and the most popular pages. Keeping these cookies enabled helps the OII improve our website.

Enabling this option will allow cookies from:

  • Google Analytics - tracking visits to the ox.ac.uk and oii.ox.ac.uk domains

These cookies will remain on your website for 365 days, but you can edit your cookie preferences at any time via the "Cookie Settings" button in the website footer.