Open the shop page, click the extension icon, download the .xlsx. You get one row per product with the name, price, list price, SKU, description and image links, and the prices are real numbers you can sort and add up. If it is your own Shopify or WooCommerce store, its admin exports every product without an extension; the steps are below. This guide covers the steps, what lands in each column, and what to do when a shop is read wrongly.
Add to Chrome, it's free No account · private by default
0:52Install Web Product Scraper, open the shop page that lists the products, click the extension icon and press the Excel button under the table. For more than one page, or for full descriptions, choose the pages and Full in step 2, press Scrape, and download the .xlsx in step 4. The file opens in Excel, Google Sheets or LibreOffice with one row per product.
If you run the store, its admin exports every product, drafts and stock included, with no extension. Use Web Product Scraper for stores you do not run, or for the photos as files.
In your Shopify admin open Products and click Export. Choose the current page, all products, your selection or a search, pick "CSV file for Excel, Numbers, or another spreadsheet program", then press Export products. The current page or a selection downloads straight away; all products arrive by email. Each size or colour is its own row, and the images are links in the Product image URL column (Image Src in older files).
In WordPress open Products, All Products and click Export at the top. Keep "Export all columns", narrow it to some product types or categories if you like, and press Generate CSV; the file downloads when it is ready. The images are links in the Images column.
Double-click the file, or in Excel use Data, From Text/CSV and choose UTF-8 if ₹ or accented letters look wrong. The columns are the platform's import columns, so the same file can go back into the store after editing.
Both exports list image addresses, not the pictures. Open a collection of your own store with Web Product Scraper and download the ZIP: every photo in a folder per product, named after it.
Which way fits depends on what the page holds and how often you need it.
| Way | How | Good for | Limits |
|---|---|---|---|
| Copy and paste | Select the products, copy, then Paste Special, Text in Excel. | A dozen rows, once. | One page at a time; prices often arrive as text with the currency symbol, and the photos stay behind. |
| Excel's From Web | Data, From Web (or Get Data, From Other Sources, From Web); paste the page address; pick a table in the Navigator; Load. Refresh All reads it again later. | Pages that hold a real table. | Most shops lay products out as cards rather than a table, so the Navigator often finds nothing useful. |
| Table extensions | Instant Data Scraper and similar: open the page, start the extension, check the table it guesses, download. | Any repeating list, products or not. | On shops you tidy the columns yourself, and photos stay as links. |
| Cloud scrapers | Browse AI, Octoparse and similar: set up a robot or task once, then it runs on their servers, on a schedule. | Regular jobs that run without your computer. | Free plans have limits; bigger jobs need an account and a paid plan. |
| Web Product Scraper | Open the shop page, click the extension icon, download the .xlsx. | Shop products: prices as numbers, list price apart, every photo as a file. | Shops only. One run reads up to 500 listing pages and stops after 100 products unless you change it. |
One sheet called Products. A column appears only when the shop actually has that data, so there are no empty columns to delete. Tick Variants for a row per size or colour, each with its own price, SKU and stock. The examples are from the sample file below.
| Column | What it holds | Example from the sample file |
|---|---|---|
| code | Your own code, when you type a prefix such as XX: XX-001, XX-002, in the order the shop lists the products. | only when you set a prefix |
| name | The product name as the shop shows it. | White Leather Sneakers |
| sku | The shop's product code. Listings rarely show it, so choose Full: open each product page. | YS-001 |
| price, mrp | The selling price and the struck-out or M.R.P. price, both as numbers, so SUM, sorting and filters work straight away. | 2499, 3999 |
| currency | The currency, in its own column. | INR |
| category, brand | As the shop publishes them. | Footwear, Your Shop |
| stock | In stock or out of stock, when the shop says. | in stock |
| rating, reviews | The rating and its review count, when the shop publishes them. | 4.6, 38 |
| description | The full description, when product pages are opened. | Low-top sneakers in smooth white leather … |
| image_count, image_1 … | How many photos, then a link to each, up to twelve; full-size files with product pages opened, or on Shopify. Videos get the same columns. | 3, …/white-leather-sneakers-1.webp |
| product_url | The address of each product, so you can go back to it. | …/demo-shop/white-leather-sneakers |
| needs_review | The fields worth checking on that row, such as a missing price or a value read from weak markup, so you check those few by hand. | none in the sample |
| source_website … | Where and when the row was read: the shop, its platform, the shop's own product ID, the time and the read status. | webproductscraper.com, generic |
Real exports made by the extension from its sample shop: 12 made-up products, two pages, read in Full.
The panel shows what the page gives, as a table. Hide columns you do not need with the Columns menu, and add a code prefix if you want one.
Choose a page range, for example page 1 to 5 (the listing's page count is shown), how many products, and Quick or Full: Full reads every product page for descriptions, SKUs and full galleries. Listings that grow as you scroll, or behind a Load more button, are set under More options. Then press the Scrape button.
Every product lands in your list as the run goes. Scrape the same page again later and the price changes are marked.
In step 4 open Excel, check the preview of the first five rows, and press Download .xlsx. Chrome asks where to save it.
For opening, sorting and sharing. Prices stay numbers and long descriptions stay in one cell.
For importing into another system: most marketplaces take CSV. It is saved as UTF-8 with the marker Excel needs, so ₹ and other symbols show correctly. For Shopify or WooCommerce, Shop import gives a file in their own format.
For developers and scripts. Every field, including all image links, in one file.
Press "Open in Google Sheets": the table is copied and a new, empty Google Sheet opens; press Ctrl+V in the first cell. Prices stay numbers there too.
Prices or names are missing or wrong. Open "Teach this site", press Pick next to the field, and click the right value on the page. Save the profile, and every later run on that shop uses it.
Only the first page came through. In step 2, set the page range; for shops that show more as you scroll or behind a Load more button, open More options.
No SKUs or short descriptions. Listings rarely carry them. Choose Full: open each product page in step 2 and run again.
Products appear once even though they come in several sizes or colours. Tick Variants (Columns menu or Settings) for a row per size or colour, with its own price, SKU and stock, when the shop publishes them.
A product is already in the list from an earlier run. It is skipped, so running the same shop again adds only what is new; untick "Skip products already in your list" to read it again and see its price change.
Yes. There is no account and no paid tier, and the file is made in your browser.
From the store admin: in Shopify, Products, Export; in WooCommerce, Products, All Products, Export, then Generate CSV. Both give a CSV that opens in Excel. Use Web Product Scraper for stores you do not run, or to save the photos as files.
Yes, and on Magento, BigCommerce and custom shops. When a shop is not read correctly, Teach this site fixes it with a click on the right value.
Yes. Open the product page and the panel shows that one product; press ⬇ Excel.
The sheet holds links to the images, not the pictures themselves. To save the image files, use Photos & videos in step 4, which downloads one ZIP with a folder per product.
