Apologies for the noob question, I’m new!
As the title explains, I’d like to know how I can take captured variables and add them into an excel spreadsheet. I’ve used a scraper to successfully get the information I want from a website (which will run on several different pages) and capture specific parts and add them to a variable string.
Line by line, I want to paste this information into a row on a specific dedicated excel spreadsheet. So eg:
‘First name, middle name, last name, age’ all scraped from the site and pasted into row 2 on the spreadsheet (as 1 has headers - if the bot needs this specified, please let me know!’.
Then on the next scraped page, first name, middle name, last name, age again but this time onto row 3 as it’s different information, then row 4, 5 etc until there are no more pages to check.
How would I go about doing this?
Thanks for your help in advance.