Main menu:

Site search

Categories

September 2007
M T W T F S S
« Aug   Mar »
 12
3456789
10111213141516
17181920212223
24252627282930

Archive

Learn to have fun again with spreadsheets

Thanks to a post I read in ResearchBuzz this week via Bloglines, I have been playing around with one of the newest features of Google Docs and Spreadsheets. It now allows you to pull in tabular data, rss feeds and list data! So no more copying and pasting from one page to another or retyping the data. It’s very neato-keen.

Here is an example I played with - where I pulled RSS data from CNN and tabular data from an article on Wikipedia. Of course there was a little bit of junk in the results but overall I thought it worked nicely. Then I could perhaps insert that nicely created table in a report I was giving - or enhance the table by making a chart out of it.

Example of Tabular Data Pulled from Wikipedia to Google Spreadsheeets

Here is the Help page for this - which gives you the low-down on all of the queries - but the article on ResearchBuzz gives some great examples as well.

Write a comment





*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word