Connect Connectif to Excel

Easily bring your Connectif data into Excel with Windsor.ai for email marketing reporting.

Windsor.ai delivers Connectif email campaign sends, opens, clicks, unsubscribes, and purchases to Excel through one API key URL, ready for formulas, pivot tables, and charts.

Forget CSVs. Stop copy/paste. Connect data in 2 minutes. No code required.

Try It Free

Free forever plan

No credit card needed

Windsor.ai is your proven Connectif to Excel connector

Get more from your Connectif data with Excel

Connecting Connectif to Excel with Windsor.ai lets marketing teams analyze email performance in a tool they already use. Here are the key benefits of this integration:

The Excel you already know

Work with your Connectif data using formulas, pivot tables, and charts, with no new tool to learn.

Refresh from the Data tab

Refresh the query to bring in the latest Connectif data instead of downloading and importing new files.

Combine Connectif with other channels

Add Shopify, Google Analytics 4, or Facebook Ads data to the same workbook to compare email results and store sales side by side.

Using Windsor.ai connector to import data from Connectif into Excel

Supported fields: 13 metrics22 dimensions

Without Windsor.ai, getting Connectif data into Excel means exporting reports from Connectif and opening each file by hand. Windsor.ai’s connector loads your Connectif email campaign sends, opens, clicks, unsubscribes, and purchases into Excel through one URL, with no code.

Connect in minutes and start working with your Connectif data in a workbook.

With Windsor.ai, you can:

Load Connectif email campaign sends, opens, clicks, and purchases into Excel without exporting reports.
Refresh the workbook from the Data tab to pull current Connectif data.
Build pivot tables and charts for open rates, click rates, and purchase amounts.
Combine Connectif with Shopify, Google Analytics 4, or Facebook Ads data in the same workbook.

Join over 25,000+ businesses that trust Windsor.ai to streamline Connectif to Excel integration

How to connect Connectif to Excel in Windsor.ai

Make sure you have the following prerequisites before setting up the connector:

Connectif account with an API key and report ID
Excel document
Active Windsor.ai account

Register and log in to Windsor.ai

Create a new Windsor.ai account or log in if you already have one.

Connect a data source

Connect Connectif in your Windsor.ai dashboard: enter your Connectif report ID and API key. Select the necessary account(s) you want to pull data from and click “Next.”

Select your destination

Choose “Excel” as the data destination and copy your API key. Find the API key provided in the instructions below.

Sync Windsor.ai data with Excel

Go to Excel, click “Data” -> “Web,” and paste your previously copied API key URL in the pop-up.

Visualize your data

You have connected your spreadsheet with Windsor.ai and loaded Connectif data into Excel. Refresh the query from the Data tab whenever you need current numbers.

google sheets connector to integrate data

FAQs

What is Connectif?

Connectif is a marketing automation platform for online stores. The Windsor.ai Connectif connector brings email campaign data into your reports: emails sent, opens, clicks, unsubscribes, purchases, and engagement rates.

What is Excel?

Microsoft Excel is Microsoft’s spreadsheet application for organizing, calculating, and analyzing data with formulas, pivot tables, and charts.

What Connectif data can I load into Excel?

Windsor.ai loads your Connectif data into Excel in five groups. These are some of the fields in each; the Connectif field reference lists all of them:

Campaign and delivery: Campaign, Emails Sent, Unsubscribes.
Opens and clicks: Total Opens, Unique Opens, Total Clicks, Unique Clicks.
Rates: Email Open Rate, Email Click Through Rate, Email Click To Open Rate, Email Unsubscribe Rate.
Purchases: Email Conversion Rate, Total Purchase Amount, and the number of purchases linked to each email.
Date and account fields: Date, Week, Month, Year, Account ID, Account Name.

How does Windsor.ai load Connectif data into Excel?

Windsor.ai generates an API key URL for your Connectif data. In Excel, open the Data tab, choose From Web, and paste the URL. The data loads as a table, and you can refresh it from the Data tab. You choose the fields, accounts, and date range in the Windsor.ai app.

Can I combine Connectif with other data sources in one Excel workbook?

Yes. Windsor.ai supports 350+ data sources, so you can connect Connectif alongside tools such as Shopify, Google Analytics 4, or Facebook Ads and work with them in the same workbook. For example, you can compare Connectif purchase amounts with orders in Shopify, or compare email clicks with sessions in Google Analytics 4.

How much does it cost to integrate Connectif with Excel using Windsor.ai?

The free forever plan covers 1 data source, so connecting Connectif on its own costs nothing and needs no credit card. Combining Connectif with other sources, such as Google Analytics 4 or Shopify, needs a paid plan: $19/month for 3 sources or $99/month for 7. See the pricing page.

Do you have helpful links to get started with integrating Connectif and Excel using Windsor.ai?

Yes, we have helpful resources to help you get started. You can explore our official documentation for Connectif to Excel integration with Windsor.ai:

Tired of manual Connectif data exports? Get started with Windsor.ai today to automate your reporting

Access all your data from various sources in one place. Get started for free.

Start for Free Book a Demo