Project

Training Plan to Calendar

Upload your training plan spreadsheet — or paste a published Google Sheets link — and download a .ics calendar file you can import into Google Calendar, Apple Calendar, or Outlook.

← Back to Projects
How to use this tool +
1. Template format
2. Upload (Excel / CSV)
3. Google Sheets link

Your spreadsheet must use this exact layout

This tool only works with the correct template. Download the template below and fill it in — do not change the structure of the sheet, only add your training data.

Open template in Google Sheets → Download Excel template ↓
CellWhat to put there
C2Number of weeks in the plan (e.g. 16)
C3Race date
C4Plan start date (a Monday)
Row 6Header row — do not change
Row 7 onwardsOne row per training week. Col B = week label, Col C = Monday date, then alternating session / details pairs for Mon–Sun (cols D–Q), then Total / Details in cols R–S
Important: Dates in column C are automatically calculated from the plan start date — you don't need to fill these in yourself. Just enter data in the session and details columns (D onwards).

Option A — Upload a file directly

This is the simplest option. When you're ready, save your file and upload it below.

  1. Fill in the template (Excel or Google Sheets).
  2. If using Google Sheets: go to File → Download → Microsoft Excel (.xlsx) to save a copy.
  3. Click the upload area below and choose your file. Both .xlsx and .csv files are accepted.
  4. Set your options and click Generate.
Tip: In Google Sheets you can also download as CSV — go to File → Download → Comma-separated values (.csv). Either format works with this tool.

Option B — Paste a Google Sheets link

This lets the tool read your sheet directly, without downloading anything. It requires you to publish the sheet publicly first.

  1. In Google Sheets, go to File → Share → Publish to web.
  2. Under "Link", choose the sheet tab containing your plan (e.g. "Training plan to calendar").
  3. Change the format dropdown from "Web page" to CSV.
  4. Click Publish, then copy the link it gives you.
  5. Paste that link into the "Google Sheets URL" box below and click Fetch.
Note: Publishing to the web makes your sheet's data publicly accessible to anyone who has the link. Your training plan data isn't sensitive, but it's worth knowing. This is a different setting to the normal "Share" button — it creates a separate public URL.
Your Training Plan
📁
Click to choose file, or drag and drop
Accepts .xlsx or .csv files

Paste the CSV link from Google Sheets (File → Share → Publish to web → CSV). See the instructions above for the full steps.

✓ Calendar ready

Download .ics file

Import into Google Calendar: Settings → Import & Export → Import.
Apple Calendar: double-click the file.
Outlook: File → Open & Export → Import/Export → Import an iCalendar file.