Tuesday, 10 May 2011

Export Html Table to Excel

Posted by Unknown  
Tagged as:
02:48

If you find interesting information on the Internet in the form of a table, you can easily recover in Excel 2007 to integrate them into a spreadsheet.


  • Launch Excel 2007. Here the Tricks to Do That



  • Open the Data tab in MS Office Excel.



  • In the External Data section, click the Select Web



  • In the window that opens, type or paste the address of the page that contains the table that you want to retrieve and click OK.



  • Small yellow arrows appear next to each table detected on the page. Click on the arrow next to the table that you want to retrieve.



  • Click on the Import button.



  • Then select the cell from which the paste table. You can also choose to import a new spreadsheet. Click the OK button.



  • The data table is then imported into Excel.


  • About the Author

    Write admin description here..

    0 comments:

    Pages

    What they says

    Proudly Powered by Blogger.
    back to top