How to get your analytics, CRM and media data into Microsoft Excel using Windsor.ai

Do you want to get all your performance marketing, CRM and analytics data visualised in Excel? To get there without spending too much of your time copy/pasting data, the instructions below will help you to set up your automated data pipelines. You can connect to all the most commonly used platforms on the market

 

Google AdsFacebook AdsBing AdsGoogle Analytics 4
LinkedIn AdsTikTok AdsAdRollHubSpot CRM
CriteoRTB HouseTwitter AdsSalesforce CRM
AppNexusGoogle Display & Video 360Google Campaign ManagerStripe
TaboolaOutbrainAmazon Seller Central & Amazon MWSGoogle Sheets

 

The Windsor.ai platform supports API calls to retrieve and send information. In this article, we explain how to extract data and visualise it in Microsoft Excel.

 

To start using it

 


 

  1. Add your data and in step 2. Select Destination select Excel in the dropdown. Click the copy button

    data query for excel

  2. Create a new Excel Spreadsheet
  3. Head to the Data tab and click on From Web

    excel integration step 1

    In the URL box paste the link from Step 1.

  4. Click on Load

    load data into excel

    If you would like to explore other templates and integrations, please visit our Excel Template Gallery or Marketing Template gallery

 

You might also like to read:

Easily Connect BigQuery to Excel
Best Marketing Automation Report Templates
Best Small Business Report Templates
Best Content Marketing Dashboard Templates
Free SEM Report Templates
Free SEO Report Templates

Best Social Media Dashboarr Reports
Best E-Commerce Dashboard Templates
Best Client Report Templates
Best Lead Generation Dashboard Templates
Best Web Analytics Report Templates
Best Data Analyst Report Templates
Best PPC Report Templates
Free Google Ads Dashboard Templates
Free Bing Ads Dashboard Templates
Free Facebook Ads Report Templates
Free Linkedin Ad Report Templates
Free Criteo Dashboard Templates
Free Adroll Dashboard Templates
Free Stripe Dashboard Templates
Free Snapchat Ads Dashboard Templates
Free Twitter Ads Report Templates
Best TikTok Ad Report Templates
Free Salesforce Dashboard Templates
Free Hubspot Report Templates
Free GA4 Report Templates
Best DV360 Report Templates
Free Excel Report Templates