These are the steps which i am unsure whether will it work.
- Read excel file (only 1 column) For E.g ( Name of PS4 Games)
- Open browser → Link to the site. For E.g (@store.playstation.com/en-sg/home/games@)
- Using for each to read the row of data in excel file
- Search each row of data which is the name of the game from the site.
- Scrape Datatables(Description,Details) from the site after search.
- Repeat step 1 to 5 till the end of the column.
- Write into CSV which contains all the data that being scraped when searched.