Short answer

Download calendar week data

Export verified year weeks as PDF, XLSX, CSV, ICS, SVG, JSON or XML.

Related tools

Short answer

Every format uses the same normalized week ranges and localized labels.

How it works

Select a year, language and format; the server controls filenames and media types.

Pick a format for your task

Use PDF for printing, XLSX for editing, CSV for exchanging table values, JSON/XML for software, SVG for scalable artwork and ICS for all-day week events. Choose the year and language before downloading.

An ISO-year file can include dates in the preceding December or following January. The CSV file is a week table, not a Google Calendar import template. Use ICS for calendar imports.

ISO weeks in Excel

For a real date in A2, use =ISOWEEKNUM(A2) or =WEEKNUM(A2,21). Return type 2 starts on Monday but does not apply the ISO week-1 rule. Function names and argument separators depend on the spreadsheet language settings.

Keep the ISO week-year with the number: 1 January 2027 is 2026-W53. The downloadable XLSX week list already contains calculated values and needs no formula.

=ISOWEEKNUM(A2)
=WEEKNUM(A2,21)

Microsoft: WEEKNUM systems and return types ↗

Import an ICS file into Google Calendar

On a computer, open Settings → Import & export, select the downloaded ICS file and choose the destination calendar. Try a separate calendar first so the result is easy to review.

Importing a file creates a snapshot, not an automatically updated subscription. Check existing events before importing again.

Google Calendar: import events ↗

Show week numbers in Outlook

In new Outlook, open Calendar settings from View, then Calendar → View → Show week numbers. In classic Outlook, use File → Options → Calendar → Display options.

Also check the first weekday and week-1 rule if numbers disagree. Compare 1 January 2027 = 2026-W53 and 4 January 2027 = 2027-W01. Importing ICS adds events; it does not change these settings.

Microsoft: week numbers in Outlook ↗

Excel: ISO week, week-year and Monday

A2 must contain a real date. B2 returns its ISO week, C2 its ISO year and D2 its Monday. For 1 January 2027 the results are 53, 2026 and 28 December 2026. Shifting to Thursday identifies the week-year; YEAR(A2) alone does not.

Guard empty inputs, for example =IF(A2="","",ISOWEEKNUM(A2)). Twelve boundary cases, a changed input and blank cells were recalculated in the local Excel fixture. Convert imported text such as “01/02/2027” to an unambiguous date first.

B2: =ISOWEEKNUM(A2)
C2: =YEAR(A2-WEEKDAY(A2,2)+4)
D2: =A2-WEEKDAY(A2,2)+1

Microsoft: ISOWEEKNUM ↗

Google Sheets: function language and imported dates

The formulas below use English function names. Spreadsheet locale affects date display and separators; function language is a separate setting. Some locales require semicolons instead of commas. Do not assume that Excel’s displayed function names apply unchanged.

ISOWEEKNUM supplies the number only; calculate the ISO year separately. Check imported CSV types and year boundaries. These Sheets recipes were checked against documentation, not executed in a cloud sheet.

=ISOWEEKNUM(A2)
=YEAR(A2-WEEKDAY(A2,2)+4)
=A2-WEEKDAY(A2,2)+1

Google Sheets: locale / function language ↗