Connect Shopee Ads to Excel
Easily bring your Shopee Ads data into Excel with Windsor.ai for advertising performance reporting.
Windsor.ai delivers Shopee Ads impressions, clicks, expense, GMV, orders, and ROAS 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.
Get more from your Shopee Ads data with Excel
Connecting Shopee Ads to Excel with Windsor.ai lets sellers and marketing teams analyze ad performance in a tool they already use. Here are the key benefits of this integration:
The Excel you already know
Work with your Shopee Ads 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 Shopee Ads data instead of downloading and importing new files.
Combine Shopee Ads with other channels
Add Shopee, Google Ads, or Facebook Ads data to the same workbook to compare advertising on different channels side by side.
Using Windsor.ai connector to import data from Shopee Ads into Excel
Without Windsor.ai, getting Shopee Ads data into Excel means downloading reports from Seller Centre and opening each file by hand. Windsor.ai’s connector loads your Shopee Ads impressions, clicks, expense, GMV, orders, and ROAS into Excel through one URL, with no code.
Connect in minutes and start working with your Shopee Ads data in a workbook.
How to connect Shopee Ads to Excel in Windsor.ai
Make sure you have the following prerequisites before setting up the connector:
- Shopee seller account with Shopee Ads
- Excel document
- Active Windsor.ai account
Connect a data source
Connect Shopee Ads in your Windsor.ai dashboard: authorize Windsor.ai to access your Shopee account when prompted. 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 Shopee Ads data into Excel. Refresh the query from the Data tab whenever you need current numbers.
FAQs
What is Excel?
Microsoft Excel is Microsoft’s spreadsheet application for organizing, calculating, and analyzing data with formulas, pivot tables, and charts.
What Shopee Ads data can I load into Excel?
Windsor.ai loads your Shopee Ads data into Excel in six groups. These are some of the fields in each; the Shopee Ads field reference lists all of them:
- Ad performance: Impressions, Clicks, CTR, Expense, Cost Per Conversion, by day or by Hour.
- Direct results: Direct Orders, Direct Items Sold, Direct GMV, Direct ROAS, Direct Conversion Rate.
- Broad results: Broad Orders, Broad Items Sold, Broad GMV, Broad ROAS, Broad Conversion Rate.
- Balance: Total Balance, Balance Timestamp.
- Campaigns and items: Campaign ID, Campaign Ad Type, Region, Item ID, Item Status List, Ongoing Ad Type List, SKU Tag List.
- Date and account fields: Date, Account ID, Account Name.
How does Windsor.ai load Shopee Ads data into Excel?
Windsor.ai generates an API key URL for your Shopee Ads 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 Shopee Ads with other data sources in one Excel workbook?
Yes. Windsor.ai supports 350+ data sources, so you can connect Shopee Ads alongside tools such as Shopee, Google Ads, or Facebook Ads and work with them in the same workbook. For example, you can compare Shopee Ads expense and GMV with orders from the Shopee connector, or compare Shopee Ads expense with Google Ads spend.
How much does it cost to integrate Shopee Ads with Excel using Windsor.ai?
The free forever plan covers 1 data source, so connecting Shopee Ads on its own costs nothing and needs no credit card. Combining Shopee Ads with other sources, such as Shopee or Google Ads, 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 Shopee Ads and Excel using Windsor.ai?
Yes, we have helpful resources to help you get started. You can explore our official documentation for Shopee Ads to Excel integration with Windsor.ai:
Tired of manual Shopee Ads data exports? Get started with Windsor.ai today to automate your reporting

