Switching from Google Sheets to Remote Coach Desk
Turn a coaching spreadsheet into a Desk roster and week-one program with the Settings CSV importer.
Loading…
Turn a coaching spreadsheet into a Desk roster and week-one program with the Settings CSV importer.
Google Sheets is an honest starting system: one tab for athletes, one for the week’s lifts, maybe a checkbox column for “done.” It breaks when check-ins live in chat, form clips live in Drive, and Monday triage means filtering three tabs. Remote Coach Desk is built so log the session, Reviews, and the week board share one roster. This guide assumes you already have a sheet. No invented “average coach” stats, testimonials, or user counts — just columns, Settings → Switching, dry-run, and a portal log the session week-one validation loop. Sheets is not a vendor with a secret CSV schema; your headers are whatever you typed. The Google Sheets preset maps common Name / Email shapes; Generic covers Athlete / Mail and other labels. Preview always.
Done means: athletes open a Desk portal, Today shows a real session (or rest), log the session lands on the desk, and the sheet’s “done” column is retired for active athletes. Keep a read-only archive if you want history. Do not keep a parallel checkbox athletes still tick — dual adherence recreates the stall you were trying to leave. Pilot one athlete first. Check Solo seat headroom before importing a large roster tab. Seat caps gate imports the same way as manual invites. Write the athlete message before you paste: new portal link, log the session after sessions, sheet checkboxes retire on date X.
Roster tab: Name, Email, optional Notes, Tags. Export → File → Download → CSV (or File → Download from the sheet). Program tab: Day, Exercise, Sets, Reps, RPE, optional Load. Library tab (optional): Name, Demo URL (https only), Notes. The Google Sheets preset in Settings maps those headers automatically. If you used Athlete / Mail instead of Name / Email, switch to Generic and confirm the preview mapping before apply. There is no single public “Sheets coaching schema” — your column names are local. Dry-run exists to show what the mapper understood. Strip currency, payment, and private medical columns before paste. Formulas will not execute in the importer — paste values you care about, or retype one microcycle into Day / Exercise / Sets / Reps / RPE / Load. Normalize emails (lowercase, no spaces) so dry-run errors stay about real issues.
Open Settings → Switching. Choose Google Sheets (or Generic). Paste roster CSV → preview shows mapped columns and error rows (bad emails, missing names, duplicates, already on roster). Fix the sheet or the mapping, then Apply roster without email. Copy portal links when you message athletes — no-email apply keeps the conversation on your timeline. Dry-run the program CSV; open Programs → New block for week one with real session names. Import library rows for https demos when you use them. Re-running the same CSV skips existing emails/names — idempotent on purpose so you can fix three rows and apply again. If seat-cap errors appear, resolve plan seats before promising more start dates. Read the accuracy strip: we map common headers; we do not invent an official spreadsheet schema for every coaching sheet on the internet.
Same validation as any go-live: portal opens on the athlete’s phone, Today shows a session or honest rest, timezone is set, log the session lands on the desk after a real training day, optional clip clears in Reviews. Show /portal recovery with the invited email. Only then retire the sheet checkbox for that athlete and expand the roster. If the gym wifi dies mid-tap, teach Sync / offline queue rather than inventing a chat “done.” Keep form clips on the portal Reviews path instead of a Drive folder the desk cannot see. Monday Inbox should replace filtering three tabs. Habits, intake, and nutrition can follow after log the session is reliable — do not stack every sheet column into week one.
Archive: File → make a read-only copy dated on cutover week. Active ops: Desk roster, assigned blocks, log the session, Reviews. Do not delete the archive if you need old load history — just stop treating it as the live board. If a coach teammate still edits the live sheet, you do not have a cutover yet. For formulas you loved (estimated tonnage, custom flags), recreate only what you will read weekly — as Desk custom fields, Insights, or a note on the athlete — not as a second system of record. Depth is one board, not clever sheets beside an empty portal.
Monday: export CSV, dry-run, no-email apply for the pilot or planned cohort; assign week-one blocks. Training days: log the session on the portal; ignore the old checkbox. Mid-week: one form clip if needed; clear Reviews. Friday: confirm archive sheet is read-only; message remaining athletes with portal links and retire date. Next Monday: triage on Inbox only. If someone never opened the portal, resend the invite — do not re-open the checkbox “temporarily” without a new retire date. Temporary dual systems become permanent stalls.
Sheets can hold formulas the importer will not execute. Currency, private medical notes, and payment columns should not be pasted. Seat caps still gate imports. Competitor product cutovers use the same Settings → Switching importer with TrueCoach / Trainerize / Everfit accuracy copy — this Sheets guide is for coaches whose system of record was a spreadsheet, not a slam on any vendor. No invented conversion rates. No testimonials. Point comparison curiosity at /compare for public-doc citations when you are evaluating other tools; for Sheets, the proof is portal log the session on your own roster.
The sheet’s “done” column was a proxy for adherence. log the session on the portal is the Desk equivalent — one primary action after the session, optional RPE/note, rest days honored when the block says rest. Teach athletes that sentence once. Do not ask them to tick the sheet and log the session “just this week.” When a miss appears on Monday, use Inbox and missed-yesterday recovery where available. Do not rebuild a filter view on the archive sheet to decide who trained. If timezone is wrong, fix the athlete detail before you lecture compliance. Civil dates are part of the switch from sheets, where “yesterday” was often whoever opened the file last. Form clips leave Drive folders and land in Reviews. Clear oldest-first mid-week. The week board plus Reviews replaces the three-tab Monday ritual the opening section described.
Pitfall: applying without dry-run. Fix: preview mapping and clear error rows first. Pitfall: parallel “done” checkboxes forever. Fix: retire date + log the session only on the portal. Pitfall: pasting formula columns and expecting results. Fix: values or a retyped microcycle. Pitfall: importing everyone before one log the session. Fix: pilot week-one validation. Pitfall: medical/payment columns in the paste. Fix: Name/Email (+ optional Notes/Tags) only. Pitfall: empty Today after roster import. Fix: program dry-run and publish a real block. Pitfall: seat-cap mid-import. Fix: check Solo/Studio seats first. Settings → Switching, dry-run, no-email apply, and portal log the session week-one validation turn a coaching spreadsheet into a desk you can triage on Monday — without inventing stats, testimonials, or slam copy about other tools.
More guides