Skip to main content

Importing Your Roster with a CSV

Bring your whole team into Lebra in one upload — names, titles, departments, and reporting lines included — and check when your data last synced.

Written by Maxwell Bass

When you're setting up Lebra (or keeping it in sync with your HR system), you don't want to add people one at a time. The CSV Roster Import lets you upload your entire employee list from a spreadsheet in a single step. Lebra reads your file, helps you match up the columns, checks every row before anything is imported, and then creates or updates every person for you. This guide walks you through the whole process from start to finish — no technical know-how required.

Note: The CSV import lives in Settings and needs two things: an administrator account, and the import feature turned on for your organization by Lebra. If you don't see Import & Integrations in your Settings menu, one of those is missing — your Lebra contact can help.


What is a CSV import, and what is it for?

A CSV is just a simple spreadsheet file — the kind you can make in Excel, Google Sheets, or Numbers. Think of it as a plain table: one row per person, one column per piece of information (name, email, title, and so on).

The CSV Roster Import takes that spreadsheet and brings everyone into Lebra at once. It's the fastest way to:

  • Add your whole organization when you're first getting started.

  • Update lots of people at the same time — new titles, new departments, address changes.

  • Set up your reporting structure so Lebra knows who reports to whom.

  • Keep Lebra in sync with your HR or payroll system on a regular basis.

Here's the helpful part: Lebra matches people by their email address. So you can run the import as often as you like:

  • If an email is new, Lebra creates that person.

  • If an email already exists, Lebra updates that person's details instead of creating a duplicate.

That means you never have to worry about importing the same list twice — re-uploading simply refreshes everyone's information.

When should you use it?

Reach for the CSV import any time you have more than a few people to add or update. It's built for bulk work — onboarding a whole staff, refreshing your roster at the start of a school year, or syncing changes after a hiring round.


Step-by-step: importing your roster

Step 1 — Open Import & Integrations

From the left-hand menu, go to Settings, then choose Import & Integrations. You'll land on a page titled Import & integrations.

Under the CSV Import heading you'll see a short description and a row labeled CSV file with an Import CSV button on the right. As the page says: your file is checked first, and nothing is imported until it passes.

Note: If Career Ladder is enabled for your district, a separate Career Ladder Import page also appears in the Settings menu.

Step 2 — Click "Import CSV"

Click Import CSV. A guided import window opens and walks you through the rest in a few simple screens: Upload, Select Header, Map Columns, then a Check file step before the import itself. You can close it at any time and start over — nothing is saved until the very end.

Step 3 — Download the template (recommended)

On the first screen of the import window, click Download Template. This gives you a ready-made CSV with all of Lebra's column headings already in place, so you never have to guess what goes where.

Open that file in your spreadsheet app and fill in one row per person. Here's what each column means:

Column

What goes here

Required?

First Name

The person's legal first name

✅ Required

Last Name

The person's legal last name

✅ Required

Email

A valid work email (this is how Lebra matches people)

✅ Required

Employee ID

Your internal ID for the person

Recommended

Middle Name

Legal middle name

Optional

Preferred First Name

The name they go by, if different

Optional

Title

The person's job title

Recommended

Position

Their position or role

Optional

Date of Birth

Format: MM/DD/YYYY

✅ Required (Lebra Lead)

Start Date

Format: MM/DD/YYYY

✅ Required (Lebra Lead)

Supervisor Employee ID

The Employee ID of their manager. This sets their reporting line, not their evaluator.

Recommended

Supervisor Full Name

Their manager's full name (used if no ID)

Recommended

Home Department

Their department or team

Recommended

Address Street1

Street address

Optional

PO Box Address

PO box, if any

Optional

Address City / State / Zip

The rest of their address

Optional

Years of Service

A number

Optional

A few tips to make your import go smoothly:

  • Only three columns are truly required: First Name, Last Name, and Email. Everything else is optional — fill in as much or as little as you like.

  • Email is the key. Make sure each person has a valid, correctly spelled email, since that's how Lebra decides whether to update someone or add them fresh. Every row needs one.

  • Use dates in MM/DD/YYYY format (for example, 09/01/2026) for Date of Birth and Start Date. YYYY-MM-DD (for example, 2026-09-01) also works.

  • Names typed in ALL CAPS or all lowercase are re-capitalized on import. Names with normal capitalization are left exactly as typed.

  • Want someone in more than one department? In the Home Department column, separate each one with a double semicolon — for example, Math;;High School;;Grade 11. Lebra will create those groups and add the person to each.

  • Setting up reporting lines? Fill in Employee ID for everyone, then use Supervisor Employee ID (or Supervisor Full Name) to point each person to their manager. Lebra connects the dots for you.

  • Evaluators aren't set by the CSV. The supervisor columns only set reporting lines (who reports to whom). Assign evaluators in Settings > Pathways > Assignments. Importing a CSV never changes anyone's evaluator.

  • School ID and Staff ID aren't CSV columns. Add them on each person's record instead (see School ID and Staff ID below).

Save the file in CSV format when you're done.

Step 4 — Upload your file

Back in the import window, drag your finished file into the upload area or browse to select it from your computer. On the next screen, confirm which row holds your column headings (Lebra picks the first row by default).

Step 5 — Match your columns

Lebra shows you the columns from your file next to its own fields and lets you confirm that everything lines up — your "Email" to Lebra's Email, your "Title" to Title, your "Position" to Position, and so on. If you started from the template, these will usually match automatically. Adjust anything that doesn't look right, then continue. If a required column isn't matched, you'll see "Please include all required columns" until it is.

Good to know: If you leave a column out entirely, Lebra keeps whatever information it already has for those people. If you include a column but leave a cell blank, Lebra keeps the existing value for that cell too. So only include the columns you actually want to set or change.

Step 6 — Lebra checks the file

Select Submit and Lebra checks every row before importing anything. The Check file step tells you exactly where it stands:

  • If problems were found, the heading reads "N rows need a fix before we can import this file" (or "This file can't be imported yet"), with the reassurance "N people checked. Nothing has been imported yet." Each issue is marked Must fix or FYI, with the row number, the person, the value in your file, and what to change — for example, "Email is missing the @ sign."

  • Select Download error report to get the list as a file, fix the rows in your spreadsheet, then select Upload corrected file. Import unlocks when the file has nothing left to fix.

  • If the file is clean, the heading reads "Your file is ready to import". You can still Download report (when there are FYI notes) or Upload a different file.

Step 7 — Finish the import

When the check passes, select Import N people. Lebra gets to work:

  • Creates anyone whose email is new.

  • Updates anyone whose email already exists.

  • Builds your departments and groups from the Home Department column.

  • Connects managers to their team members using the Employee ID and supervisor columns.

You'll see Import complete with a count of people added and updated. Your roster is live in Lebra and ready to go.


School ID and Staff ID

Alongside your internal Employee ID, a person's record can hold two additional identifiers used for state reporting:

  • School ID — the identifier for the school the person belongs to

  • Staff ID — the person's state or district staff identifier

These flow into your state reporting exports, so filling them in ahead of your submission window saves a lot of manual cleanup later.

School ID and Staff ID aren't part of the CSV import, so you set them on each person's record.

To add or update them on a person's record:

  1. Open the person's page.

  2. Edit their profile.

  3. Fill in School ID and Staff ID.

  4. Save.


Checking When Your Data Last Synced

If your district sends Lebra an employee data file on a schedule, you can confirm it's actually arriving — rather than finding out mid-year that your roster went stale.

Note: If your roster comes from a scheduled feed, the district's file is the source of truth for the details it contains. Edits you make to those details on a person's profile in Lebra can be overwritten by the next sync, so make lasting changes in your HR system. See Sync Status and Scheduled Roster Feeds.

Steps

  1. Go to Settings > Organization.

  2. Find the Sync Status card, which shows the status of the most recent employee data sync.

  3. Check Last Synced for the date and time of the most recent sync.

The status badge tells you how that sync went:

Success

The sync completed normally

Partial

Some records synced and some didn't

Failed

The sync did not complete

No Files

No file was available to sync

The stale data warning

If your employee data file hasn't been refreshed in a while, administrators see a warning banner telling you how old the file is and asking you to upload an updated one to keep your roster in sync.

The banner appears once your file is more than 30 days old, and only for administrators — so your wider team isn't alarmed by it.

What to do when you see it: run a fresh CSV import using the steps above, or check with whoever manages your automated file delivery. The banner clears once newer data arrives.

Tip: A stale roster quietly causes downstream problems — new hires missing from pathways, departed staff still receiving reminder emails. It's worth checking Sync Status at the start of each school year and after any hiring round.


If something goes wrong

Most problems are caught at the Check file step, before anything is imported, and each one tells you what to change. The ones you'll see most often:

  • An email address Lebra can't use — a missing @ sign, a typo, or an empty cell. Correct it in your spreadsheet and upload the corrected file.

  • A date in the wrong format — switch Date of Birth or Start Date cells to MM/DD/YYYY (or YYYY-MM-DD) and try again.

  • Someone listed as their own supervisor — remove their own ID from the Supervisor column.

If an import stops partway, you'll see "The import didn't finish" with an Upload again button. It's safe to upload the same file again — fixing and re-uploading never creates duplicates, because Lebra matches on email.

A couple of things Lebra quietly handles for you:

  • Duplicate emails in your file? Lebra keeps the first one and skips the rest, so you won't get two copies of the same person.

  • Accidental self-managers? If someone's supervisor ID matches their own, Lebra clears it automatically.


Quick reference

You want to…

Do this

Open the importer

Settings → Import & Integrations → Import CSV

Get the starter file

Click Download Template on the first screen

Add or update people in bulk

Fill in the template, then upload it

Avoid duplicates

Just re-import — Lebra matches on email

Set up reporting lines

Use Employee ID + Supervisor Employee ID

Assign evaluators

Settings → Pathways → Assignments (not the CSV)

Put someone in multiple departments

Separate them with ;; in Home Department

Fix a flagged row

Correct your spreadsheet and select Upload corrected file

Check your roster is current

Settings → Organization → Sync Status

Add state reporting identifiers

Edit the person and fill in School ID and Staff ID

Required columns: First Name, Last Name, Email Matched by: Email (existing people are updated, new people are created) Date format: MM/DD/YYYY

Did this answer your question?