Standard CSV
For spreadsheets and custom imports
For Swiss exports, use the neutral column structure when you want to filter, compare or map the data yourself. Choose the delimiter and content language expected by the receiving system.
Export
Data export
Download Swiss public holidays, regional days and school breaks as CSV or iCalendar for Google Calendar, Outlook, Apple and business systems.
Selected profile
Google Calendar
For a one-time Google Calendar import
Google Calendar imports CSV files as a snapshot. Remove an earlier import before repeating it, or use a calendar subscription when dates should update automatically.
Outlook
For Outlook calendars
The iCalendar profile works with Outlook desktop and web calendars. It is a one-time file import; use the subscription option for an updating calendar.
Apple Calendar
For Apple Calendar and iCloud
Import the iCalendar file into a dedicated calendar so it can be replaced cleanly. A WebCal subscription is preferable when ongoing updates matter.
SAP HR
For an SAP-oriented mapping
This unofficial CSV profile provides a practical starting structure. Verify field names, date formats and holiday-class mappings against the target SAP configuration before importing.
SAP SuccessFactors
For SuccessFactors preparation
Use this unofficial profile as a mapping aid, not as a guaranteed direct import. Confirm the required object fields and locale conventions in your tenant.
DATEV
For DATEV-oriented processing
The unofficial DATEV profile is intended for structured handoff and may require field mapping. Compare it with the import definition used by your DATEV product.
BMD
For BMD-oriented processing
Use the unofficial BMD profile as a prepared CSV base. Check delimiter, date representation and required columns against the configured BMD import.
Personio
For Personio preparation
The unofficial Personio profile supports a clean intermediate export. Validate the target attributes and absence rules before using it in an employee-calendar workflow.
Lexware
For Lexware-oriented processing
Use this unofficial CSV structure as a starting point and compare its columns with the exact Lexware import workflow in use.
Ongoing updates
Subscribe instead of downloading again
Use a WebCal subscription when holidays and regional days or school breaks should stay current in Apple Calendar, Google Calendar or Outlook. Select the Swiss canton represented in the receiving system.
Connected planning pages
Check exact pages before exporting
Exports are snapshots. Use the related planning, subscription, school-break or event pages when that context is available. A Swiss export freezes the selected canton and years until a fresh file is created.
Calendar subscription
Use stable feeds instead of snapshots.
Planner
Choose vacation days before exporting.
Calendar weeks
Coordinate quarters and week numbers.
Sports break
Check canton-specific school-break timing before exporting.
Christmas break
Handle year-crossing school breaks.
Easter context
Review movable spring dates before exporting.
Clock changes
Add clock-change context to calendars.
All events
Open the planning-relevant event overview.
Export guidance
Export holidays for Switzerland
For Swiss exports, the right format depends on whether the dates will be opened in a calendar, processed in a spreadsheet or transferred to an HR system. Region, year range and selected content determine whether the resulting file fits the intended workflow.
CSV or iCalendar
For Swiss exports, CSV is intended for Excel, Google Sheets, reporting and structured imports. Delimiter, content language and column profile can be matched to the receiving system. iCalendar is the better choice for a one-time import into Outlook, Apple Calendar or another calendar application.
File export or subscription
For Swiss exports, a downloaded CSV or ICS file is a snapshot of the selected data. Create a new export when the year range, region or source data changes. Use a WebCal subscription instead when the calendar should remain connected to the current holiday and school-break data.
Select content and regional scope
For Swiss exports, public holidays and regional holidays can be selected separately. Religious observances and awareness days are optional. School breaks can be included when complete reviewed data exists for every selected year. Check the relevant region before using the file for staffing or operational planning.
Calendar and business profiles
For Swiss exports, profiles for Google Calendar, Outlook and Apple Calendar choose practical file settings for those applications. The DATEV, BMD, Personio, Lexware, SAP HR and SuccessFactors profiles are unofficial mapping aids. Their fields must still be checked against the exact import definition of the target system.
FAQ
Common questions about data export
Short answers about profiles, iCalendar, school breaks and delimiters.
Which export profile should I choose?
For Swiss exports, use Google CSV or iCalendar for Outlook and Apple for personal calendars. Use the default CSV or an enterprise-oriented profile when the data will be imported into HR, ERP or reporting systems.
Can school holidays be included?
Yes, when every selected year has complete reviewed school-holiday coverage for Switzerland. The control is unavailable for unsupported ranges.
Why are delimiters selectable?
For Swiss exports, some spreadsheet and enterprise tools expect commas, while German-language Excel setups often work better with semicolons. Choose the delimiter that matches the target system.
Data basis
Snapshot exports from the shared date basis
CSV and iCalendar downloads use the same source-backed date data for Switzerland as the website. Refresh exports when years, content types or source data change.