Luna HR Docs

Importing Data

If you're switching from another HR system, Luna HR makes it easy to bring your existing data across. The data import tool supports CSV files for employees, leave records, expenses, assets, and training.

How it works

  1. Go to Admin > Data Import
  2. Select the data type you want to import (employees, leave, expenses, assets, or training)
  3. Upload your CSV file
  4. Map columns — Luna HR will auto-match common column names. You can manually adjust any mappings that weren't matched automatically
  5. Preview and validate — review the data row by row. Errors (like missing required fields or unrecognised employees) are highlighted in red, warnings in amber
  6. Import — once you're happy, click Import to create the records

Supported data types

Employees

Import your employee directory with names, email addresses, job titles, departments, and more. Data Import is the one spreadsheet route for people — existing staff and new starters alike; the onboarding wizard is offered at the end.

Required columns (three): First name, last name and email. The upload screen lists them before you choose a file.

Filled in for you when missing: employee number (the next free EMP-number is generated), start date (today, marked as not yet known so nobody is told it is their first day), and permission role (your standard Employee role).

Optional, with a default: status (active; or inactive, onboarding, leaver, suspended), employment type (full-time; or part-time, contractor, intern), contract type (permanent; or fixed-term, casual) and FTE (1.0 = full time). Leave the column out, or a cell blank, and the default is used — the preview shows it.

Other optional columns: Job title, department, line manager, working pattern, phone, end date, personal email, date of birth, address, emergency contact, and the other personal fields listed in the admin guide.

A few things to know before you upload:

  • Permission role is not the job title. It must be the name of a role that exists under Admin > Roles and decides what the person can do in Luna — for most people that is Employee. Put what they do for a living in the Job title column. The sample CSV on the upload screen shows both
  • Roles with permissions need your confirmation. If the file gives anyone Administrator, HR Manager, Accounts or another role that carries permissions, the preview lists those roles with the people who get each, and the import waits until you confirm
  • Someone leaving now can't be imported as offboarding — import them as active, then start offboarding in Luna. A leaver (history) needs an end date
  • Employee numbers you give must be new. The preview checks them against people already in Luna too — your own record is usually EMP-001. Leave the cell blank to have one generated
  • Two departments with the same name? Write the one you mean as London > Sales; a name that matches more than one is flagged rather than guessed
  • Status and the type columns are matched without regard to capitals — Active and Permanent are read as active and permanent
  • A line manager can be another row of the same file. Give their email address (or full name) and the link is made once everyone has been imported, whichever order the rows are in. A manager who is neither in Luna nor in the file is flagged as a warning and left blank

Leave records

Import historical leave bookings so balances are accurate from day one.

Required fields: Employee name, leave type, start date, end date, status

Optional fields: Days taken, notes

Expense reports

Import expense data from your previous system. Each CSV row represents an expense line item. Luna HR will group items into reports automatically.

Required fields: Employee name, expense date, category, amount, status

Optional fields: Report title (used to group items into reports), description, currency, tax rate, payment reference, mileage details

If your CSV includes a Report Title column, items with the same employee and title are grouped into the same expense report. Without it, items are grouped by employee and month.

Assets

Import your IT equipment and company asset register.

Required fields: Name, asset tag, category, status, condition

Optional fields: Serial number, manufacturer, model, assigned employee, purchase date, purchase cost, warranty expiry

Training

Import training records and certifications.

Required fields: Employee name, course name, status

Optional fields: Completion date, expiry date, certificate number

Tips for a smooth import

  • Match employee names exactly — Luna HR resolves employees by email address first, then by full name (first + last). Make sure names match what's in Luna HR
  • Use ISO dates — dates in YYYY-MM-DD format work best. DD/MM/YYYY is also supported
  • Check categories first — expense categories and asset categories need to exist in Luna HR before you import. Create them in the admin area first
  • Start with a small batch — test with 10-20 rows before importing your full dataset
  • Currency symbols are fine — amounts like £87.50 or $1,234.50 are automatically cleaned during import

After importing

Review your imported data in the relevant module to make sure everything looks correct. If something wasn't imported correctly, you can edit individual records or run another import.

Sending login invites

The import does not email anyone. An employee imported as active is stored with "invited" status — that means they have no login yet, not that an invitation has gone out. The import's last step asks what these people should receive:

  1. Nothing for now — invite them later: go to Company Structure > Employees, select the employees you want to invite and click Send invites
  2. A login invite — a sign-up link to their work email
  3. The onboarding wizard — they fill in personal details, an emergency contact and documents first, then sign up. For new starters this is the one to choose: each person is sent the wizard invite, to complete before their first day

Choosing to invite opens the same invite dialog as the Employees page, where you pick the login invite or the onboarding wizard (and its template). Only people who can be invited are offered — not anyone imported as a leaver, inactive or suspended.

Daily limit. Luna sends at most 500 invitation emails a day per company, counting every login invite, onboarding invite and resend. A request for more than what is left today is refused as a whole, so after an import of more than 500 people the first 500 are offered; invite the rest from Employees the next day.

The result screen lists every row that was skipped and why. If the import stops part-way (a whole batch failed), it says so and how many rows were never attempted; upload the same file again to finish — rows already imported are left out.

On the Employees page, anyone without a login shows No login yet under their status, or Login invite sent with the date once one has gone, so you can see who is still waiting.

When an employee follows the link and creates their account, Luna HR links their login to their imported employee record. Their status changes from "invited" to "active".

You can also invite one person with Send invite… in their row's actions menu on the Employees page.