How to convert a graphql response to csv
- Step 1Capture the GraphQL response — From your client (Insomnia, GraphiQL, Apollo Studio), save the response body to a .json file.
- Step 2Optionally extract the edges — If the response is wrapped, use jq '.data.products.edges' > flat.json so the converter sees the array directly.
- Step 3Drop the JSON in the converter — Auto-detect handles arrays and NDJSON. Pick array of objects for a single-page response.
- Step 4Open the CSV — Inspect in Excel, Sheets, or pipe it into a notebook for visualisation.
Frequently asked questions
What about deeply nested fragments?+
Flattening recurses through every nested object. A fragment three levels deep becomes a dot-notation column three segments long.
Can I keep cursor pagination metadata?+
Yes. PageInfo lives at a different level than edges — extract both before flattening, or post-process the CSV to pull cursors into a separate column.
Does it work with Shopify's GraphQL Admin API?+
Yes — Shopify's products, orders, and customers all return Relay-style edges/nodes that flatten cleanly.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.