Excel has no built-in way to turn a nested JSON file like products.json into rows and columns - opening it directly just shows the raw text, or Excel refuses the file outright depending on version.

Drop the file into the tool above instead. It reads the JSON locally in your browser, flattens every product’s variants into rows, and gives you back a CSV built specifically to open cleanly in Excel: a UTF-8 marker keeps accented characters and emoji intact, so a product called "Café Mug ☕" doesn’t turn into garbled symbols.

From there it’s a normal spreadsheet - filter by vendor, sort by price, whatever the job needs.

The same conversion also handles the other common Excel headache with exported data: cells that Excel would otherwise misread as a formula, like a title starting with an equals sign. That gets escaped automatically too, so you shouldn’t need a second pass to clean the file up before it’s actually usable.