Skip to content

Importing from CSV

If your agenda already lives in a spreadsheet, don’t retype it. Agendas → Import CSV creates a whole agenda — items, times, sub-item loops, and participants — from one paste.

  1. Make sure your sheet has a header row with at least title and expected columns.
  2. Copy the cells and paste them into the Agenda CSV box (a paste from Excel or Google Sheets is tab-separated — that’s fine).
  3. Give the agenda a title and click import. Fix any per-line errors it points out, and paste again.

Optionally pick a template from the Start from a template dropdown first — it fills the box with the template’s CSV, which you can still edit before importing.

  • The first row is a header. Column names are matched ignoring case, spaces, underscores, and dashes, in any order: title, min, expected, max, person, sub label, sub min, sub expected, sub max. Unknown columns are ignored (so extra spreadsheet columns don’t hurt).
  • title and expected are required — as columns, and on every row.
  • The delimiter is auto-detected per paste: tab, semicolon, or comma all work.
  • Quoted fields work as usual ("a, b" keeps its comma; "" inside quotes is a literal quote). Blank lines are skipped.
  • Times are minutes from 0.5 to 600 in half-minute steps10 or 10.5, not 10.25.
  • A name in person creates that participant on the new agenda and assigns the row’s item to them. The same name on several rows becomes one person.
  • Filling sub expected (optionally with sub label, sub min, sub max) gives the item a sub-item loop.

The first rows of the built-in Toastmasters template:

title,min,expected,max,person,sub label,sub min,sub expected,sub max
Opening and welcoming guests,2,3,5,President,,,,
Introduction by the Toastmaster of the Evening,2,3,4,Toastmaster,,,,
Helpers introductions: timer / grammarian / ah-counter,3,4,5,,Helper,1,1.5,2
Word of the day,1,2,3,Grammarian,,,,
Prepared speeches,2,3,4,Toastmaster,Speaker,5,6,7

Importing this creates five items; “President”, “Toastmaster”, and “Grammarian” appear on the participant roster and are assigned to their items; “Helpers introductions” and “Prepared speeches” get sub-item loops (Helpers at 1/1.5/2 minutes each, Speakers at 5/6/7).

The full 12-item version is in the CSV reference — and ships as a ready-made template when the sample data is seeded.

Export CSV on any agenda produces exactly this format, so export → edit in a spreadsheet → import is a natural workflow for recurring meetings.