Importing Data from the Web into Excel

[toanotherplace]

How do I add data to excel from the web when it is not in a table on the web?

[JoywithLastNames]

That's me, copy and paste the hard way. So I found you and this is easy to understand for how to I can be more productive and I like it that way.

[JoeL-sccy]

Fully followed and understood. Good job. Trying to take this a step further, I am trying to create a spreadsheet to track my stock market investments. I am using the Excel web version which allows me to track several different types of information on each stock. However, I would like to add RSI and other key indicators which are not available in Excel Web or Office 365. Do you have a formula that can be used to capture specific data for a specific stock (i.e. ticker info keep in A1 as an example) and automatically or manually update all RSI or whatever of the fields desired from FinViz?

[aviv]

for me it just say Document on the site im trying to transfer the data from, is there another way around it ?

[LicoInvestments]

thanks! What if i only want to extract One data point from a table?

[zzzzz]

What if want the entire WEB PAGE data to get imported in excel through this method?? How to do that??

[divyanginiforever]

How to extract data from the graph besides the table.. I played the video to know that .. but was disappointed 😞
If you can share that I will be very happy .

[y]

I just bought Excel and the ribbon doesn't look like this - and none of these steps works...

[kuroimami]

Is there a way to extract only one cell from the web's table?

[kajaltiwari]

After copying the data I'm not able to format the data