Skip to content

Free tool

Registration data converter: turn a spreadsheet into a standard file

Moving to new software, sharing records with a partner or keeping your own backup? Put your families in the free spreadsheet template and convert it to a standard file. It runs in your browser, so nothing is uploaded.

Convert a spreadsheet

Fill in the participants template (one row per child, save as CSV), then choose it here.

Check a file

Check that an Open Youth Registration file has the required parts.

This file holds sensitive information about children. Keep it somewhere safe and share it only with people who need it.

The converter runs in your browser. Your spreadsheet isn't uploaded anywhere.

Good to know

How it works

The converter reads the participants template: one row per child, with a family ID that links siblings. It groups rows into families, turns allergies, medications and contacts into structured fields, and flags missing names and dates it can't read.

The file it makes follows the Open Youth Registration format, so tools that support the format can read it.

Check a file looks for the required parts. For a full check, run the file against the published JSON schemas with any JSON Schema validator.

FAQ

Questions, answered

Which columns does it read?

The columns in the participants template. Put several allergies or medications in one cell, separated by semicolons. Columns it doesn't know are ignored.

Can BackPR import this file?

Yes. BackPR's free data import accepts it, as well as spreadsheets.

More free tools

Nonprofit status checkerCheck whether the IRS lists an organization as tax-exempt, by EIN or by name and state, and see whether it qualifies for free BackPR.
Credit card fee calculatorSee what credit card processing fees cost your program, and what families pay if you pass the fee on. Free calculator, no sign-up.
Payment plan calculatorSplit a camp or program fee into a deposit and equal payments, with dates. Free payment plan calculator, no sign-up.
Sibling discount calculatorCalculate family totals with a second-child discount and one discount for every child after that. Percent or dollar discounts. Free calculator.
Camp price calculatorFind the price per child that covers your camp or program costs, after grants, scholarship spots and credit card fees. Free calculator, no sign-up.
Scholarship budget calculatorFigure out what your program's scholarships will cost, how many children your funds cover and how much you still need to raise. Free, no sign-up.
Enrollment forecast calculatorEstimate next season's enrollment, waitlist and revenue from last year's numbers, your return rate and new sign-ups. Free calculator, no sign-up.
Grant budget calculatorBuild a simple program budget for a grant: wages, fringe, supplies, indirect costs, cost per child and the amount to request. Free, no sign-up.
Childcare receipt generatorMake a printable childcare receipt parents can use for a dependent care FSA or the federal child and dependent care credit. Free, no sign-up.
Staff-to-child ratio calculatorPick your state and enter how many children you have by age. See how many staff its child care center ratios require, with the rule and source.
Family profile for camps and programsEnter your kids' allergies, medications, emergency contacts and pickup list once. Print a summary to copy from or hand in. Free and private.

Open registration
with BackPR

Free for nonprofits. No long-term contract. We set you up and import your data at no cost.

Get startedBook a demo