Skip to main content

How to Bulk Import People via Excel

This article shows you how to import a new user or multiple people through the user import using Excel.

Written by Cille Pedersen

When it comes to importing or updating people in bulk, we recommend using the Bulk User import function. This allows you to both Create New People but also Update Existing People. Please see the step-by-step guide on how to Bulk Import People and also see the Troubleshooting guide.


How to Import People


First, navigate to Admin > Organization > People > click Import.

In the pop-up screen click 'here' to prompt a download and open the template.


Template overview


In the template, there are 12 predefined columns in which AccountID, First name, Last Name, and User Role are mandatory to fill out. These columns are also marked with an asterisk*

IMPORTANT: Please make sure to read the Template guide before you start populating the template. The predefined columns are hardcoded, meaning you must NOT remove them as the Import will not function if you edit these columns. Additionally, it is also important that you do NOT delete Row 1 named User_Import_template as this will also cause the Import to not function.

  • AccountID*: This can either be an email or a unique number that identifies the user (e.g. employeeID) - Must be at least 3 characters (maximum 250).

  • First name*: First name of the User.

  • Last name*: Last name of the User.

  • User role*: Define as either User or Admin or add a custom-role:
    - To apply a custom role, locate the Key found under Admin > Organization > Roles > select the custom role.
    ​


    In the import sheet, enter the Key in the column User role*.
    ​

  • Active (True/False): If set to True, the User will be activated.

  • Send email invite (True/False): If set to True, an activation email will be sent when imported.

  • Temporary password: Predefine a password. Must be min. 8 characters w. min. One uppercase, one lowercase letter, and one number.

    • We recommend leaving this column empty.

  • Email address: Email of the User used for sending email notifications.

  • Job title: The User's Job Title.

  • Manager Account ID: Fill in the Account ID of the User to be noted as the Direct Manager of the User.

  • Timezone: This will set the User's timezone - you must follow the IANA format (AREA}/{LOCATION).

  • Language: This will set the Users platform Language. You can see the Language format here: Supported Languages


Timezones


Find below a list of the available in-platform Timezones along with their associated IANA format. Additionally, the below table provides an overview of whether a given Timezone observes Daylight Saving Time (DST) or not.

In-platform Timezone

IANA Timezone

Observes DST

Summer (UTC)

Winter (UTC)

Greenwich Standard Time

Atlantic/Reykjavik

No

UTC+00:00

UTC+00:00

GMT Standard Time

Europe/London

Yes

UTC+01:00

UTC+00:00

Morocco Standard Time

Africa/Casablanca

Yes

UTC+01:00

UTC+01:00

W. Central Africa Standard Time

Africa/Bangui

No

UTC+01:00

UTC+01:00

Central Europe Standard Time

Europe/Belgrade

Yes

UTC+02:00

UTC+01:00

Central European Standard Time

Europe/Warsaw

Yes

UTC+02:00

UTC+01:00

Romance Standard Time

Europe/Brussels

Yes

UTC+02:00

UTC+01:00

W. Europe Standard Time

Europe/Amsterdam

Yes

UTC+02:00

UTC+01:00

South Africa Standard Time

Africa/Harare

No

UTC+02:00

UTC+02:00

E. Europe Standard Time

Europe/Minsk

No

UTC+03:00

UTC+03:00

Egypt Standard Time

Africa/Cairo

Yes

UTC+03:00

UTC+02:00

FLE Standard Time

Europe/Helsinki

Yes

UTC+03:00

UTC+02:00

GTB Standard Time

Europe/Athens

Yes

UTC+03:00

UTC+02:00

Israel Standard Time

Asia/Jerusalem

Yes

UTC+03:00

UTC+02:00

Jordan Standard Time

Asia/Amman

No

UTC+03:00

UTC+03:00

Middle East Standard Time

Asia/Beirut

Yes

UTC+03:00

UTC+02:00

Namibia Standard Time

Africa/Maputo

No

UTC+02:00

UTC+02:00

Arab Standard Time

Asia/Kuwait

No

UTC+03:00

UTC+03:00

E. Africa Standard Time

Africa/Nairobi

No

UTC+03:00

UTC+03:00

Georgian Standard Time

Asia/Tbilisi

No

UTC+04:00

UTC+04:00

Arabic Standard Time

Asia/Baghdad

No

UTC+03:00

UTC+03:00

Russian Standard Time

Europe/Moscow

No

UTC+03:00

UTC+03:00

Iran Standard Time

Asia/Tehran

No

UTC+03:30

UTC+03:30

Arabian Standard Time

Asia/Muscat

No

UTC+04:00

UTC+04:00

Azerbaijan Standard Time

Asia/Baku

No

UTC+04:00

UTC+04:00

Caucasus Standard Time

Asia/Yerevan

No

UTC+04:00

UTC+04:00

Mauritius Standard Time

Indian/Mauritius

No

UTC+04:00

UTC+04:00

Afghanistan Standard Time

Asia/Kabul

No

UTC+04:30

UTC+04:30

West Asia Standard Time

Asia/Tashkent

No

UTC+05:00

UTC+05:00

Ekaterinburg Standard Time

Asia/Yekaterinburg

No

UTC+05:00

UTC+05:00

Pakistan Standard Time

Asia/Karachi

No

UTC+05:00

UTC+05:00

India Standard Time

Asia/Calcutta

No

UTC+05:30

UTC+05:30

Sri Lanka Standard Time

Asia/Colombo

No

UTC+05:30

UTC+05:30

Nepal Standard Time

Asia/Katmandu

No

UTC+05:45

UTC+05:45

Central Asia Standard Time

Asia/Dhaka

No

UTC+06:00

UTC+06:00

N. Central Asia Standard Time

Asia/Novosibirsk

No

UTC+07:00

UTC+07:00

Myanmar Standard Time

Asia/Rangoon

No

UTC+06:30

UTC+06:30

SE Asia Standard Time

Asia/Bangkok

No

UTC+07:00

UTC+07:00

North Asia Standard Time

Asia/Krasnoyarsk

No

UTC+07:00

UTC+07:00

China Standard Time

Asia/Shanghai

No

UTC+08:00

UTC+08:00

Singapore Standard Time

Asia/Kuala_Lumpur

No

UTC+08:00

UTC+08:00

Taipei Standard Time

Asia/Taipei

No

UTC+08:00

UTC+08:00

North Asia East Standard Time

Asia/Irkutsk

No

UTC+08:00

UTC+08:00

W. Australia Standard Time

Australia/Perth

No

UTC+08:00

UTC+08:00

Korea Standard Time

Asia/Seoul

No

UTC+09:00

UTC+09:00

Tokyo Standard Time

Asia/Tokyo

No

UTC+09:00

UTC+09:00

Yakutsk Standard Time

Asia/Yakutsk

No

UTC+09:00

UTC+09:00

AUS Central Standard Time

Australia/Darwin

No

UTC+09:30

UTC+09:30

Cen. Australia Standard Time

Australia/Adelaide

Yes

UTC+10:30

UTC+09:30

E. Australia Standard Time

Australia/Brisbane

No

UTC+10:00

UTC+10:00

West Pacific Standard Time

Pacific/Port_Moresby

No

UTC+10:00

UTC+10:00

AUS Eastern Standard Time

Australia/Sydney

Yes

UTC+11:00

UTC+10:00

Tasmania Standard Time

Australia/Hobart

Yes

UTC+11:00

UTC+10:00

Vladivostok Standard Time

Asia/Vladivostok

No

UTC+10:00

UTC+10:00

Central Pacific Standard Time

Asia/Magadan

No

UTC+11:00

UTC+11:00

Fiji Standard Time

Pacific/Fiji

No

UTC+12:00

UTC+12:00

New Zealand Standard Time

Pacific/Auckland

Yes

UTC+13:00

UTC+12:00

Tonga Standard Time

Pacific/Tongatapu

No

UTC+13:00

UTC+13:00

Cape Verde Standard Time

Atlantic/Cape_Verde

No

UTC-01:00

UTC-01:00

Azores Standard Time

Atlantic/Azores

Yes

UTC+00:00

UTC-01:00

Mid-Atlantic Standard Time

Atlantic/South_Georgia

No

UTC-02:00

UTC-02:00

SA Eastern Standard Time

America/Bahia

No

UTC-03:00

UTC-03:00

Argentina Standard Time

America/Argentina/Buenos_Aires

No

UTC-03:00

UTC-03:00

E. South America Standard Time

America/Sao_Paulo

No

UTC-03:00

UTC-03:00

Montevideo Standard Time

America/Montevideo

No

UTC-03:00

UTC-03:00

Newfoundland Standard Time

America/St_Johns

Yes

UTC-02:30

UTC-03:30

SA Western Standard Time

Etc/GMT+4

No

UTC-04:00

UTC-04:00

Atlantic Standard Time

America/Halifax

Yes

UTC-03:00

UTC-04:00

Central Brazilian Standard Time

America/Manaus

No

UTC-04:00

UTC-04:00

Pacific SA Standard Time

America/Santiago

Yes

UTC-03:00

UTC-04:00

Venezuela Standard Time

America/Caracas

No

UTC-04:00

UTC-04:00

SA Pacific Standard Time

America/Bogota

No

UTC-05:00

UTC-05:00

US Eastern Standard Time

America/Indiana/Indianapolis

Yes

UTC-04:00

UTC-05:00

Eastern Standard Time

America/New_York

Yes

UTC-04:00

UTC-05:00

Canada Central Standard Time

America/Regina

No

UTC-06:00

UTC-06:00

Central America Standard Time

Etc/GMT+6

No

UTC-06:00

UTC-06:00

Central Standard Time

America/Chicago

Yes

UTC-05:00

UTC-06:00

Central Standard Time (Mexico)

America/Mexico_City

No

UTC-06:00

UTC-06:00

US Mountain Standard Time

Etc/GMT+7

No

UTC-07:00

UTC-07:00

Mountain Standard Time

America/Denver

Yes

UTC-06:00

UTC-07:00

Mountain Standard Time (Mexico)

America/Chihuahua

No

UTC-06:00

UTC-06:00

Pacific Standard Time

America/Los_Angeles

Yes

UTC-07:00

UTC-08:00

Pacific Standard Time (Mexico)

America/Tijuana

Yes

UTC-07:00

UTC-08:00

Alaskan Standard Time

America/Anchorage

Yes

UTC-08:00

UTC-09:00

Hawaiian Standard Time

Pacific/Honolulu

No

UTC-10:00

UTC-10:00

Samoa Standard Time

Pacific/Apia

No

UTC+13:00

UTC+13:00

UTC+12

Pacific/Majuro

No

UTC+12:00

UTC+12:00

Aus Central W. Standard Time

Australia/Eucla

No

UTC+08:45

UTC+08:45

Bougainville Standard Time

Pacific/Bougainville

No

UTC+11:00

UTC+11:00

Lord Howe Standard Time

Australia/Lord_Howe

Yes

UTC+11:00

UTC+10:30


How to add Custom Fields


If you need more information registered to your people, it is possible to add Custom Fields to the sheet and have these fields populated via the Import.

Read more on Custom Fields here.

To add Custom Fields to the sheet, simply add a new column in Excel. You can add as many as you have created on your platform.

IMPORTANT: Please make sure that the name(s) of the Custom Field(s) is written exactly in the Import sheet as you have it written on the Platform.

IMPORTANT: When updating data on existing People, you must always add ALL Custom Fields in your platform including the respective data in the Excel sheet. If you do not add the Custom Field data when updating existing People, these fields will be blanked out when running the import.


​Example: You add a new Custom Field to your platform and wish to bulk update data via Excel. If you leave out existing Custom Fields and their respective data, all existing data in your platform in the left-out Custom Fields will be erased upon import.

Once you have populated the sheet to your liking, you are now ready to perform the import.


How to run the Import


On your platform navigate to Admin > Organization > People > click Import > Now drag or select the Import template file.

A confirmation screen will now appear. Click Confirm to complete the import.


Troubleshooting User Imports


If you experience issues with the Import, find below a few tips on how to troubleshoot and resolve these.

#Scenario 1: File Contains Duplicated Entry

Reason: One of the People you are importing already exists on your platform.

Solution: Either delete the User from the import sheet or click on 'Skip Entries' to proceed with the import.

#Scenario 2: Unexpected field name

Reason: This error shows if you have not entered the name of the Custom Field in the sheet correctly.

Solution: Please make sure to check that the name of the Custom Field is exactly the same as it is registered on your platform.

Also, make sure to check that there are not any empty spaces after the column name in the sheet as this can also cause a field not to be recognized.

Did this answer your question?