Skip to main content

Import Your Dancers and Routines from StudioPro

Export your recital students and Excel Program List from StudioPro (formerly DanceStudio-Pro) and import your dancers, families and routines into ShowSculptor.

Written by Joe Naftal

If your studio uses StudioPro (formerly DanceStudio-Pro), you can bring your recital dancers, their families and your routines into ShowSculptor with two spreadsheets. It takes less than 10 minutes.

You'll download two files from StudioPro:

  • Student spreadsheet: your recital dancers with their parent and medical details.

  • Excel Program List: your recital acts and which dancers are in each one.

You can import either file on its own, but uploading both together is what places your dancers into their routines.

Step 1: Export your students from StudioPro

  1. In StudioPro, go to the Students page and click More above the student list.

  2. Next to Check all that ___ marked for the recital, choose are. This checks every student in your recital.
    ​

  3. Click Student Actions, then Send selected Students to…

  4. Click Excel, then click + More to see all of the fields.

  5. Check the fields ShowSculptor uses (see the list below), then click Send to download the Excel file.

Which fields to check

  • Required: First Name and Last Name.

  • Parent details: Parent First Name, Parent Last Name, Parent Phone, Parent Phone 2 and Parent Email.

  • Dancer details: Birthday, Medications, Allergies, Special Needs, Doctor and Emergency.

You can leave everything else unchecked (like Address, Balance, Tuition and Classes). ShowSculptor doesn't use those fields, and leaving them out keeps your file simple.

Step 2: Download your Excel Program List

  1. In StudioPro, open the Recital Wizard for your recital.

  2. Go to step 4, Generate the playbook.

  3. Click More Actions, then Download Excel Program List.

This file lists each Act Name, Song, Class Name and the name of every student in the act. There's no need to edit it before importing.

Step 3: Import both files into ShowSculptor

  1. In ShowSculptor, go to People > Import Data.

  2. Scroll to the DanceStudio-Pro (StudioPro) section.

  3. Under 1. Student spreadsheet, choose the student file from Step 1. ShowSculptor will show how many students it found.

  4. Under 2. Excel Program List, choose the file from Step 2. ShowSculptor will show how many routines and dancer spots it found.

  5. Click Import.

When the import finishes, you'll see a summary of the families, dancers and routines that were added or updated, and how many dancers were placed in routines.

Tip: Not sure where something is in StudioPro? Hover over the info icon next to each upload for a quick reminder of these steps.

What gets imported

  • Dancers: first and last name, birthday, and medical details. Medications, allergies, special needs, doctor and emergency info are combined into the dancer's medical info.

  • Families: one family per parent email, with parent name, phone numbers and email. Siblings who share a parent email are grouped into the same family.

  • Routines: one routine for each Act Name, with the song saved in the routine's sound notes.

  • Dancers in routines: each student on the Program List is added to their routine.

Routines aren't added to a show during the import, so your next step is adding your routines to your show.

Good to know

  • Safe to run again. Dancers and routines are matched by name, so importing again updates what's already there instead of creating duplicates. Blank cells never erase details you've already entered.

  • Names need to match. Dancers on the Program List are matched to your student spreadsheet by first and last name. If a name doesn't match (for example, a nickname or a typo), it's listed in the import summary. Fix the spelling and import again, or add that dancer to the routine by hand.

  • "No students found"? Make sure First Name and Last Name were checked when you exported from StudioPro.

  • "No routines found"? Make sure you uploaded the Excel Program List from step 4 of the Recital Wizard, not a different report.

Did this answer your question?