Whether you are auditing your own shop, preparing a migration or studying a competitor, the first step is nearly always the same: get the product list into a spreadsheet. This guide walks through doing that for any Shopify store in a couple of minutes, and then covers the small details that decide whether the file opens cleanly in Excel or Google Sheets.
Step 1: find the store address
You only need the store’s normal web address, such as allbirds.com. You do not need to be logged in, and you do not need an API key or an app installed on the store. If you only care about part of the range, open the store, click into a collection (for example “Sale” or “Women’s shoes”) and copy that address instead. It will look like store.com/collections/sale, and only the products in that collection are fetched.
If you are not sure the store runs on Shopify, read how to tell if a store uses Shopify. The tool also checks for you and will say so if it is not.
Step 2: run the scrape
- Open the scraper and paste the address into Store URL.
- Leave Fetch the entire catalogue switched on to get everything, or switch it off and set Stop after to a number of products for a quick sample.
- Press Scrape. The tool first confirms the store is on Shopify, then reads the catalogue one page at a time. You will see the product and row counts climb as it goes.
A store with a few hundred products usually finishes in seconds. Very large catalogues take longer because each page is a separate request.
Step 3: narrow it down
Before exporting, use the filter bar to keep only what you need. You can search across titles, SKUs, tags and colours (every word must match), restrict to in-stock or out-of-stock variants, drag the price slider, pick vendors or product types, and show only discounted items. The totals at the top update as you filter.
The table has two views. Grouped by product folds each product’s variants into one line with a price range and stock summary. Every variant shows one row per size or colour. The export always contains the per-variant rows.
Step 4: download CSV or JSON
Click CSV for spreadsheets or JSON for code and databases. The file contains exactly the rows your filters left visible, with every column, and it is built inside your browser, so nothing is uploaded. The file name is taken from the store, for example allbirds-com-catalogue.csv.
Opening the file cleanly
Google Sheets
Go to File → Import → Upload, choose the CSV, and pick “Replace spreadsheet” or “Insert new sheet”. Sheets detects the comma separator and UTF-8 text automatically, so accented product names and currency symbols come through intact.
Microsoft Excel
Double-click the file and it opens directly. The export is marked as UTF-8, so accented product names and symbols such as é or € display correctly. If you want control over column types, open a blank workbook and use Data → From Text/CSV instead.
Keep SKUs and IDs as text
Spreadsheets love to “help” with long numbers. A variant ID such as 40213241725008 can be shown in scientific notation, and SKUs with leading zeros can lose them. In Excel’s import dialog choose Transform Data and set the sku, product_id and variant_id columns to Text before loading. In Sheets, select those columns and use Format → Number → Plain text.
What to do next
- Not sure what a column means? The column reference explains each one.
- Want one line per product instead of per variant? See variants, SKUs and options for a pivot-table recipe.
- Exporting your own store? Run through the catalogue audit checklist.