JSON and spreadsheet guide

How to Flatten Nested JSON Arrays into CSV Rows

Turn items inside a nested JSON array into repeated CSV rows while keeping the parent order, customer or event fields on every row.