A raw products.json file is a nested structure - an array of products, each with its own nested array of variants and images. That shape is exactly what a theme needs to render a store, but it’s not something Excel or Google Sheets can open sensibly on its own.

The extension flattens that structure into rows: every variant becomes its own line, with the parent product’s title, vendor, tags and description carried along, plus the variant’s own price, SKU and options. The result is a normal CSV you can filter, sort and pivot like any other spreadsheet.

You can skip the manual download step entirely: open the store in Chrome, click the extension’s icon, and it fetches every page of products.json for you.

The output is a flattened CSV with one row per variant - the same file whether the store has three products or three thousand, because the extension pages through the whole catalog automatically.