Back to Blog
ShopifyChrome ExtensionsExcel

Export a Shopify Collection to Excel from Your Browser

Select the collection you need, preview its products, and download a catalog workbook without confusing a category with the whole store.

Anas Nadeem
4 min read

You need a competitor's rainwear collection for a product-range review, rather than every product in the store. A whole-store export gives you extra cleanup before you can start comparing the items that matter.

Shopify Detector & Spy lets you choose a public collection directly in its Chrome popup. You can capture the current collection or select another discovered one, then download JSON or CSV directly in version 1.0.4, or an Excel workbook from the ZIP, with the returned variant details.

Open the collection you want to inspect

Install the extension, open the public Shopify collection page, and click the toolbar icon while that storefront tab is active.

The popup separates Whole website, Current collection, and Current product when the page supports them. Choose the collection action rather than the website action for a category-specific file.

Shopify Detector & Spy version 1.0.4 showing storefront detection, collection discovery and direct JSON, CSV and ZIP download buttons

The screenshot is a retained version 1.0.4 browser verification capture. It shows a Free-plan partial run on Taylor Stitch, with 100 products and 730 variant rows; these dated observations do not establish current store totals.

Find another collection without changing pages

Expand or scroll to Other collections. Search the discovered titles or handles, then choose Get data beside the desired collection.

Search filters the discovered collection list; it does not establish access to every merchant collection. Counts show Counting… while scanning and an exact total only when established. Incomplete counts remain unknown or unavailable, rather than appearing as zero or a + total.

If a known collection is absent from discovery, open its supported public URL directly and inspect the current-collection choice. A private or unexposed collection remains outside the public workflow.

Keep capture open, then inspect a few products

Leave the popup open while collection runs. Expand Preview captured products and compare a handful of titles, options, tags, and identifiers with the source.

The result should name the collection you selected. Its source context belongs in the exported file and manifest too. If you selected another collection from the popup, the current page's count should not become the expected count for that different scope.

Download the result before beginning another capture on the same active page. If interrupted, reopen the popup there and resume the saved capture when available.

Open the Excel file from the ZIP

Choose Download catalog ZIP, extract it, and open catalog.xlsx. The workbook keeps catalog fields as text to preserve literal values and identifiers during review. The archive also includes CSV, image links, normalized JSON, and the coverage manifest.

The catalog table has one row per returned variant. To count products, use distinct product IDs. To inspect options, keep the variant IDs and their parent-product associations.

Review taskSpreadsheet approach
Count productsCount distinct product identities
Check size/color choicesReview variants within each product
Review category coverageCompare the selected scope and manifest
Compare pricesPreserve source amount, currency status, and date
Review assetsUse image associations and gallery links

The data-quality guide explains how to preserve these relationships when cleaning the sheet.

Avoid three common collection-count mistakes

Adding every collection total. Products can appear in several collections. Sum the totals only if your analysis intentionally counts memberships; it will not generally give a unique store-product count.

Treating "All Products" as a guaranteed whole-store scope. It is a collection name. Compare the actual requested endpoints and identities before assuming it contains every exposed product.

Expecting a page filter to define the export. A visible filtered subtotal can differ from the underlying collection feed. Inspect the chosen scope and perform any permitted analysis filtering explicitly after export.

Work within the visible limits

Free includes 100 captured products per UTC month in the browser profile. Pro removes the monthly quota and has no fixed product or variant cap per run. Free captures use the remaining allowance; browser memory, storage and source access can still limit coverage. Check the current listing before planning a larger job.

For multiple supplied URLs or a scheduled workflow, the Apify export tutorial covers the companion actor. Its limits, pricing, and files are separate from the extension.

Open Shopify Detector & Spy in the Chrome Web Store, choose one useful collection, and compare its Excel rows with the source. You can keep the research focused from the first capture.