One Google Sheet per event
CSV Template
Build the master template once: create a Google Sheet, then for each file below use File > Import > Upload > Insert new sheet and rename the tab to the name shown. After that, every new event is just File > Make a copy of the master.
Public tabs
| Tab name | What it does | Example |
|---|---|---|
| Settings | Event name, dates, time zone, venue, ticket link, social links, schedule options. Key / Value rows. | settings.csv |
| Brand Kit | Colors, Google Fonts and logo file names. Key / Value rows. | brand-kit.csv |
| Website | One row per page section. Rows with the same Page make one page; Menu Label / Order / Group build the menu (Group "More" makes a dropdown, "Footer" puts it in the footer). Section types: hero, header, text, card, ticket, person, faq, stat, group, video, image, map, buttons, sponsors. | website.csv |
| Days | The day markers used in the schedule (FRIYAY, SATURDAY, DAY 1...), their dates, banner labels, and whether they get a day tab. | days.csv |
| Schedule | Same layout as the ATX ROX schedule: a day marker row starts each day; C icon, D time, F title, G format, H/I artists, J room, M scoop (** banner only, * banner and card), N sponsor, O/P optional link and label. | schedule.csv |
| Sponsors | Name, Logo (file name or link), Link. | sponsors.csv |
| Rooms | Room names in filter order, with a description for the Ballrooms Guide. | rooms.csv |
Staff tabs only served after the staff passcode
| Tab name | What it does | Example |
|---|---|---|
| Staff Matrix | Same layout as the ATX ROX staff matrix: the schedule columns, then one column per staff member (names in the header row from column K on) holding role codes like CJ, J, F, L, DJ, MC, W. | staff-matrix.csv |
| Staff Info | Section / Label / Detail / Icon rows for the portal: welcome, hq, call_times, fun, legend (extra role codes), legend_note. | staff-info.csv |
| Meals | ATX ROX layout: C day marker, D meal, E start, F end, G food. | meals.csv |
| Rooming | ATX ROX layout: A name, C room, D-I nights marked X (the header row names the nights). | rooming.csv |
| Rides | The airport rides form layout: name, arrival needed/day/time/flight/driver/phone, departure needed/day/time/driver/phone, notes. | rides.csv |
Meals, Rooming and Rides can also live in other workbooks (like a Google Form's response sheet). On the event page, choose "Paste a CSV link" for that tab and paste its own published CSV link.