Easier to download indicators

While it was always possible to download the data files underlying the graphs in Gapminder World, we have now made it a lot easier. Each data file now has download links which allow download to Excel (xls), Open Office (ods) or even PDF files.

To access this functionality, click on the grid symbol next to the data to view the data, then click the “Download” tab. Then click the link for the desired format.

We have also improved the information about many of the indicator, including better definitions and clearer titles.

7 thoughts on “Easier to download indicators

  1. Gapminder,

    I cannot make the download function work.

    When the grid symbol at the bottom right of the indicator life expectancy at birth is clicked a grid displaying the underlying data appears. However, I can find no “download tab.” Selecting,copying, then pasting the data into Excel works, although there were a few blank rows and a misalignment of the titles.

    Is this a bug or am I doing something wrong?

    I wanted to create an Excel spreadsheet that performed a linear regression on life expectancy as a function of time. Which if any countries showed an overall decrease in life expectancy from 1950 on until 2005?

    Thank you for any help,
    Humbaba3000BC

  2. @Ola: Thanks, that is a great idea. We are currently in the process of designing a new version of the website and we will definitely include more interactive features along those line.

    @Humbaba3000BC: You have found an indicator for which the download sheet is not yet implemented. Our apologies and we will address that in the coming days. In the meantime you can simply add “&output=xls” to the end of the URL. For example, the link to download life expectancy would be:

    http://spreadsheets.google.com/pub?key=phAwcNAVuyj2tPLxKvvnNPA&output=xls

    If you are interested in life expectancy trends another interesting resource is Angus Deaton’s work on the subject which can be found at http://www.princeton.edu/~rpds/downloads/deaton_WIDER_annual-lecture-2006.pdf.

  3. Dear Humbaba3000BC,

    the download tab is now available for Life expectancy. Please let us know if you have additional problem downloading this indicator, because it should work now. We will keep implementing download for other indicators which still lack this function. In the meantime, you can follow the instructions of Claes (above) to download a file.

    Thank you for noticing things like this so we can correct them. Keep it coming!

    Klara

  4. Klara,

    Thank you for the help! The spreadsheet you gave me had exactly the right information.

    A question/request/suggestion
    What is the best way to make a subset of the nations? I would like to ask questions such as: What is the change in life expectancy for:
    all nations in the Americas
    all High income OECD nations
    or a more complex subset such as:
    what is the change in life expectancy for the 15 most populous nations
    what is the change in life expectancy for the 15 richest nations

    I can do this by downloading the necessary data sets into Excel and creating the appropriate links however this is somewhat inconvenient.

    I show GapMinder to everyone I know that has any interest in sociopolitical issues or computers. They are all impressed and many of them are starting to use the software for their own explorations.

    Keep up the good work,
    Humbaba3000BC

  5. Dear Humbaba3000BC,

    we will soon have a longer dataset for life expectancy. I hope to upload within a few days. Wait for a notice here on the blog.

    Unfortunately, choosing to look at subsets of countries /territories is not an available feature in Gapminder World. We have this on our “features suggested” list.

    Klara

  6. Klara,

    Thank you for your response. I look forward to playing with the longer dateset for life expectancy.

    Humbaba3000BC

Comments are closed.