Convert Shopify Orders JSON to CSV for accounting

The problem

Shopify Orders API data is nested and verbose. Accounting and fulfillment teams need a flat, readable CSV with just the fields that matter: order id, totals, taxes, customer, and dates.

The outcome

Step-by-step

1. Copy the JSON from the Shopify Orders API.
2. Paste it into the converter.
3. Preview, reorder columns, and export to CSV.

Tip: If you want line items, keep the line_items column and export with nested tables shown inline.

Example JSON (trimmed)

Paste this JSON into the converter:

[
  {
    "id": 450789469,
    "name": "#1001",
    "created_at": "2026-03-12T10:05:00Z",
    "currency": "USD",
    "subtotal_price": "58.00",
    "total_tax": "4.64",
    "total_shipping_price_set": { "shop_money": { "amount": "5.00", "currency_code": "USD" } },
    "total_discounts": "0.00",
    "total_price": "67.64",
    "customer": { "first_name": "Renee", "last_name": "Carter", "email": "renee@example.com" },
    "shipping_address": { "city": "Austin", "province": "TX", "country": "US" },
    "line_items": [
      { "sku": "TSHIRT-BLK-M", "quantity": 2, "price": "19.99" }
    ]
  },
  {
    "id": 450789470,
    "name": "#1002",
    "created_at": "2026-03-13T14:22:00Z",
    "currency": "USD",
    "subtotal_price": "39.00",
    "total_tax": "3.12",
    "total_shipping_price_set": { "shop_money": { "amount": "4.00", "currency_code": "USD" } },
    "total_discounts": "5.00",
    "total_price": "41.12",
    "customer": { "first_name": "Alex", "last_name": "Kim", "email": "alex@example.com" },
    "shipping_address": { "city": "Toronto", "province": "ON", "country": "CA" },
    "line_items": [
      { "sku": "HOODIE-GRY-L", "quantity": 1, "price": "39.00" }
    ]
  }
]

Recommended columns

FAQs