Adding many people at once from a spreadsheet, instead of one at a time.
This runs through exactly the same creation process as adding somebody by hand — same validation, same invitation, same rules — so anything that would have been rejected individually is rejected here too, row by row rather than all at once.
Before you start
- Your file should be a CSV. Export one from a spreadsheet if you have to.
- Departments, job titles and roles have to exist already. A row naming a department you haven't created fails on that row.
- You need the same permission as adding one person by hand.
Prepare your file
One person per row. Column names don't have to match anything — you'll map them on screen. At minimum include a name and an email address.
Decide whether your file has a header row, because you'll be asked. Getting this wrong is the most common problem with a bulk import: telling it there are no headers when there are means your column titles get imported as a person, quietly, and you end up with somebody called "First Name".
Steps
- Go to Settings.
- Open Team Members or Members, depending on who you're adding.
- Choose the bulk option — Add in bulk or Import.
- Upload your CSV.
- Say whether the first row is a header. Read it back before continuing.
- Map your columns onto KamoCRM's fields. Each column on the left is one of yours; pick what it means on the right. Anything you leave unmapped is ignored.
- Set what everyone in the file has in common — usually the security role — so you don't need a column for it.
- Review the preview. It shows what will be created, per row.
- Confirm.
What you'll see
Each row is created independently. A row that fails — a duplicate address, a department that doesn't exist — is reported and skipped, and the rest still go through. You get a summary of what was created and what wasn't, with a reason per failure.
Everybody created is sent an invitation, exactly as if you had added them by hand.
If it doesn't work
One person is named "First Name". The header row was imported. Delete that person and re-import with the header setting correct.
Everything failed on department or job title. Those have to exist first, and they're matched on exact text. Create them, or correct the spelling in your file.
Some rows failed on a duplicate address. Those people already exist. Check whether they're deactivated rather than absent — reactivating is a different action from creating.
Related articles
Other guides that answer questions close to this one.
How to Add a Member or Team Member
Adding one person to your organization. If you're adding several, How to Add People in Bulk from a File is faster and uses the same underlying process. Before you start Decide two things first: Which kind of person this…
How to Assign a Role to a Member
Note: this doesn't happen from Security Roles, Departments, or Job Titles — role assignment to an actual person is done on that person's own member settings page. Give a specific team member one or more roles, and…
How to Create and Manage Departments
Build out your organization's department structure, and optionally grant departments their own roles or rights on top of what their members' roles already give them. Before you start The Configure System right. Steps 1.…