Importing from web page

  • Thread starter Thread starter Amy
  • Start date Start date
A

Amy

Can anyone help?

How do you import a table from an HTML file (Web Page)
onto an excel worksheet?

Thanks in advance.
 
-----Original Message-----
Can anyone help?

How do you import a table from an HTML file (Web Page)
onto an excel worksheet?

Thanks in advance.
.
Amy
Click to expand...
1. Display the worksheet upon which you wish to import the
table, Then

2.Choose Data...Get External Data....New Web Query from
the menu bar, then

3.Enter the filename of the HTML file; or click Browse Web
to display the desired web page from the web with Internet
Explorer and click the Excel button on the Windows taskbar
to return to the excel window.

4. Choose the import options you wish to use; then click
OK.

5.Click the cell where you wish to import the data and
click OK.

Griselda Quintero
Please respond if this helped.
Thanks
 
-----Original Message-----

1. Display the worksheet upon which you wish to import the
table, Then

2.Choose Data...Get External Data....New Web Query from
the menu bar, then

3.Enter the filename of the HTML file; or click Browse Web
to display the desired web page from the web with Internet
Explorer and click the Excel button on the Windows taskbar
to return to the excel window.

4. Choose the import options you wish to use; then click
OK.

5.Click the cell where you wish to import the data and
click OK.

Griselda Quintero
Please respond if this helped.
Thanks
.
I got what I wanted Thanks.
Click to expand...
Amy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to import web link and avoid frame? 3
How to insert web page content into excel worksheet? 1
Importing data from Excel worksheet into Excel template 2
Excel web query does not import table (from yahoo finance) correct 2
Import Multiple CSV Files from Same Folder into Open Workbook 5
Importing From web page 1
How do I get rid of an embedded link in an Excel worksheet 1
Import Txt file over several excel sheets 2

Back
Top