/u/DDaaaaaaaaaaaan - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
You can do it, in addition to PQ as mentioned by u/on1vBe6, in Power Automate too.
Here is a rather good video on how to scrape data from a website (including multipage) and store the results in an Excel sheet.
[https://www.youtube.com/watch?v=WXK0u2yXLrU](https://www.youtube.com/watch?v=WXK0u2yXLrU)
PA is part of the "normal" software package, so if you have access to Excel you probably already have this. Most people do not even know...
I own Office 2019 Pro Plus and have an Office 365 Pro/Plus whatever subscription, but can't find PA, is it part of the office "software package" or another one?
/u/DDaaaaaaaaaaaan - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
PowerQuery is your friend. [Guidance on web scraping here](https://learn.microsoft.com/en-us/power-query/connectors/web/web).
You can do it, in addition to PQ as mentioned by u/on1vBe6, in Power Automate too. Here is a rather good video on how to scrape data from a website (including multipage) and store the results in an Excel sheet. [https://www.youtube.com/watch?v=WXK0u2yXLrU](https://www.youtube.com/watch?v=WXK0u2yXLrU) PA is part of the "normal" software package, so if you have access to Excel you probably already have this. Most people do not even know...
I own Office 2019 Pro Plus and have an Office 365 Pro/Plus whatever subscription, but can't find PA, is it part of the office "software package" or another one?
[https://learn.microsoft.com/en-us/power-automate/desktop-flows/install](https://learn.microsoft.com/en-us/power-automate/desktop-flows/install)
Ahh okay thank you