Forum Discussion
cswestwood
Jul 22, 2019Copper Contributor
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...
JKPieterse
Jul 22, 2019Silver Contributor
Maybe that website comes with a webservice to cnnect to the data in other ways?
- cswestwoodJul 22, 2019Copper Contributor
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.
- JKPieterseJul 22, 2019Silver ContributorNo, 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?
- cswestwoodJul 22, 2019Copper Contributor
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?