Governed Data Marts from your warehouse, inside Microsoft Excel
The OWOX Data Marts add-in lets finance and operations teams browse published Data Marts, build a report and refresh it in the workbook they already use.
Available connectors to Microsoft Excel
Available connectors to Microsoft Excel
- AWS Athena Connector to Microsoft Excel
- AWS Redshift Connector to Microsoft Excel
- Bank of Canada Connector to Microsoft Excel1 endpoint3 fieldsExchange Rates
- Criteo Ads Connector to Microsoft Excel4 endpoints196 fieldsPlacement Categories, Placements, Statistics, Transactions
- Databricks Connector to Microsoft Excel
- Facebook Ads Connector to Microsoft Excel15 endpoints1,172 fieldsAd, Ad Account, Ad Account User, Ad Creatives, Ad Insights, Ad Insights by Ad Set, Ad Insights by Age and Gender, Ad Insights by Campaign, Ad Insights by Country, Ad Insights by Device Platform, Ad Insights by Link URL Asset, Ad Insights by Product ID, Ad Insights by Publisher Platform and Position, Ad Insights by Region, Ads
- GitHub Connector to Microsoft Excel3 endpoints54 fieldsRepository Contributors, Repository Information, Repository Statistics
- Google Ads Connector to Microsoft Excel9 endpoints166 fieldsAd Group Ads Stats, Ad Groups, Ad Groups Stats, Campaigns, Campaigns Stats, Criterion, Geo Stats, Geo Target Constants, Keywords Stats
- Google BigQuery Connector to Microsoft Excel
- Google Sheets Connector to Microsoft Excel
- LinkedIn Ads Connector to Microsoft Excel5 endpoints175 fieldsAd Accounts, Ad Analytics, Campaign Groups, Campaigns, Creatives
- LinkedIn Pages Connector to Microsoft Excel2 endpoints18 fieldsFollower Statistics, Time-Bound Follower Statistics
- Microsoft Ads Connector to Microsoft Excel3 endpoints225 fieldsAd Performance Report, Campaigns, User Location Performance Report
- Open Exchange Rates Connector to Microsoft Excel1 endpoint4 fieldsHistorical exchange rates data
- Open Holidays Connector to Microsoft Excel1 endpoint7 fieldsPublic Holidays
- Reddit Ads Connector to Microsoft Excel18 endpoints675 fieldsAd Account, Ad Account User, Ad Groups, Ad Performance, Ad Performance by Account, Ad Performance by Ad Group, Ad Performance by Campaign, Ad Performance by Community, Ad Performance by Country, Ad Performance by DMA, Ad Performance by Interest, Ad Performance by Keyword, Ad Performance by Placement, Ads, Campaigns, Custom Audiences, Funding Instruments, Lead Gen Forms
- Shopify Connector to Microsoft Excel25 endpoints337 fieldsAbandoned Checkouts, Article Metafields, Articles, Blog Metafields, Blogs, Collection Metafields, Collections, Customer Metafields, Customers, Discount Codes, Fulfillment Orders, Inventory Items, Location Metafields, Locations, Order Metafields, Orders, Page Metafields, Pages, Product Metafields, Product Variant Metafields, Product Variants, Products, Shop, Shop Metafields, Tender Transactions
- Snowflake Connector to Microsoft Excel
- TikTok Ads Connector to Microsoft Excel7 endpoints217 fieldsAd Groups, Ad Performance, Ad Performance by Country, Ads, Advertiser Account, Campaigns, Custom Audiences
- X Ads Connector to Microsoft Excel10 endpoints187 fieldsAccounts, Ad Performance, Ad Performance by Country, All Cards, Campaigns, Cards, Line Items, Promoted Tweets, Targeting Locations, Tweets
R01 · Destination
What Does Microsoft Excel Mean in OWOX Data Marts?
Excel is the destination for teams whose reporting lives in workbooks, not in a BI tool. The OWOX Data Marts add-in works inside the workbook. You sign in, browse the published Data Marts, build a report and refresh it there.
- Every number comes from a Data Mart your analysts defined, not from a formula pasted into a workbook
- The report is bound to a worksheet, so the data stays in the place people already work
- The same Data Mart can also feed Google Sheets, Data Studio and AI assistants
R02 · Who it is for
Who Is Excel With OWOX For?
Finance and operations teams who report in Excel and need the numbers to be correct, explainable and defensible.
- Teams that rebuild the same export every week
- Analysts tired of being asked where a number came from
- Anyone who needs a refreshable report instead of a pasted CSV
R03 · Report
How a Report Gets Into a Worksheet
Excel works in pull mode. The add-in asks OWOX for the data when you refresh the report, and OWOX reads your storage.
- Sign in through the add-in.
- Select a published Data Mart.
- Set the columns, filters and sort order.
- Select Create & Run to fill the worksheet. The add-in binds the report to that worksheet.
A refresh rewrites only the imported columns. Columns and formulas you added to the right of them stay, the column order stays and the formats on imported columns survive.
R04 · Destination
What to Know Before You Start
- The Microsoft account in Excel must use the same email as your OWOX profile.
- The add-in runs in Excel on the web, in Microsoft 365 on Windows and Mac, and in Excel 2019 or later on Mac.
- You install it from the Office Add-ins store in Excel, or an administrator deploys it from the Microsoft 365 admin center.
- There is no scheduled refresh. You refresh manually while the workbook is open.
- A worksheet holds one report, and Excel’s own limit of about 1,048,576 rows applies.
- What a user can load depends on their OWOX access.
The Microsoft Excel setup guide has the details.
Why OWOX as a Companion to Excel
Traceable numbers
Every number comes from a Data Mart defined by your analysts, and the SQL behind it is visible.
Defined once
Analysts define metrics once. Business teams load them in Excel without rebuilding the logic.
One source of truth
The same Data Mart feeds Excel, Google Sheets and AI assistants, so the number matches across them.
Your data stays in your warehouse
OWOX does not keep a copy. The workbook shows what your storage returns when you refresh.
Your layout survives
Refreshes touch only imported columns, so your own columns and formulas stay put.
Less rework
Users change filters and columns in the add-in instead of asking for a new export.
Not testimonials. Comment threads.
Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.
Nodari RizunFounder & CEO, Pürblack®“AI, by the nature of the models, will hallucinate. And because of that, you need something which will create guardrails to ensure that there are no hallucinations, that you can trust your data.”
Mark SimmonsCMO, Pürblack®“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
Nodari RizunFounder & CEO, Pürblack®“We regained time. And time is the one resource that never comes back.”
Bring governed data into your workbooks
Connect your warehouse, publish a Data Mart and open it in Excel.
- Internal OWOX data as of 2026-10-02
- G2 reviews of OWOX
- npm installs stat