Connect Shopify to Excel with Windsor.ai

Shopify attribution model

+

excel

About Shopify

Shopify is a commerce platform that allows anyone to set up an online store and sell their products. Merchants can also sell their products in person with Shopify POS. Merchants can sell Physical products, Digital products, Services and consultations, Memberships, Ticketed experiences and Rentals on the Shopify platform.

About Excel

Excel, developed by Microsoft, provides spreadsheet functionality for business users. It’s most commonly used features include calculations, pivot tables, charts and it’s programming language called Visual Basic.

First Step:

You need to select Shopify as a Data Source and Grant Access to Windsor.ai.

Installing the Shopify Connector

The Shopify Connector can only be installed through the Shopify App Store

Shopify App Store

Search for Windsor connector on the Shopify App Store and install the connector.

Using the Shopify Connector

  1. Once the Windsor connector app is installed, select the store you want to connect.
  2. Click on 2. Select Destination
  3. Search for the Shopify metrics and dimensions you would like to use in the field list on the right side and select your data destination.

Second Step:

In this case Select Excel As A Data Destination


Third step:

Create a new Excel Spreadsheet

Fourth Step:

Head to the Data tab and click on From Web

In the URL box paste the link as shown below:

Fifth Step:

Click on Load

If you would like to explore other templates and integrations, please visit our template gallery.

You should also read:

Connect Your Data to Excel

Addressing attribution problems in Shopify for subscription products

How to Create API credentials for Shopify

Templates for Shopify and Excel

Integrating Excel and Shopify has never been easier with Windsor.ai

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.