How to import Wikipedia's Finance and business tables in Google Docs
>> May 13, 2009
Wikipedia is a very large scale world level collaborative writing project and there are large number of business , finance and accounting data in form of tables you can find in Wikipedia which can be benefited for you . Some days ago , I needed International Monetary Fund's Member's Voting power list for my finance project which I have found in wikipedia in updated form . So , I have tried it to import in My Google Docs file . Here I am giving you the tutorial of how to import Wikipedia's Finance and business tables in Google Docs .
Google docs provides the facility of loading and importing html files and its table with import formula and so we will do all work with just this formula .
First of Copy the URL of Wikipedia in which your finance table is situated and every para in wikipedia is deemed as wikipedia's table no. and , I found my table at 4 no. it also remember .
Then sign in Google docs with google id and password and then click to new spreadsheet
in the first row , put the formula
= ImportHtml("paste the URL of Wikipedia","table",write the table no.)
and after this press enter and you will find Wikipedia's table in Google docs .
Now you can also republish or share anywhere .
I have imported Wikipedia's IMF member Voting Table in Google Docs which is embed following for instance .
You might like:

0 comments:
Post a Comment