How to extract the data from web and store it to excel like this?

Help StudioX
,
1

image
This is my Input file what i need is to search this product on amazon and extract the following data into excel sheet

image
image1025×245 5.56 KB

I tried everything but not getting proper output

2

Hi,

Before providing suggestion two questions from my end.

  1. Always should we have five rows per each product?

  2. How you are extracting the data is it table you are extracting from amazon or one by one extracting and insert into data table and store into the excel?

Tahnks.

3

i want to extract the data from amazon product like ASIN , productname , ans percentage of stars

  • in starting first product will get searched then all the percentage for the stars will get stored into excel then it will go to another product