How to get specific data from web page in a specifiv format in excel?

Question

Hello I am trying to data scrape from web page, that requires inputing order ID, after which I face an issue where I get only the last data that was selected into excel and rest disappears. Also Data is put in horizontally in excel instead of Vertically on Excel ..... How can I fix these issues?

Answer 1

Hi @Sathi R Karri,

How did you get the data from web? Did you use From Web or Power Query to import Web data to Excel?

I suggest you refer to this support article and try the method to import Web to Excel:

https://learn.microsoft.com/en-us/power-query/connectors/web/web-by-example

https://support.microsoft.com/en-us/office/import-data-from-the-web-b13eed81-33fe-410d-9247-1747269c28e4

Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.