Importing users from a spreadsheet

Modified on Fri, Nov 15 at 11:20 AM

If you are planning on adding more than a handful of users at one time, uploading via a spreadsheet may be a good option to save time. It is best to use our sample spreadsheet.

There are only 3 required fields:

First name
Last name
Email address

You can include the following optional fields, as well:

Manager email (highly recommended)
Job title
Job description
Mobile phone
Location
Division
Department
Job Type
About
Account status (Active, Deactivated, Locked)
Work phone
Twitter username
Skype name
LinkedIn profile URL
Home phone
Home address
City
Country code (Standard 2-character codes; i.e. US, UK, DE -- See this Wikipedia article for a full list)
ZIP/postal code
Date of birth (must be in format yyyy-mm-dd)
Employee ID
Hire date (must be in format yyyy-mm-dd)
Exit date (must be in format yyyy-mm-dd)
Resume
Compensation
Preferred language code (Use a two letter code: en, es, fr)

Once you have compiled your spreadsheet, you will copy/paste it into our system on the Import Users from Spreadsheet page. (Please feel free to delete the standard column headers that are listed on this page if you are also copying the headers from your spreadsheet).

Page to import users from a Spreadsheet

Don't be too concerned with how the data looks when you copy/paste. The system essentially maps the information based on tabs that are pulled from the spreadsheet.

On the next page, the system will ask you to confirm that the headers from your spreadsheet match the fields that exist in Primalogik. If you are using our spreadsheet, you should have no problem here. If you used one you made yourself and things are not formatted properly, you can do the mapping at this stage.

Notice that 'First name' under Header matches the Primalogik Field (as do the rest of the headers).

Once you confirm that the headers all match the Primalogik fields, press Preview to see the user accounts that will be coming in.

Selecting users to import or update

In most cases, you'll want to import all of the users from your spreadsheet. Use the top checkbox (displayed in the screenshot above) to choose everyone. Otherwise, feel free to use the individual check boxes next to each person's name to select one-by-one.

Be sure to press Import Selected Users to finalize the process.

*Note: The system will not send any account confirmation emails to these users at this point. If you would like to do so, see our article Sending account confirmation emails en masse.