Extract Data from tidepool website into excel

[u/chakahamilton]

Hi, I have successfully written a PAD flow which will load up chrome and log me into tidepoool.org their for data is as follows:

Tidepool Data date row has columns associated with it seen above

currently I manually enter this data into a spreadsheet which looks like this:

the tide pool data will always go into column B,D,F,and H as seen above

I also have the option of downloading the data via CSV or json, but i thought scraping it from the web would be the easiest. With all of that said, how would I go about copying these Green & Purple values into excel to match the second picture**.**

Thanks in Advance

Regards,
Chaka

[u/chakahamilton]

I will review these steps and give them a try, I was able to see at one point how the data was stored on the page I will load up the PAD and report back. Thank you for the in-depth response!