How to grab data from Website thats not in a table? Please Help =)

Like (0) Share

Report

Posted on 5 Feb 2024 14:02:35 by NotVeryGoodatBI

Hello, I am trying to gather data from the following website link: Shop for Rates Results | PAPowerSwitch

This data is not in a table so I am having trouble getting Microsoft Excel's 'Get Data' from Web option to work... is it possible to retrieve this data and sort it into a table?

I would like to grab all inputs for each offer, such as:

Company Name, Rate Structure, Term Length, Price per kWh, Discount Available, Enrollment Fee, Renewable Energy, Cancelation Fee, Introductory Prices, Term End Date, Monthly fee.

If anyone could help me figure out how to retrieve this data so I can just refresh it every day to see updates it would be appreciated.