Excel Import & Export — Your Data, Your Way

Here's the conversation that happens at every education center considering a new system: "But we already have everything in Excel." And it's true — years of student records, phone numbers, payment history, attendance logs. Hundreds, sometimes thousands, of rows of data built up over semesters and school years.

The thought of re-entering all of that manually is a dealbreaker. Nobody has the time or patience to sit and type in 300 student names, their phone numbers, their parents' information, one by one. So centers stick with their messy spreadsheets, not because they work well, but because switching feels impossible. Better the devil you know.

And there's another fear — a very reasonable one: "What if I move to this system and then want to leave? Will my data be trapped?" You've heard horror stories of businesses locked into software they can't escape because their data has no way out. You don't want to trade one problem for another.

Centerly was built with both of these fears in mind. Getting your data in is easy. Getting it out is just as easy. Your data always belongs to you — not to us.

Moving your existing student roster into Centerly takes about five minutes, not five days. Here's exactly how it works:

First, download the import template from the Data Hub. This is a ready-made Excel file with columns for student name, phone number, parent name, parent phone, gender, school, educational level, and more. It's pre-formatted so the system knows exactly what to expect.

Next, paste your existing data into the template. If your current spreadsheet has different column names, just copy and paste the data into the matching columns. You don't need to reformat everything perfectly — just get the data into the right columns.

Then upload the file. Centerly reads every row, validates the data, and shows you a clear summary of what happened: how many records were successfully created, how many matched existing students and were updated, how many were skipped because they were duplicates, and if any rows had errors — with specific details about what went wrong and which row to fix.

Imagine this: you have 200 students in a spreadsheet. You download the template, paste your data, upload. In five minutes, all 200 students are in the system with their names, phones, and parent information. No manual entry. No typos from re-typing names. No wasted afternoons.

Centerly supports importing several types of data, covering the most common needs when switching to a new system:

- Students — Names, contact information, parent details, school, educational level, and more. This is the most common import and usually the first thing you'll do when setting up your center.
- Attendance Records — If you have historical attendance data you want to preserve, you can import it so your records are complete from day one.
- Payments — Import existing payment records to maintain a full financial history without gaps.

Each import type has its own template with clearly labeled columns and helpful hints. The system validates every field — checking for required information, correct formats, and duplicate records. If something doesn't match, you get a clear error message telling you exactly which row and which field needs attention. No cryptic errors, no guessing.

For most centers, the student import is all you need to get started. Import your roster on day one, and then start recording attendance and payments going forward with the system. But if you want a complete historical record — maybe for a center that's been running for years — the option is there.

If getting data in is the first concern, getting data out is the second. And Centerly makes exporting just as simple as importing.

You can export any data type to Excel at any time: students, parents, instructors, courses, groups, branches, exams, exam grades, invoices, attendance records, and payments. Everything your workspace contains can be downloaded as a clean, organized spreadsheet.

Need to share your student list with a new branch manager? Export it. Want to send your payment records to your accountant at the end of the quarter? Export them. Preparing for a government audit or an accreditation review? Export everything.

There's also the Full Workbook Export — a single Excel file with every data type as a separate sheet. Think of it as a complete snapshot of your entire center's data, organized and ready to archive, share, or analyze however you like. One click, one file, everything inside.

This isn't just a convenience feature — it's a promise. Your data is never trapped in Centerly. You can download it all, at any time, in a standard format that any spreadsheet program can open.

We believe strongly that your data is yours — not ours. That's why import and export aren't buried in some advanced settings menu or locked behind the most expensive plan. They're core features, easy to find and easy to use.

This philosophy serves a practical purpose too. Centers that know they can leave at any time are centers that stay because the product is genuinely valuable — not because they're locked in. We'd rather earn your continued use than trap you into it.

Whether you're just getting started and importing your first batch of students, or you're a year in and want to download a full backup of everything, the Data Hub is your bridge between Centerly and the rest of your workflow. It's flexible, reliable, and always available whenever you need it.