Forum Discussion
Import data from Web
Hello, I'm after some advice regarding importing website data into excel. I'm trying to import numbers from a website that are not in tables. When I paste the website address into excel, it comes up...
Maybe that website comes with a webservice to cnnect to the data in other ways?
Thanks so much for your prompt response.
Do you mean where the source of data comes from?
I've looked into getting the source data that is displayed on the webpage but that is not possible.
- No, I mean companies sometimes offer a separate means of getting data than via their website. One technology used for that goal is called a webservice. Search the website for the keyword "webservice". If nothing comes up they don't offer that. Which precise button did you use (and in which version of Excel) to try to get the data?
There is no indication on the webpage that there is a webservice.
I tried 2 options:
Data - From Web
Data - New Query - From Other Sources - From Web
I have identified the element on the webpage using F12. Is it possible to use the location of the data on the webpage to pull into Excel?
