Coming from Back On Stage

Back On Stage (BOS) is for bands and booking leaders. BOS is built for bringing data in, not sending it out: there is no native export and no public API. Operators usually still have the Google Sheet they (or BOS) used to load the product. Export or download that sheet to CSV/XLSX, then import through Settings → Data & knowledge → Import & export. There is no Back On Stage connector. Coming-from is CSV / guided export only. Empty-state Imports is drop-first. Drop files on the empty state; don’t lead with pick-target-first. There are no in-product “Coming from Back On Stage” cards. You can’t ingest BOS setlists as files. Booked roles / services / contracts do not come across from the Bookings sheet. Who can import (web UI): organization owner or admin on the active org. Shared mapping traps: Coming from another system.

Video walkthrough coming. Until it ships, follow the academy / template steps and screenshot Tips below.

Who it’s for

Band leaders and booking ops who already loaded Members, Bookings, and Songs into Back On Stage (or still have those Google templates) and want the same roster, songs, and bookings as gigs in Soundcheck.

What moves / what doesn’t

Source	Import target (UI label)	Notes
Members sheet	Crew	Required: First Name, Last Name, Email. Phone optional (numbers only)
Bookings (Leader) sheet	Events (+ Venues / Clients as needed)	Required starred fields below; booked roles / services / contracts do not come across
Songs CSV	Songs, then Setlists you rebuild	Song Title required; length as HH:MM:SS or total seconds; BOS has no CCLI field. Don’t invent one
Expense CSV	n/a	The only real BOS CSV export is expenses / payouts, not the gig calendar
BOS setlists	n/a	Setlist Builder has no CSV export. Rebuild Setlists after Songs

Academy / help path (not live BOS product UI)

The frames below are Back On Stage academy/help pages only. Caption them that way. An embedded in-app crop inside an academy article is still academy-embedded, not a live product session. Do not publish a Google account-picker shot as product UI.

Templates: Make a Copy → Download CSV

Open the Member or Booking Import Template (Google may require an account; not a public link). Spreadsheet IDs below are unchanged; Google URLs are not public.
File → Make a Copy, fill required * fields, then File → Download → Comma-Separated Values.
If Google is gated (account picker / invite required), BYO a sheet with the same verified headers and download CSV from that.

Bookings: academy import article

In BOS (if still active): Bookings → Sheet View → Import (academy crop shows Import Bookings). Academy still does not list booking template columns in prose. It marks required fields with asterisks only. Use the verified htmlview headers below for the column list.

Back On Stage academy help article How To Import Bookings: Make a Copy of the template, download CSV, then Bookings Sheet View Import. Embedded crop of Import Bookings is academy-embedded, not a live product session. — Back On Stage academy/help: How To Import Bookings (not live product UI)

Members: academy bulk upload

Academy Bulk Upload points at Get Member Import Template (Google Doc). File → Make a Copy. Do not touch headers in row 1. Google template URLs are not public (account picker). BYO the same headers if access is blocked.

Back On Stage academy help Bulk Upload section with Get Member Import Template Google Doc button and Make a Copy steps. Not live BOS product UI. — Back On Stage academy/help: Bulk Upload / Member Import Template (not live product UI)

Songs: academy repertoire CSV

Academy path: Repertoire Manager → CSV Import / Download Template. Song Length may be HH:MM:SS or total seconds (academy text often shows the seconds example). Setlist Builder has no CSV export. Rebuild setlists after songs land. BOS docs don’t offer a CCLI field. Don’t invent one on the way in.

Back On Stage academy help section Adding Songs In Bulk: CSV Import template columns and length guidance. Not live BOS product UI. — Back On Stage academy/help: Adding Songs In Bulk CSV import (not live product UI)

Academy text links:

Verified template headers (htmlview)

These headers come from view-only Google Sheets htmlview. Prefer them over earlier notes that said a combined “Location Name & Address” or a duplicate Doors header. Live docs.google.com template URLs often hit a Google account picker. Treat spreadsheet IDs as reference, not as public customer links. Prefer the sheet you already used to load BOS. If invite/account access is blocked, BYO a sheet with the same headers.

Members: tab “Member Import Template”

Spreadsheet ID (may require a Google account): 1MC2bvC54ZYZIKAZAdSw9MHSIXINZeAyHe-xrOtUaf3o

Column	Required?	Notes
First Name	Yes (`*`)
Last Name	Yes (`*`)
Email	Yes (`*`)	Hard-required for Crew import too
Phone	No	Header: “Phone (numbers only - no dashes, brackets or punctuation)”

Map into Crew. Skip nothing required; phone-only rows still fail on our side because email is hard-required.

Bookings Leader: tab “Bookings Import Template (Leader Accounts)”

Spreadsheet ID (may require a Google account): 1IuFY4kRaNDAS9VjOYAU_Leeryj2NPu3rN3S0d7GXWaw There is also a Musician Pro Accounts bookings tab. This guide covers the Leader Accounts template only. Required (*):

Event Date (yyyy-mm-dd)
Event Title
Client First Name
Client Email
Booking Status

Then (in template order):

Client Last Name, Client Phone, Client Company
Client Address, Client City, Client State/Province, Client Country, Client Zip/Postal
Location Name: a separate column (not a combined “Location Name & Address”)
Performance Room, Greenroom, Load-in, SoundCheck, Doors (one column, not a duplicate), End Time
Attire, Meal details, Backline & Production, Parking details
Notes for musicians, Admin notes (not shared with musicians)
Accommodation, Check-in time, Check-out time, Accommodation Notes
Show Description

Also present: Private Event (Enter Yes or No).

Field map (source → import targets)

Back On Stage column	Import target / field	Notes
First Name / Last Name / Email	Crew	Email hard-required
Phone (numbers only)	Crew phone	Reshape punctuation if needed
Event Date / Event Title / Booking Status	Events	Required on Leader template
Client First/Last/Email/Phone/Company/address	Clients (or metadata)	Prefer a Clients file first when you want directory matches
Location Name	Venues `name` / event location	Separate column, not combined with address
Load-in, SoundCheck, Doors	event key times Load in, Soundcheck, Doors	A time of day on the gig date. With no start or call time column, the gig starts at the first of the three that is filled
End Time	event `end_time` (or a cue’s `end`)
Accommodation*, Attire, Meal, Parking, Backline & Production, Performance Room, Greenroom, Private Event, Show Description overflow	metadata (or notes)	Hospitality extras aren’t first-class catalog fields
Notes for musicians	Events `notes`	When the mapper offers them
Admin notes	Events `admin_notes`	When the mapper offers them
Song Title / Artist / Length	Songs	Length: HH:MM:SS or total seconds. No CCLI
Booked roles / services / contracts	n/a	Defer. Do not invent
Setlists	rebuild	No BOS CSV export

The spreadsheet wizard maps Load-in, SoundCheck and Doors to the gig’s key times on its date. A cell it can’t read as a time on that date (TBD, 25:00, a different day) shows a warning, and the gig imports without that time. A SoundCheck or Doors time before noon that is earlier than the phase before it counts as after midnight, so Load-in 22:00 with Doors 00:30 puts doors at 00:30 that night.

Screenshot placeholder: Soundcheck Imports map with Location Name → venue and Load-in / SoundCheck / Doors → key times. Drop-first empty state.

There is no Google Sheets connector. Export or download the sheet to CSV/XLSX (.xlsx / .csv / .tsv / .txt only; ICS/webcal is rejected), then drop or paste in Settings → Data & knowledge → Import & export.

Recommended zip / sheet layout

season-bos/
  01-crew-members.csv
  02-songs.csv
  03-venues.csv              # optional extract from Location Name
  04-clients.csv             # optional extract from Client*
  05-events-bookings.csv     # Leader Bookings template shape
  06-setlists.csv            # rebuild after songs
  README.txt

Drop the zip or the CSVs on Settings → Data & knowledge → Import & export. Load order: Crew → Venues → Clients → Songs → Setlists → Events.

Mapping traps

BOS Phone on the Members template is numbers only (no dashes, brackets, or punctuation). Reshape if needed before map.
Song length: HH:MM:SS or total seconds.
Do not invent CCLI. BOS has no CCLI field in the docs, and the live Songs mapper has no CCLI column either.
Do not promise booked-roles, charts, or plan order coming across.
Practice / sample CSVs under docs/sample-imports/ use sample-import headers. You must still map BOS columns.

Full shared traps: Coming from another system.

Import order

Crew (Members)
Venues / Clients when you want directory matches from Location Name / Client*
Songs (then Setlists you rebuild; BOS Setlist Builder has no CSV export)
Events (Bookings Leader)

Canonical product order: Crew → Venues → Clients → Songs → Setlists → Events (Inventory and Leads when you need them).

Import path

Open Settings → Data & knowledge → Import & export. Drop or paste files on the empty state (drop-first). Review detected targets, map columns, preview, commit.
Crew need email (hard-required). Save a mapping template for the BOS sheet shape.
After commit: open Gigs, ask people to accept invitations, spot-check venues / clients / Show Prep, re-import once (expect 0 new rows).

One bad row doesn’t block the file: valid rows commit and rows with errors are skipped. Download the error CSV from the results screen, fix those rows, and import them again. See When a row is bad. Full wizard: Operator data imports. Season recipe: Importing your season.

FAQ

Is there a Back On Stage connector or API?

No. BOS has no public API. Coming-from stays on CSV / guided export into the wizard. No fake OAuth.

Where do Load-in, SoundCheck, and Doors go?

The spreadsheet wizard maps them to the gig’s Load in, Soundcheck and Doors key times on the gig date. They show on the gig’s details page and in the crew gig brief. Re-importing the same sheet changes nothing, and a key time someone set by hand in Soundcheck stays as they set it.

Do booked roles come across?

No. Defer booked roles / services / contracts. Rebuild staffing in Soundcheck after Events land.

Can I export setlists from BOS?

Setlist Builder has no CSV export. Import Songs, then rebuild Setlists.

First-week checklist after commit

Confirm Crew emails look right (phone-only rows should have failed).
Spot-check Venues / Clients from Location Name and Client* fields.
Confirm Songs lengths parse (HH:MM:SS or seconds).
Rebuild at least one Setlist.
Open a sample Event and check its Load in / Soundcheck / Doors key times.
Ask people to accept invitations; spot-check Show Prep.
Re-import the same files once (expect 0 new rows).
Save mapping templates for the BOS sheet shape.

Coming from another system

Hub for Planning Center, Back On Stage, Master Tour, and more

Operator data imports

Imports wizard, targets, and permissions

Overview

Account & profile

Home

AI assistant

Gigs

Contracts

Client portal

Setlists

Calendar

Mailbox

Availability

Chat

Mobile app

Everyday tools

Imports

Organization

Teams

CRM

Leads

Offerings

Coming from Back On Stage

Who it’s for

What moves / what doesn’t