Migration story
The Google Sheets Alternative for Community Bands & Choirs
You started with one spreadsheet. Now there are nine. Backstage Baton imports them in a weekend. The patchwork goes in the recycle bin.
90-day free trial · No credit card · Smart Import from CSV / XLSX / PDF / DOCX / photos
Why community bands outgrow Google Sheets
Spreadsheets work for the first 30 members and the first season. After that, the math stops working.
One person can hold 30 names, 50 pieces of music, and a single concert program in their head and catch their own drift. That's why a spreadsheet works at that scale — the human is doing the data integrity work the system can't. At 50 members, 200 pieces, two ensembles, and a librarian who doesn't talk to the membership coordinator every week, the integrity work collapses. Two spreadsheets become inevitable. Then three. Then nine, and nobody knows which one is current.
The specific failure modes that show up in every community band that overstays on spreadsheets:
- Member updates their email address. Coordinator updates the master roster. Director sends Wednesday email from a copy of the roster that's two weeks old. Member doesn't get it. Loses trust.
- Two coordinators edit different copies of the roster at the same time. Both save. One overwrites the other. Hours of work lost. Nobody notices for a week.
- New member joins at the picnic in August. Added to roster that night. Two weeks later, has never received any communication from the band. Stops coming.
- Grant deadline in November. Treasurer assembles last year's audience numbers from a paper sign-in sheet, a Google Form, a Venmo donation list, and somebody's memory. The number is a guess. Funding decision is based on it.
- Librarian retires after 9 years. Hands the binder + spreadsheet + email archive to the new volunteer. New volunteer doesn't know what column COMP means. Quits in 6 weeks.
What you actually need (and Google Sheets can't give you)
The capabilities that emerge naturally once you cross the threshold — impossible to keep in a spreadsheet without it becoming a part-time job.
One source of truth for the roster
Every officer sees the same data, with edit history. No more “which file is current?”
Role-based access
Treasurer sees billing data; librarian sees the music catalog; section leader sees their section's contact info. None of them see what they don't need.
Automated communications
Weekly digest goes out without manual BCC. New-member onboarding emails fire automatically. Day-of rehearsal reminders happen without anyone's involvement.
Music library with metadata + checkout
AI-enriched catalog. Coverage gap reports. Librarian checkout flow. Smart Import from your existing inventory sheet.
Performance + rehearsal scheduling tied to the calendar
Members subscribe to a personal calendar feed once. New dates appear automatically. Cancelled events disappear. They don't have to ask.
Attendance + audience tracking for grants
Tap-once-per-person audience counter at concerts. Section leaders take rehearsal attendance in 30 seconds. Grant report builds itself.
Mobile experience members actually use
Installs to the home screen on iPhone + Android straight from the browser — no app store. Tonight's rehearsal card, day-of RSVP, swipe-to-contact. Members live on their phones; software should too.
Audit log for accountability
Every change to member records, performances, setlists, and rehearsals is logged with who, when, and what. Defends the band in disputes; supports the board in oversight.
The migration is a weekend, not a month
The most common reason community bands stay on spreadsheets is fear of the migration. Here's how it actually goes.
Export your spreadsheets
Open each Google Sheet, File > Download > CSV. Save them somewhere. That's the entire prep step. You don't need to clean them up first.
Start the trial
Sign up for the 90-day free trial. No credit card. Pick your plan (Essentials for single ensembles, Complete for multi-ensemble orgs).
Run Smart Import
Upload your roster CSV first. Smart Import reads the columns, figures out what they mean (even with weird names like COMP and GRD), catches duplicates, flags anything uncertain. You review, confirm, save.
Import the music library
Upload your music catalog. Same process. Smart Import also reads PDF and DOCX, so the 1998 paper catalog scanned to PDF works too. AI fills in metadata for pieces it recognizes.
Import performance history (optional)
If you want grant-report continuity, import your past performance list. Year, date, venue, audience count if you have it. Smart Import handles partial data gracefully.
Set up roles
Tag your existing members with their org roles — president, music director, librarian, treasurer, section leaders. The platform's 14 distinct roles map cleanly to community-band governance.
Configure communications
Set your weekly digest cadence (Wednesday prompt → Sunday send is the default). Enable SMS if you want it. Toggle which notification events fire.
Press Go Live
Until you press Go Live, nothing goes to members — you're building in private. When you flip the switch, every account you created during setup gets their welcome email. The band is on real software.
Most bands finish steps 1-3 on Saturday morning and the rest by Sunday afternoon. The 90-day trial gives you a full season to settle in before any billing decision.
Smart Import is the killer feature
Most migration tools require clean data. Smart Import accepts what you actually have.
What it reads
- · CSV — the standard export from any spreadsheet
- · XLSX — Excel files, including multi-sheet workbooks
- · PDF — scanned documents, exported spreadsheets, old reports
- · DOCX — Word documents with table-style member lists
- · Photos — pictures of paper rosters, paper catalog cards, paper program books
What it figures out
- · Column mapping even with weird names (COMP, GRD, CL_1, EMR_CN)
- · Duplicates across fuzzy matches (different spellings, nicknames)
- · Header rows in messy or multi-header sheets
- · Music metadata for pieces it recognizes (composer, arranger, grade, duration)
- · Instrument names normalized (“1st Cl.” → “Clarinet 1”)
What life looks like after the migration
Two weeks in, the most common feedback from community bands that have made the move.
- The Wednesday director email writes itself — the weekly digest sends automatically every Sunday.
- The membership coordinator answers texts again on Tuesday night — no more cross-referencing two rosters by hand.
- The librarian opens the dashboard, sees the 3 things that need attention, fixes them in 15 minutes.
- The treasurer opens the Grant Report when the SCFD deadline lands — the numbers are already there.
- Members install the app on their phones and stop asking “wait, where's rehearsal this week?”
- The president can hand the gavel to next year's president without a 3-hour knowledge transfer meeting — the whole org is in the system.
Keep reading
Diagnosis
5 Signs Your Community Band Has Outgrown Spreadsheets
If three or more describe your band, you're past the line.
Platform
Community Band Software
The full overview — what BSB is, who it's for, how it's different.
Pricing
Plans & Pricing
$39/mo Essentials, $79/mo Complete. 2 months free with annual. 90-day trial.
Frequently asked questions
Will I lose any data in the migration?
No. Smart Import preserves everything from your source files. Anything it's unsure about is flagged for your review before commit — nothing gets silently dropped or transformed. If you have years of historical data, all of it can come over.
What if my spreadsheet has columns Smart Import doesn't recognize?
It maps what it can and shows you the leftovers. You either map them to existing platform fields (custom-fields ARE supported in BSB), choose to skip them, or fix the source and re-upload. Most community bands find Smart Import auto-maps 80%+ of columns correctly on first try.
My catalog is in a Word document with embedded tables. Will that work?
Yes. Smart Import reads DOCX directly, extracts the tables, and maps the columns. Old program-book PDFs work the same way.
What about a paper roster I have to scan?
Scan it with your phone (any normal scanning app produces a PDF that works) or take photos of each page. Smart Import accepts photos and runs OCR. Image quality matters — clear, well-lit photos work best.
Can I import from multiple spreadsheets at once?
You import one file at a time, but you can chain imports. Many community bands import roster from one sheet, then music library from another, then performance history from a third. The platform deduplicates references across imports.
What if I want to keep using Google Sheets for some things?
You can. The platform exports to CSV at any time. Some treasurers like to keep a personal spreadsheet for their own workflow — pull the data from BSB monthly, work it locally, you're not locked in. The core data lives in the platform; export wherever, whenever.
I'm on a different tool (BandHelper, Bandforte, etc) — can I migrate from there?
Yes. Export your data from your current tool as CSV (every major band-management platform supports CSV export). Smart Import handles those CSVs the same way it handles Google Sheets exports. Most cross-platform migrations take 2-3 hours.
Retire the spreadsheets this weekend
90-day free trial. No credit card. Smart Import handles whatever you have.