Import your families
In short: Bring children and parents into Academy from a spreadsheet or a Google Sheets link. You check every row first, parents get no email, and you can undo.
If your children and parents already live in a spreadsheet, you do not need to type them in again. Import them in one go, look over every row, and only then save. Parents are not emailed, so you decide later when families hear from you.
Where to find it
Import & export. When Academy is on, the page opens with Bring your families in at the top. The shop import tools (Shopify, WooCommerce and others) are below, under Shop items and other stores; most academies can skip those.
Only owners and admins can import. Other roles can see the page and are offered a short message to copy and send to the owner.
Academy pages show in your menu only when Academy is on. The store owner or an admin turns it on in Settings → Academy.
Import from a file
- Get your list ready. One line for each child, with the child's name, the parent's name and the parent's email. Optional columns: parent phone, birthday, allergies and notes. Press Download the ready-made sheet to see the headings. It works with Excel, Google Sheets and Numbers.
- Choose your spreadsheet. Save it as CSV first (in Excel: File, Save As, "CSV (Comma delimited)"; in Google Sheets: File, Download, Comma-separated values). PersonaCart matches your column names automatically and shows you which column it used for each field.
- Check and save. Every family is shown before anything is saved, in three groups: Ready, Needs a fix and Already here. Use Fix on a row to correct it (a missing child or parent name, an unfinished email, a birthday that is not a real date). A fix changes only the check on screen. Your file on your computer does not change.
- Press Add N students. Rows that still have a problem are skipped.
A file can hold up to 1,000 children and 5 MB. For more, split it into two files.
If a parent's email already exists, the child is added to that family. You never get a second copy of the same family.
Import from a Google Sheets link
- Under Choose your spreadsheet, press Paste a Google Sheets link instead.
- In Google Sheets press Share, choose "Anyone with the link" as Viewer, and copy the link.
- Paste it into Link to your sheet and press Check my list.
- Look over the result. Nothing is saved yet.
- Press Add families (N). You can close the window; it keeps going.
When it finishes you see how many families were added. Parents get no email.
When it is done
You see how many students are in, how many were skipped, how many were already here, and any that could not be added with their line numbers. Phone numbers that could not be read are saved without a phone and the family is still added. Buttons take you on to Put them in teams or See your students.
Undo this import removes only the students from that file. It is available for 7 days, on the same computer you imported from.
Keep the page open while students are being added. If you leave, the students added so far stay, and you can choose the same file again. Nobody is added twice.
Moving from another app
For apps such as Jackrabbit, TeamSnap or iClassPro, open Moving from another app? and choose yours. It shows where to download your families as a spreadsheet (CSV), then you continue with step 2 above.
Download a copy of your data
Under Download a copy of your data, Families and students gives a spreadsheet you can open in Excel.
Questions
Will parents get an email when I import?
No. Nothing is sent. You decide later, from Students, when to contact families.
I imported the wrong file. What now?
Press Undo this import on the finished screen. It removes only the students from that file and works for 7 days on the same computer.
My file says it cannot find the parent email column.
The list needs a column with the child's name and one with the parent's email. Download the ready-made sheet to see the headings.
Can I import teams or classes this way?
No. This imports children and their parents. Place children in teams afterwards with Assign many on the Students page.