Pull Open Holidays data into Microsoft Excel
Explaining a sales dip by "it was a holiday" belongs in a column, not in a comment. Load Open Holidays into your data warehouse, flag orders and traffic by date, and pull the Data Mart into Excel.
Open HolidaysConnectedPublic Holidays
Microsoft ExcelDateIdNameDaily 09:00In the Microsoft Excel workbook, "it was a holiday" is a comment, not a column anyone can filter.
Paste this into your AI assistant. It loads Open Holidays into your data warehouse, flags orders and traffic by date, and pulls that Data Mart into Microsoft Excel through the add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/open-holidays-connector-to-microsoft-excel.md. The task: give me a Microsoft Excel workbook of daily orders and traffic with an Open Holidays column for each country, so I can filter holiday days out of the trend. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.
Why Open Holidays does not go straight to Excel
A holiday list can be typed into Excel, but not reliably, at scale or business-ready. Regional holidays differ by country, and a typed list is out of date next year. The data warehouse holds the calendar and joins it to orders and traffic first.
- Open Holidays publishes the calendar, not its effect on sales
- The data analyst joins holidays to orders and traffic by date and country
- The workbook separates a holiday dip from a real one
Open HolidaysHoliday calendarMicrosoft Exc…
Data warehouseJoined by idStep 1: Load Open Holidays into your data warehouse first
Open Holida…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksopen_holidays.public_holidaysStep 2: Link Open Holidays to orders and traffic
In your data warehouse the model joins the holiday calendar to sessions and store traffic by date and country code. Pick an industry to see the shape of its model.
- In the Retail model the calendar fills the is_holiday flag on Store Traffic
- Orders and sessions join by SQL keys, not by eye
- conversion_rate is defined once
Open HolidaysPublic HolidaysStep 3: Pull Open Holidays data into Excel with the add-in
In Excel, add the OWOX Data Marts add-in and sign in. Choose the published Open Holidays Data Mart (Public Holidays), tick the columns you want and press Create & Run.
- Tick date, name, nationwide and type
- The workbook reads your data warehouse, not the holidays API
Microsoft ExcelYour columns staydatenamenationwideStep 4: Refresh the Open Holidays workbook when you need it
Refresh when you plan the next year. The imported dates update; the lift column you added keeps comparing holidays with other days.
- Your own holiday-lift formula survives
- Refresh is a click, with no job to run
Microsoft ExcelYour column staysdatenamenationwideYoursStep 5: Reuse Open Holidays inside OWOX MCP
The holiday Data Mart also works in OWOX MCP, your assistant for data. Request any report, chat with it, then get it in Google Sheets or Excel in one click.
- Ask how orders behave on holidays and other days
- Chat and workbook share orders_count
Google SheetsOpenExcelOpen
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.37.0Unchecking a column in the OWOX Extension no longer fails Save & Run
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
Why OWOX for Open Holidays in Excel
A typed calendar tab marks dates in Excel. OWOX makes the calendar a table that joins to your numbers.
- The calendar next to the numbers. Holidays join orders and traffic by date in your data warehouse.
- Nationwide or regional. The nationwide and type fields separate a public day from a local one.
- Your columns stay. A refresh updates what the add-in imported and nothing around it.
- Maintained for you. No list to retype when the year turns.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.