Taking numbers off a website and importing them into Excel? Possible?

  • Thread starter Thread starter DrSues02
  • Start date Start date
D

DrSues02

I have Excel 2000, and I don't see any of the arrows that you ar
talking about. When I input the website name, it takes me to an Exce
sheet with all of the numbers from the website. Although I guess I ca
make this work, it has none of the formatting or tables that ar
associated with the website and is very rough.

Is there a way to ONLY get the data from that particular table from th
website instead of the entire website, and then import just that dat
into Excel?

DrSues0
 
Have you gone to the website by going through the import external dat
option and select new web query??

Not sure about excel 2000, but it should bring a window up and this i
where you enter the website address this takes you to the desire
website and you can select the desired bits of data by selecting th
yellow arrows, it works for me no problems and just brings up th
table on its own with all the numbers in it nice and nea
 

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

Taking numbers off a website and importing them into Excel? Possible? 1
Converting Text String to Separate Numbers 1
Importing Excel file into Outlook 1
Help with importing pictures from hyperlinks 14
Printing from website to Excel 3
Display one number in a cell even though 2 numbers get pasted into the same cell? 2
excel, hyperlink or macro to a website 1
Importing data from Website - Newbie 13

Back
Top