Import from a spreadsheet
For community leaders. Build your task sets or your program in Google Sheets or Excel, then bring them in.
How it works
- Download a template below and fill it in. One row per item.
- Save it as CSV (Google Sheets: File › Download › Comma-separated values), or copy the rows.
- In the leader portal, open Plan › Task sets (or Plan › Program) and choose Import from a spreadsheet.
- Upload the file or paste the rows. Any problem is shown on its row, like “Row 14: ‘Thurz’ isn’t a day”. Nothing is saved until you import.
Task sets arrive as drafts. A set with a send date sends itself on that day. Changed your mind? Undo import removes every set from that import that hasn’t been sent yet.
Already have sets or a program? Download as CSV next to the import gives you what you have in the same columns, so you can edit it in a spreadsheet and bring it back.
Task sets
Rows with the same set become one set, in order.
| Column | What goes in it |
|---|---|
set | The set’s name, up to 80 characters. Required. |
item | The task or habit. Required. Up to 50 items in a set. |
type | task or habit. Blank is a task. |
days | Habits only: every day (or blank), day names like Mon Wed Fri, weekdays or weekends. |
quantity | How many times, 1 to 99. Blank is 1. |
notes | Anything members should know. |
audience | participants (the default) or viewers. Your community’s own words work too, like Students or Parents. A set for viewers holds tasks, not habits. |
groups | Your community’s groups, separated by ;. A group that doesn’t exist is refused, and the message lists the real ones. |
send_on | Optional date it sends itself, 2026-11-23 or 11/23/2026, in your community’s time zone. |
A set’s audience, groups and send date can go on any of its rows, as long as they agree.
Programs
The program loads into the program editor so you can look it over; it’s saved when you press Save program. Tracks, stages and items are matched to your program by name, so members already on a stage stay where they are.
| Column | What goes in it |
|---|---|
track | The path members start on, like Foundations. Required. |
stage | A step on the track, like Week 1. Up to 12 stages on a track. Required. |
stage_days | How long the stage lasts, 1 to 365 days. Needed once per stage. |
item, type, days, quantity, notes | The same as for task sets. |
A track or stage you leave out of the file is removed when you save. If members are on it, saving stops and tells you, so nobody is dropped by accident.
Limits
Up to 1 MB, 2,000 rows and 50 task sets in one file. Questions? Write to us.
