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!

______

12 comments to Sample Data to Use in Excel

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>