Connect Shopee to Excel

Easily bring your Shopee data into Excel with Windsor.ai for sales and fee analysis.

Windsor.ai delivers Shopee orders, products, returns, settlements, and wallet data 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 Shopee to Excel connector

Get more from your Shopee data with Excel

Connecting Shopee to Excel with Windsor.ai lets sellers and marketing teams analyze sales, fees, and returns in a tool they already use. Here are the key benefits of this integration:

The Excel you already know

Work with your Shopee 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 data instead of downloading and importing new files.

Combine Shopee with other channels

Add Google Ads, Facebook Ads, or Shopify data to the same workbook to compare sales channels side by side.

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

Supported fields: 40 metrics67 dimensions

Without Windsor.ai, getting Shopee data into Excel means downloading reports from Seller Centre and opening each file by hand. Windsor.ai’s connector loads your Shopee orders, products, returns, and settlement data into Excel through one URL, with no code.

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

With Windsor.ai, you can:

Load Shopee orders, products, and settlements into Excel without downloading reports from Seller Centre.
Refresh the workbook from the Data tab to pull current Shopee data.
Build pivot tables and charts for fees, returns, and stock levels.
Combine Shopee with Google Ads, Facebook Ads, or Shopify data in the same workbook.

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

How to connect Shopee to Excel in Windsor.ai

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

Shopee seller account
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 Shopee in your Windsor.ai dashboard. 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 data into Excel. Refresh the query from the Data tab whenever you need current numbers.

google sheets connector to integrate data

FAQs

What is Shopee?

Shopee is an online marketplace where sellers list and sell products to buyers. The Windsor.ai Shopee connector brings seller account data into your reports: orders, products, returns, settlements, and wallet transactions.

What is Excel?

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

What Shopee data can I load into Excel?

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

Orders: Order ID, Order Status, Order Total Amount, Order Currency, Order Region, Order Payment Method, Order COD, Order Shipping Carrier, Order Days To Ship, Order Ship By Date.
Products: Product Name, Product SKU, Product Brand, Product Status, Product Current Price, Product Original Price, Product Available Stock, Product Condition, Product Category ID.
Returns: Return Status, Return Reason, Return Refund Amount, Return Refund Type, Return Amount Before Discount, Return Due Date.
Settlement: Settlement Commission Fee, Settlement Service Fee, Settlement Buyer Transaction Fee, Settlement Ads Fee, Settlement Campaign Fee, Settlement Escrow Amount, Settlement Seller Discount, Settlement Voucher From Seller, Settlement Voucher From Shopee, Settlement Final Shipping Fee.
Wallet: Wallet Amount, Wallet Current Balance, Wallet Transaction Type, Wallet Transaction Status, Wallet Money Flow, Wallet Transaction Fee.
Date and account fields: Date, Week, Month, Year, Account ID, Account Name.

How does Windsor.ai load Shopee data into Excel?

Windsor.ai generates an API key URL for your Shopee 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 with other data sources in one Excel workbook?

Yes. Windsor.ai supports 350+ data sources, so you can connect Shopee alongside tools such as Google Ads, Facebook Ads, or Shopify, or add the Shopee Ads connector for ad performance, and work with them in the same workbook. For example, you can compare ad spend with Shopee order totals, or compare Shopee sales with sales from your own online store.

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

The free forever plan covers 1 data source, so connecting Shopee on its own costs nothing and needs no credit card. Combining Shopee with other sources, such as Google Ads 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 Shopee and Excel using Windsor.ai?

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

Tired of manual Shopee 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