All Reviews of a Shop

To use this file, you need Excel 2016 or above.

You’ll receive an Excel template that will help you download all Reviews of a specific shop into Excel.

You'll need:

• your own API Key that you can get from https://www.etsy.com/developers/register

• the ShopID of the shop that you want to see the listings for. To get this, you can go the Etsy to the shop’s page, go to the Contact button, right click on it and “Copy link address“. You can copy that in the cell A1 of the template and the formulas will pick up the shop ID.
• the number of listings (any number over 25). Make sure you don't Exceed the Etsy API limits (5000 per day)

The data that you'll download contains the following information:

• Rating (1-5)
• Reviews (all text)
• Created Date
• Language
• Buyer ID
• Listing ID
• Shop ID
• Transaction ID

For more details on how it works: https://learntechtips.com/how-to-scrape-etsy-data/

For a video describing what this is: https://youtu.be/w51w0fL-nEE