How to Connect Shopify to Excel – Query E-Commerce Data with SQL

See everything Query Streams can do beyond this guide Get Started Free

Supports

+more

Live Data

Replace exports with on-demand SQL

Excel Sheets

BI & AI Analytics

Ask Nova, get SQL + charts

Meet Nova

Database REST API

One key per partner. No credentials shared.

Build an API

+more

Automation

Scheduled sync to 6+ platforms

Explore

+more

API to SQL

Query APIs with SQL, no code

Explore

+more

AI Database MCP

Claude, Cursor, ChatGPT & Grok talk to your data

Connect AI

Query Streams transforms your Shopify store data into SQL-queryable tables, letting you import live orders, products, customers, and inventory directly into Microsoft Excel. No API coding, no manual exports—just write SQL queries and get real-time e-commerce data in your spreadsheet. Sign up free at QueryStreams.com and start querying your Shopify store in minutes.

What Shopify Data Can You Access?

Query Streams syncs your Shopify Admin API data to an AES-256 encrypted local cache, transforming it into SQL-queryable tables. Every table includes a raw_data JSON column with the complete API response—including multi-currency amounts, custom note attributes, tax lines, and more.

Prerequisites

Setup Guide

Step 1: Install the Query Streams Network Agent

1. Log in to my.querystreams.com
2. Navigate to Network Agents in the left sidebar
3. Click Download Agent and run the Windows installer
4. The agent installs as a Windows service and connects automatically
5. Your agent appears as “Online” in the portal within 30 seconds

Step 2: Create a Shopify Custom App

Query Streams uses Shopify’s Client Credentials flow for secure authentication. You’ll create a custom app in the Shopify Dev Dashboard:

1. Go to partners.shopify.com and log in
2. Navigate to Apps → Create app → Create app manually
3. Name your app (e.g., “Query Streams Data Connector”) and click Create app
4. In your app settings, go to Configuration → Admin API integration → Configure
5. Select the required scopes: read_orders, read_products, read_customers, read_inventory, read_locations, read_fulfillments, read_price_rules, read_discounts
6. Click Save, then go to the Overview tab
7. Copy your Client ID (32-character hex string)
8. Click Show secret to reveal your Client Secret
9. Install the app on your store

Step 3: Add the Shopify Connector

1. Open the Network Agent interface at http://localhost:1823
2. Click Add Connection and select Shopify
3. Enter your Store URL (e.g., your-store.myshopify.com), Client ID, and Client Secret
4. Click Test Connection — Query Streams exchanges credentials for an access token
5. On success, you’ll see your store name, plan, and verified API scopes
6. Click Next to configure sync schedules and install pre-built queries

Step 4: Configure Your Sync Schedule

All 16 tables sync by default. Disable any table by setting its interval to Never. Click Save — the initial sync starts immediately.

Step 5: Install the Microsoft Excel Add-in

1. Open Microsoft Excel
2. Go to Insert → Get Add-ins (or Office Add-ins)
3. Search for “Query Streams”
4. Click Add to install — the Query Streams panel appears on the right side of Excel
5. Sign in with your Query Streams account credentials
6. Or install directly: Install Query Streams for Microsoft Excel

Example Shopify SQL Queries

SELECT
    DATE(created_at) AS order_date,
    COUNT(*) AS order_count,
    SUM(total_price) AS revenue,
    AVG(total_price) AS avg_order_value
FROM shopify.orders
WHERE financial_status = 'paid'
  AND created_at >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY DATE(created_at)
ORDER BY order_date DESC;

SELECT
    p.title AS product,
    p.vendor,
    SUM(li.quantity) AS units_sold,
    SUM(li.price * li.quantity) AS revenue
FROM shopify.order_line_items li
JOIN shopify.products p ON li.product_id = p.id
JOIN shopify.orders o ON li.order_id = o.id
WHERE o.financial_status = 'paid'
  AND o.created_at >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY p.id, p.title, p.vendor
ORDER BY revenue DESC
LIMIT 20;

SELECT
    p.title AS product,
    v.title AS variant,
    v.sku,
    il.available AS stock_qty,
    l.name AS location
FROM shopify.inventory_levels il
JOIN shopify.variants v ON il.inventory_item_id = v.inventory_item_id
JOIN shopify.products p ON v.product_id = p.id
JOIN shopify.locations l ON il.location_id = l.id
WHERE il.available < 10
  AND l.active = true
ORDER BY il.available ASC;

Share Shopify Reports Without Sharing Credentials

Frequently Asked Questions

Related Guides

Category: API Connectors

Tags: Shopify, Excel, API, E-commerce, SQL, Orders, Inventory, Real-Time Data

Meta Description: Connect Shopify to Microsoft Excel with SQL. Query orders, products, inventory, and customers live — no API coding required. Step-by-step setup guide.