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 with lots of errors and won't even preview the webpage. The first error is JSON is undefined. If I close this it comes up with more errors about the content. I have attached a picture of the content of the webpage which is on an internal system. I thought the issue might be that the boxes on the webpage are expandable if you click on them?
Any advice would be greatly appreciated.
9 Replies
- 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?
