Results 1 to 2 of 2

Thread: Importing HTML table in a Spreadsheet - Excel 2007

  1. #1
    Join Date
    Nov 2008
    Posts
    111

    Importing HTML table in a Spreadsheet - Excel 2007

    Hello , I am Commerce Student and keep A Record Of Lot of companies Financial Budget for Study Purpose need to Download their Tables by Saving Html Pages but i Do not find It Feasible to Use this Method. Instead I would Like to Somehow import it in Microsoft Office Excel So Can Anyone Tell Me How Can We Import HTML table in a spreadsheet - Excel 2007 ? pls help Thanks in Advance.

  2. #2
    Join Date
    May 2008
    Posts
    219

    Re: Importing HTML table in a Spreadsheet - Excel 2007

    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


    1. Open the Data tab in MS Office Excel.

    2. In the External Data section, click the Select Web

    3. 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.

    4. 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.

    5. Click on the Import button.

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

    7. The data table is then imported into Excel.


    Enjoys

Similar Threads

  1. Convert Excel data to HTML Table
    By Chalina in forum Software Development
    Replies: 2
    Last Post: 04-08-2009, 11:21 PM
  2. Create html table from excel file
    By Laler in forum Windows Software
    Replies: 3
    Last Post: 26-06-2009, 08:44 AM
  3. Replies: 3
    Last Post: 09-06-2009, 07:52 PM
  4. Importing Excel Spreadsheet
    By Theodore Long in forum Microsoft Project
    Replies: 3
    Last Post: 05-06-2009, 09:02 AM
  5. Export data from excel spreadsheet to an Oracle Table
    By Kurtz in forum Windows Software
    Replies: 2
    Last Post: 13-05-2009, 01:11 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,571,415.08357 seconds with 17 queries