CSV import

Import and update Litmos users from a spreadsheet

New starters and org changes arrive as a spreadsheet. Drop it into Micro: new emails become new Litmos users, existing people get only what changed, and anything unclear is flagged before you apply.

Start free trial

14-day free trial, no credit card needed. Works with the Litmos account you already have.

new-starters.csv

Email,Surname,Department,Courses

jane.doe@…,Doe,Sales – EMEA,Product 101

sam.lee@…,Lee,Finance,

ari.ng@…,Ng,Warehouse – Leeds,Fire Safety

kim.ho@…,Ho,Ops,

  • Create Jane Doe → Sales – EMEA with Product 101
  • Update Sam Lee: add to Finance
  • Create Ari Ng → Warehouse – Leeds with Fire Safety
  • Row 5: no team called “Ops” — skipped

The problem

What it's like in Litmos today

  • Turning HR's new-starter spreadsheet into Litmos users, teams and course assignments is slow, manual work.
  • Columns never match an import template exactly, so files get reformatted before they can be used.
  • Mistakes like a misspelt team name are found after the import, not before.

How Micro solves it

Keep Litmos. Do this part in Micro.

  1. 1

    Use the spreadsheet you have

    Micro recognises common column names, like “Surname”, “Department” or “Courses”, so there's no template to fill in.

  2. 2

    New and existing people in one file

    New emails become new users. People who already exist get only the fields, teams and courses that are different.

  3. 3

    Problems flagged first

    Invalid emails, duplicate rows, and team or course names that don't match are listed in the preview, before anything is sent to Litmos.

  4. 4

    Undo

    Imported the wrong file? Undo deactivates the users the import created and reverses its other changes.

Screens show Northwind, the fictional company in Micro's live demo.

Questions

What columns can the spreadsheet have?
An email column is required. Micro also recognises first name, last name, job title, company, access level, team and courses, under common names like “Surname”, “Department” or “Training”. Several teams or courses can go in one cell, separated by semicolons.
Will new users get a welcome email?
Only if you choose. Imports run with Litmos notifications off unless you tick the option to send them.
What happens to people already in Litmos?
They're matched by email, and only what's different is changed. Nobody is duplicated.
Can I check it before it runs?
Yes. Every import is a draft first. You see who will be created and updated, plus any warnings, and nothing reaches Litmos until you press Apply.

Related terms

Try it on your own Litmos site

Connect your Litmos site with an API key in about two minutes. 14-day free trial, no credit card needed.

Start your free trial

More ways Micro helps Litmos admins

Micro is created by Litmos founder Rich Chetwynd. It's an independent product and isn't affiliated with, endorsed by or sponsored by Litmos.