Sample Data to Use in Excel

If you’re doing Excel training, or writing blog posts, or creating sample files, you might need to find some public data to use in your Excel file. You don’t want to publish confidential client data, even if it’s a bit disguised, or reveal your household finances to the world.

Instead of creating sample data on your own, you can find datasets online. Once source is Google Public Data Explorer (part of Google Labs), where you can access several large datasets, and use those in your Excel example files

Datasets00

When you follow the links to the dataset pages, you’ll find interactive charts and maps, and links to the source data websites.

Source Data Pages

Of course, each source data website is set up differently, but on some of the source data websites, you’ll find more charts and interactive tables, and files that you can download.

Datasets03

Sample Excel Data for Download

For example, you can download Excel files with economic, environmental and social statistics from the OECD Factbook 2010, published by the Organization for Economic Co-operation and Development.

Datasets01

To see how it worked, I downloaded an Employment rates file with several years of data, for three age groupings. That would give you enough data to use for your own sample charts or training exercises.

Datasets04

Other Data Sources

Are there other good sources of public data that you use? Please share them in the comments. Thanks!

______

You may also like...

12 Responses

  1. karimmo says:

    I would recommend http://www.worldbank.org/data. It provides simple but nice tool for online analysis (dashboard like style) but downloading raw data is provided in xls and xml.
    There is also Google site: http://www.google.com/publicdata/ with several sources (World, EU and US) and online tool for charting and mapping.

  2. karimmo says:

    Ups… I somehow missed the first part of your post where those sources ‘ve been already provided
    :-)

  3. ikkeman says:

    Every number you ever wanted to know – And oh so many more – about the Netherlands, in English

    http://statline.cbs.nl/StatWeb/dome/?LA=EN

  4. JP says:

    If you include public APIs, the amount of data is endless. You can get sports stats, weather data, and so on. It depends on what formula or function you’re trying to demonstrate.

  5. Doug Glancy says:

    I’ve found some nice big files, suitable for breaking into multiple tables, at http://www.data.gov/raw. One was a list of all FEMA public assistance grants for disasters going back to 1998.

  6. chip says:

    A college friend is now a stats professor and he provides sample data on his class website: http://www2.stetson.edu/~jrasp/data.htm

    Some fun to work with information there for teaching calculations and graphing but also stats (obviously.)

    Also, excel lists of the “top 3000 songs of all time” and top 300 albums. Can use for pivot tables, graphs across time, etc.

    http://www.acclaimedmusic.net/

    This gives you some data to work on that people tend to have fun exploring. (And arguing about.)

  7. @karimmo, no problem! Thanks for sharing the links

    @ikkeman, @JP, @chip, @Doug Glancy, thanks for the links. Those should keep us busy for quite a while.

  8. Mike Seymour says:

    This site has got a lot of good data, they also have some excellent visuals using the data.

    http://www.gapminder.org/data/

    Regards

  9. Thanks Mike, that looks like a great source of data.

  10. dan l says:

    Every US state + the feds have an unemployment office. They all have different cuts of something called ‘LAUS’ or Local Area Unemployment Statistics.

    I find that it lends itself really well to being dummy data.

  11. Thanks dan I — that another good idea.

  12. Partho Sarkar says:

    Thanks for this great page (I know I am a bit late to find it!). I recently wanted to teach a young friend the basics of Excel, and found it very useful.

    Btw, here is another page with various kinds of data I found: http://mathforum.org/workshops/sum96/data.collections/datalibrary/data.set6.html
    (The page has a data library & links to other sources too)

Leave a Reply

Your email address will not be published. Required fields are marked *