The user import template is a quick and convenient way to create or update multiple learners via spreadsheet at one time.
We recommend including as much data as possible to ensure the best experience in the LMS. See Column Usage recommendations below to identify required, recommended and optional fields. Add data when possible to any column identified as a Rules Trigger, as those items can be used in team and assignment automation rules.
Important: To ensure proper import functionality, please do not adjust the header columns within the spreadsheet. If columns are deleted from the import spreadsheet, the platform will not recognize the data and the information will not be imported. Double-check formatting and avoid typos or inconsistent values. Avoid special characters or unnecessary spaces in usernames.
Import File Specifications:
| File Type | CSV or XLSX |
| Columns | Must include all columns identified below (even if no data is provided) |
Import File Details by Column:
| Column Header | Column Usage | Data Type | Character Limit | Rules Trigger* | Notes |
| Username | Required | nvarchar | 255 | Unique identifier for each learner in the LMS. Best practice: Use the learner’s work email address to avoid duplicate usernames across the BizLibrary system. If a work email is not available: Use a standardized format (e.g., firstinitiallastname123, employee ID, or similar unique string). | |
| Password | Optional | nvarchar | 255 | If left blank – a unique password will be generated for the learner. The learner will need to use the forgot password link to set password for initial login. Password will only be set for initial user creation (password field will not update passwords for existing learners) | |
| Firstname | Required | nvarchar | 255 | The learner’s first name. | |
| Lastname | Required | nvarchar | 255 | The learner’s last name. | |
| Active | Required | nvarchar | 5 | Yes | Expected values: TRUE or FALSE TRUE – Create new Learner, Update existing Learner FALSE – Deactivate Learner account |
| LoginDestination | Do not add data | nvarchar | 100 | Legacy field – Do not add data in this column | |
| Address1 | Optional | nvarchar | 255 | The Learner’s address. | |
| Address2 | Optional | nvarchar | 255 | The Learner’s address. | |
| City | Recommended | nvarchar | 255 | Yes | The Learner’s city. |
| State | Recommended | nvarchar | 255 | Yes | The Learner’s state. |
| PostalCode | Optional | nvarchar | 255 | The Learner’s postal/ zip code. | |
| CountryKey | Optional | int | 4 | Yes | The Learner’s country. See chart below |
| Recommended | nvarchar | 255 | The Learner’s email. | ||
| PhoneNum | Optional | nvarchar | 255 | The Learner’s phone number. | |
| Title | Recommended | nvarchar | 255 | Yes | The Learner’s job title. |
| Company | Recommended | nvarchar | 255 | Yes | The Learner’s company. |
| CostCenter | Optional | nvarchar | 255 | Yes | The Learner’s cost center. |
| Department | Recommended | nvarchar | 100 | Yes | The Learner’s department. |
| Division | Optional | nvarchar | 255 | Yes | The Learner’s division. |
| JobCode | Optional | nvarchar | 100 | Yes | The Learner’s job code. |
| JobRole | BizSkills | nvarchar | 100 | Yes | This field is used for client using BizSkills to associate BizSkills Job Roles to a learner |
| HireDate | Recommended | datetime | 16 | Yes | The Learner’s hire date. |
| EmployeeId | Recommended | nvarchar | 50 | The Learner’s Employee ID. | |
| BillingId | Leave blank | nvarchar | 255 | This can be left blank. The import will inherit the client Billing ID from the administrator performing the import | |
| AuthLDAP | Do not add data | int | 4 | Legacy field – Do not add data in this column | |
| Supervisor | Recommended | nvarchar | 255 | Yes | Username of the Learner’s supervisor |
* This column can be used for automation rules in BizLMS. Administrators need to set up and define those rules to utilize this functionality. This feature is not available in BizLXP, talk to your Client Success Manager to learn more.
Country Keys:
| CountryKey | Country |
| 91 | Afghanistan |
| 210 | Aland Islands |
| 92 | Albania |
| 93 | Algeria |
| 211 | American Samoa |
| 94 | Andorra |
| 95 | Angola |
| 212 | Anguilla |
| 213 | Antarctica |
| 96 | Antigua |
| 2 | Argentina |
| 97 | Armenia |
| 214 | Aruba |
| 4 | Australia |
| 5 | Austria |
| 98 | Azerbaijan |
| 99 | Bahamas |
| 100 | Bahrain |
| 101 | Bangladesh |
| 102 | Barbados |
| 103 | Belarus |
| 6 | Belgium |
| 104 | Belize |
| 105 | Benin |
| 215 | Bermuda |
| 106 | Bhutan |
| 107 | Bolivia |
| 108 | Bosnia-Herzegovina |
| 109 | Botswana |
| 216 | Bouvet Island |
| 8 | Brazil |
| 217 | British Indian Ocean Territory |
| 9 | Brunei |
| 110 | Bulgaria |
| 111 | Burkina Faso |
| 112 | Burundi |
| 113 | Cambodia |
| 114 | Cameroon |
| 10 | Canada |
| 115 | Cape Verde |
| 218 | Cayman Islands |
| 116 | Central African Republic |
| 117 | Chad |
| 12 | Chile |
| 13 | China |
| 219 | Christmas Island |
| 220 | Cocos (Keeling) Islands |
| 14 | Colombia |
| 118 | Comoros |
| 119 | Congo (DRC) |
| 120 | Congo (RC) |
| 221 | Cook Islands |
| 16 | Costa Rica |
| 121 | Cote d `Ivoire |
| 17 | Croatia |
| 122 | Cuba |
| 18 | Cyprus |
| 19 | Czech Republic |
| 20 | Denmark |
| 123 | Djibouti |
| 124 | Dominica |
| 125 | Dominican Republic |
| 126 | East Timor |
| 22 | Ecuador |
| 23 | Egypt |
| 127 | El Salvador |
| 128 | Equatorial Guinea |
| 129 | Eritrea |
| 24 | Estonia |
| 130 | Ethiopia |
| 222 | Falkland Islands (Malvinas) |
| 223 | Faroe Islands |
| 26 | Fiji |
| 27 | Finland |
| 28 | France |
| 224 | French Guiana |
| 225 | French Polynesia |
| 226 | French Southern Territories |
| 131 | Gabon |
| 132 | Gambia |
| 133 | Georgia |
| 31 | Germany |
| 134 | Ghana |
| 227 | Gibraltar |
| 32 | Greece |
| 228 | Greenland |
| 33 | Grenada |
| 229 | Guadeloupe |
| 230 | Guam |
| 135 | Guatemala |
| 231 | Guernsey |
| 136 | Guinea |
| 137 | Guinea-Bissau |
| 138 | Guyana |
| 139 | Haiti |
| 232 | Heard Island and McDonald Islands |
| 140 | Holy See |
| 141 | Honduras |
| 233 | Hong Kong |
| 852 | Hong Kong |
| 35 | Hungary |
| 36 | Iceland |
| 37 | India |
| 38 | Indonesia |
| 142 | Iran |
| 143 | Iraq |
| 39 | Ireland |
| 234 | Isle of Man |
| 40 | Israel |
| 41 | Italy |
| 144 | Jamaica |
| 42 | Japan |
| 235 | Jersey |
| 145 | Jordan |
| 146 | Kazakhstan |
| 147 | Kenya |
| 148 | Kiribati |
| 43 | Korea, North |
| 73 | Korea, South |
| 44 | Kuwait |
| 149 | Kyrgyzstan |
| 150 | Laos |
| 46 | Latvia |
| 151 | Lebanon |
| 152 | Lesotho |
| 153 | Liberia |
| 154 | Libya |
| 155 | Liechtenstein |
| 47 | Lithuania |
| 48 | Luxembourg |
| 236 | Macao |
| 156 | Macedonia (FYROM) |
| 157 | Madagascar |
| 158 | Malawi |
| 50 | Malaysia |
| 159 | Maldives |
| 160 | Mali |
| 51 | Malta |
| 161 | Marshall Islands |
| 237 | Martinique |
| 162 | Mauritania |
| 53 | Mauritius |
| 238 | Mayotte |
| 54 | Mexico |
| 163 | Micronesia |
| 164 | Moldova |
| 165 | Monaco |
| 166 | Mongolia |
| 239 | Montenegro |
| 240 | Montserrat |
| 167 | Morocco |
| 168 | Mozambique |
| 169 | Myanmar |
| 170 | Namibia |
| 171 | Nauru |
| 172 | Nepal |
| 56 | Netherlands |
| 241 | Netherlands Antilles |
| 242 | New Caledonia |
| 58 | New Zealand |
| 173 | Nicaragua |
| 174 | Niger |
| 175 | Nigeria |
| 243 | Niue |
| 244 | Norfolk Island |
| 245 | Northern Mariana Islands |
| 59 | Norway |
| 176 | Oman |
| 177 | Pakistan |
| 178 | Palau |
| 246 | Palestinian Territory,Occupied |
| 60 | Panama |
| 179 | Papua New Guinea |
| 61 | Paraguay |
| 62 | Peru |
| 63 | Philippines |
| 247 | Pitcairn |
| 64 | Poland |
| 65 | Portugal |
| 248 | Puerto Rico |
| 66 | Qatar |
| 249 | Reunion |
| 180 | Romania |
| 67 | Russia |
| 181 | Rwanda |
| 250 | Saint Helena |
| 182 | Saint Kitts & Nevis |
| 76 | Saint Lucia |
| 251 | Saint Pierre and Miquelon |
| 183 | Saint Vincent & Grenadines |
| 184 | Samoa |
| 185 | San Marino |
| 186 | Sao Tome & Principe |
| 68 | Saudi Arabia |
| 187 | Senegal |
| 252 | Serbia |
| 188 | Serbia & Montenegro |
| 189 | Seychelles |
| 190 | Sierra Leone |
| 69 | Singapore |
| 70 | Slovakia |
| 71 | Slovenia |
| 191 | Solomon Islands |
| 192 | Somalia |
| 72 | South Africa |
| 253 | South Georgia and the South Sandwich Islands |
| 74 | Spain |
| 75 | Sri Lanka |
| 193 | Sudan |
| 194 | Suriname |
| 254 | Svalbard and Jan Mayen |
| 195 | Swaziland |
| 77 | Sweden |
| 78 | Switzerland |
| 79 | Syria |
| 80 | Taiwan |
| 196 | Tajikistan |
| 197 | Tanzania |
| 81 | Thailand |
| 255 | Timor-Leste |
| 198 | Togo |
| 256 | Tokelau |
| 199 | Tonga |
| 82 | Trinidad & Tobago |
| 200 | Tunisia |
| 83 | Turkey |
| 201 | Turkmenistan |
| 257 | Turks and Caicos Islands |
| 202 | Tuvalu |
| 203 | Uganda |
| 204 | Ukraine |
| 84 | United Arab Emirates |
| 85 | United Kingdom |
| 87 | United States |
| 258 | United States Minor Outlying Islands |
| 86 | Uruguay |
| 205 | Uzbekistan |
| 206 | Vanuatu |
| 88 | Vatican City |
| 89 | Venezuela |
| 90 | Vietnam |
| 259 | Virgin Islands, British |
| 260 | Virgin Islands, U.S. |
| 261 | Wallis and Futuna |
| 262 | Western Sahara |
| 207 | Yemen |
| 208 | Zambia |
| 209 | Zimbabwe |