Good afternoon, all! I've been trying to scrape data from Google and running into a roadblock. I need to either use VBA or Excel to go to a URL (which I have stored in a cell) and pull back the number of reviews and score of the business. An example URL for a local bank is here. Whenever I try to import the data from the Web in Excel or Power BI, I get lots of table data but nowhere is the score or # of reviews held for me to grab.
I have experience with VBA and Excel but when it comes to pulling data from a site, I'm out of my depth. Does anyone know if this is possible? I attached a screenshot and I only need the score and number of reviews. Thank you for any help that's provided!
I have experience with VBA and Excel but when it comes to pulling data from a site, I'm out of my depth. Does anyone know if this is possible? I attached a screenshot and I only need the score and number of reviews. Thank you for any help that's provided!
