Bulk Upload - Company Sites

The below article is relating to the bulk upload - Company Sites which can be found by navigating to Administration -> Company -> Bulk Upload.

The Company Sites bulk upload is under the Company Structure section here:

Once you've selected the Company Sites Bulk Upload you'll be directed to this page:

The page includes the following:

CSV file to upload

This is where you will load your CSV when it is ready to upload. Press browse and select the CSV file.

Download help file and instructions

This option will download our bulk upload help file. This includes instructions on how to use each bulk upload and lets you know which columns are mandatory and which are optional, it's important to look at the relevant help file before performing a bulk upload so you can get it right the first time.

Download CSV Model

The second option downloads an example template for you to use for the bulk upload with all the headers needed for the bulk upload to be successful.

 

Editing your CSV

When you download your sample CSV file it will look like this:

The CSV fields include:

Site Reference - Reference number/code for this office location. This field can contain numbers and/or letters. This field is Mandatory.

Office Name - The name of this office location, this field can be made up of letters and/or numbers. This field is Mandatory.

Company Name - The name of the company who reside at this site, can be made up of letters and/or numbers. This field is Optional.

Address - Address line 1. This field can be made up of letters and/numbers. This field is Optional.

Address 2 - Address line 2. This field can be made up of letters and/numbers. This field is Optional.

County - County/state, this field can be made up of letters and/or numbers. This field is Optional.

Post Code - Post/Zip Code, This field can be made up of letters and/or numbers. This field is Optional.

Country - Please see below list of valid entries:

Afghanistan
Aland Islands
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
Antigua and Barbuda
Argentina
Armenia
Aruba
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia Plurinational State of Bonaire Sint Eustatius and Saba
Bosnia and Herzegovina
Botswana
Bouvet Island
Brazil
British Indian Ocean Territory
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Cayman Islands
Central African Republic
Chad
Chile
China
Christmas Island
Cocos (Keeling) Islands
Colombia
Comoros
Congo
Congo The Democratic Republic of the Cook Islands
Costa Rica
Cote d'Ivoire
Croatia
Cuba
Curacao
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands (Malvinas)
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
French Southern Territories
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
Haiti
Heard Island and McDonald Islands
Holy See (Vatican City State)
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran

Islamic Republic of Iraq
Ireland
Isle of Man
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Kiribati
Korea

Democratic People's Republic of Korea

Republic of Kuwait
Kyrgyzstan
Lao People's Democratic Republic
Latvia
Lebanon
Lesotho
Liberia
Libyan Arab Jamahiriya
Liechtenstein
Lithuania
Luxembourg
Macao
Macedonia

The Former Yugoslav Republic of Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte
Mexico
Micronesia

Federated States of Moldova

Republic of Monaco
Mongolia
Montenegro
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Northern Mariana Islands
Norway
Occupied Palestinian Territory
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn
Poland
Portugal
Puerto Rico
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saint Barthelemy
Saint Helena Ascension and Tristan da Cunha
Saint Kitts and Nevis
Saint Lucia
Saint Martin (French part)
Saint Pierre and Miquelon
Saint Vincent and The Grenadines
Samoa
San Marino
Sao Tome and Principe
Saudi Arabia
Senegal
Serbia
Seychelles
Sierra Leone
Singapore
Sint Maarten (Dutch part)
Slovakia
Slovenia
Solomon Islands
Somalia
South Africa
South Georgia and the South Sandwich
Islands
South Sudan
Spain
Sri Lanka
Sudan
Suriname
Svalbard and Jan Mayen
Swaziland
Sweden
Switzerland
Syrian Arab Republic
Taiwan Province of China
Tajikistan
Tanzania

United Republic of Thailand
Timor-Leste
Togo
Tokelau
Tonga
Trinidad and Tobago
Tunisia
Turkey
Turkmenistan
Turks and Caicos Islands
Tuvalu
Uganda
Ukraine
United Arab Emirates
United Kingdom
United States
United States Minor Outlying Islands
Uruguay
Uzbekistan
Vanuatu
Bolivarian Republic of Venezuela

Viet Nam
Virgin Islands British
Virgin Islands U.S.
Wallis and Futuna
Western Sahara
Yemen
Zambia
Zimbabwe

Telephone = Telephone number for this site location. NOTE: Please ensure if using a spreadsheet to create the CSV file that you set this column type to TEXT or it will drop the leading zeroes – e.g. 01234 will become 1234. Alternatively, you can check the CSV file in a text editor before uploading e.g. 012345679.

Fax - Fax number of this site location. NOTE: Please ensure if using a spreadsheet to create the CSV file that you set this column type to TEXT or it will drop the leading zeroes – e.g. 01234 will become 1234. Alternatively, you can check the CSV file in a text editor before uploading e.g. 012345679.