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

About Accounting Education


An educational site with 2,000+ articles, solutions, video-guides and tutorials on all topics related to accounting and finance.

Get Update on Mobile


Type svtuition.org in your mobile phone web browser for free access anytime, from any place.The content is designed specifically for cell phones and mobile devices.

Contact Us


Contact us Send an Email Phone number and vCard LinkedIn profile Follow us on twitter