Help · Committees · Calendar
Import or export the calendar
Load a whole season of runs from a spreadsheet, or download the calendar to work on. Importing needs the Editor or Owner role. Anyone on the committee can download it.
Import a spreadsheet
- Go to Schedule. In the summary strip at the top, choose Import or download a spreadsheet. If there are no runs coming up, it says Import a spreadsheet.
- The Calendar spreadsheet box opens. Choose Download a template for a spreadsheet to fill in.
- Use one row per run. Fill in the Date column. You can also fill in Time, Run, Code, Title, Standard, Long, Km, Long km, Type and Note. Leave Time blank for the club's usual time.
- Save it as a CSV file. Then, under Import a spreadsheet or calendar file, pick the file.
- Check the summary. It shows how many runs are in the file, their dates and how many have a route. It says the file replaces the runs on the calendar now, and how many "I'm going" will be cleared on dates that aren't in the file. Dates in both keep theirs. It also lists any route codes it couldn't find. Those dates are added without that route, so you can pick one afterwards.
- Choose Replace the calendar. Nothing changes until you do. The new calendar is on the club page straight away.
Standard and Long are route codes, like W5 or W5L, or GPX file names. Dates can be written like 06/10/2026 or 2026-10-06.
Importing replaces all the runs on the calendar. A spreadsheet leaves your events as they are. A calendar file (JSON) replaces the events too.
If the import would remove 10 or more dates, you'll be asked to confirm it's you.
Download the calendar
- In the Calendar spreadsheet box, Download the calendar (CSV) downloads every run, in the same columns as the template. If you can't change the calendar, the strip says Download as a spreadsheet, and it downloads straight away.
- The Season view's Export CSV downloads one season, including how many are going. See Plan the season.
- Owners can download everything, including the calendar, from Settings, under Your data. See Download everything your club has.
Related
- Add a run datePut a club run on the calendar with its route, long option, type and a note.
- Move or cancel a run and tell peopleChange a date's route, add a note, postpone or cancel it, and let everyone going know.
- Post your group's runsAs a group's organiser, add its dates to the Calendar (every week if you like), choose routes, share them to WhatsApp, and change or cancel them on the day.
- Add an eventPut a social, meeting or other non-run event on the club calendar.
- Plan the seasonUse the Month, Season and List views to see the whole season, fill the gaps with routes and copy a season forward.
Still stuck?
In the portal, use Ask at the top of the screen to ask a question in your own words. For anything else, contact the Club Routes team, or check Club Routes' status if something isn't working.