Export Home Depot product reviews as rows
Reviews of a power tool or a bathroom fitting are worth more than reviews of most things, because the people writing them have installed the item and lived with it. They are also stuck inside a widget you can only scroll. This service turns a product's review section into a table: paste Home Depot product URLs, one per line, and each review comes back as a row - the author, the rating, the headline, the body text and the date, alongside the product's own overall rating and total review count. Ten columns, one row per review.
Two controls shape the run, and the sort is the interesting one. There are six options - Photo Reviews, Most Helpful, Oldest, Newest, Highest rating and Lowest rating - and two of those are rare enough to be the reason to use this at all. Photo Reviews narrows to buyers who photographed the thing in place, which is the only honest answer to what a finish or a fitting actually looks like. Oldest lets you read the launch-period complaints, which is how you tell a fixed problem from a buried one. The limit is per query rather than per run, so ten products at a hundred each is a thousand rows.
Keeping the review-level and product-level scores in separate columns is what makes the export analysable. rating is this review; aggregate_rating and review_count belong to the product the review sits on. A two-star review among four hundred five-stars is a different fact from a two-star among nine, and only the second pair of columns tells you which you are looking at. Exactly how those two are filled in across a product's rows is worth a glance on your first run, since we have never seen a populated export to describe.
One limit is stated plainly because it changes what to expect from this page. We hold three run exports for this service and none of them contains a Home Depot review: every review column was empty on all three. Two had been pointed at a placeholder address rather than at Home Depot and came back http 404; the third was pointed at a real Home Depot product and still returned no review. What survives is the column list, and it survives well - the header row is identical across all three workbooks and matches the service's declared set. So the ten names above are dependable, and everything past them - what a rating looks like, what format a date arrives in, whether the aggregate is a number or a string - is deliberately absent rather than invented. The form also warns that anti-bot sites return a blocked status on the free pool, which is residential-only; that is the platform's own warning about the shared pipeline and it is worth planning for. Run one product on the free tier and read the first few rows yourself; your first 500 cost nothing and need no credit card. See pricing for current rates.