Forum Discussion
Power Query with Unique URLs
Hi,
So I'm recently doing a project where I have to get data for each user from a website url, but the website url varies on the username. For example the begining of the URL is http://www.site.com/username=. I have all the usernames in cells A1:A201, so for the first username would have a set of data at http://www.site.com/username=User1. Is there anyway to make a Power Query that will return the data from each individual URL (all 200) and have it displayed in the adjacent row (B1:B201)?
5 Replies
- Logicaly, i want something like this http://pix.my/tbFRuL
There's a really good article here by Excel MVP John MacDougall that could be exactly what you need
https://www.howtoexcel.org/power-query/how-to-extract-data-from-multiple-webpages/
Hi Salvatore
You'd need to use a custom function
I've attached a demo file here for you to look at
- I have the same problem. Have a row with links and want to use it as URLs for Power Query. I try to download this file, but I see only two link. screenshot: http://pix.my/C8e96l
I have MS Excel 2013- Hi
The file I attached contains a Power Query function that references that Table.
You will need to click "show queries" or "Query Pane" in the Power Query addin tab in order to see the function
