🚚

Data Migration & CSV Import Toolkit

Seamlessly transition your studio from legacy software like Mindbody, Jackrabbit Dance, StudioPlanner, or custom Excel spreadsheets.

Teacher App — CSV Import & Intelligent Column Auto-Mapper
Source FileValidated
📄
mindbody_roster.csv482 Rows • 124 KB
Detected Platform:Mindbody Export
Valid Records:479
Duplicate Warnings:3 (Auto-Merged)

Intelligent Column Auto-Mapping

Headers from your CSV mapped automatically to Studio Management PRO data fields.

First_NameFirst Name
Sample: "Aaliyah"
Primary_PhonePhone (E.164 Cleaned)
Sample: "+1 (868) 723-9910"
Remaining_CreditsClass Pass Credits
Sample: "10 Credits"
All 14 standard columns verifiedEdit Custom Field Mappings

Overview

The Data Migration Toolkit allows studio directors to import years of student history, active class passes, and lead pipelines from legacy software in minutes without data loss.

---

1. Supported Platforms & Export Formats

Our ingestion parser natively understands export schemas from the following studio software:

Mindbody Online

Directly accepts Client Roster (.CSV) & Pricing Option balance exports.

Jackrabbit Dance

Imports student birthdates, guardian contacts, and family account links.

StudioPlanner & ClassBuzz

Pre-configured header mapping for Caribbean and UK dance academies.

WellnessLiving & Glofox

Ingests active memberships, expiry dates, and emergency phone numbers.

Generic Excel & Google Sheets

Download our formatted CSV template and paste your custom student database.

Martial Arts Belt History

Import belt ranks, award dates, and certificate IDs in bulk.

---
Teacher App — Database Optimization & Cursor Pagination Sync

Active Student Optimization (Phase 2 Indexing)

Recalculates timestamp boundaries across student passes for high-speed cursor pagination.

Ready to Run
Indexed Target:Tenant Firestore Collection (/tenants/[tenantId]/users)
Batch Processing:500 Records / Atomic Chunk
Non-destructive calculation • Zero downtime
---

2. Step-by-Step CSV Migration Workflow

  1. Export from Legacy Provider: Download your client list as a .CSV file from Mindbody, Jackrabbit, or your spreadsheet.
  2. Upload File: In Studio Management PRO, go to Data Migration and drop your CSV into the upload pane.
  3. Verify Column Mapping: Review the auto-detected columns. If your legacy column was named Mobile_Phone_Num, confirm it maps to Phone.
  4. Sanitization & Deduplication: The parser automatically cleans whitespace, formats phone numbers to standard international formats, and detects duplicate email addresses.
  5. Execute Batch Import: Click Start Import. Data is written to your dedicated tenant database in atomic batches of 500 records.
---

3. Active Student Optimization & Indexing

After importing thousands of student records, run the built-in Active Student Optimization migration. This server process inspects every imported pass and calculates the activeUntil timestamp, enabling instant sub-millisecond search and pagination across active rosters.

💡

Need custom migration assistance? Contact Studio Management PRO support for complimentary white-glove migration assistance if migrating over 1,000 active students.