Instead of inviting your team members one by one, you can upload a CSV (comma separated value) file instead. You can either 1) download our template from the "People" page, or 2) create a template from scratch. This CSV can contain a part or your entire company's organization. 

For every row in the file, we will either:

  1. Create a new user account using that row's details
  2. Update an existing user's account

We will do this by matching on each user's email. Because of this, please make sure all emails are correct before uploading your CSV file.

If you're an admin the CSV upload feature can be found on your Admin panel.

In the CSV file you upload, each row MUST have these columns:

  1. Email
  2. Name
  3. Title
  4. Manager's Email (For CEO’s or company heads, you may leave the field blank)

In the CSV file you upload, each row MAY have these additional columns:

  1. Start date (YYYY-MM-DD)
  2. Birthdate (YYYY-MM-DD)
  3. Gender (Male, Female, Non-binary)
  4. Department
  5. Phone number
  6. Status

The "Manager Email" and "Status" columns are a bit special. "Manager Email" will be used to configure your org chart and reporting structure. Again, please make sure these emails are correct as managers have special permissions around managing their team. "Status" on the other hand can be used to deactivate Lattice accounts after an employee has been terminated. The column can be set to either "active" or "terminated". 

This will cause:

  1. If the row is "active" and the employee doesn't yet have an account, we will create one for them
  2. If the row is "terminated" and the employee doesn't have an account we will skip that row
  3. If the row is "active" and the employee has an account we will update their details
  4. If the row is "terminated" and the employee has an account we will deactivate their account and they will no longer be able to log in 

Once the CSV is uploaded, the users will remain in a "Created" state. They can be invited all at once or one at a time. Learn more here!

Did this answer your question?