All Collections
Importing your contact records using Excel ( .XLS template )
Importing your contact records using Excel ( .XLS template )

How to import, export and delete multiple contact records using the automatic upload .xls template

Updated over a week ago

Adding customer, supplier and contractor records in Workever is simple and can be undertaken manually for individual records or completed using the upload feature.

Multiple records must be saved using the .xls template which can be downloaded directly from the app or requested from the help desk.

XLS is not a format Mac Contact book currently supports, so the best option is to export your address book as a vCard (File > Export > Export vCard...) and then go to to convert the vCard to a comma separated xls.

Using the import customers feature 

Navigate to the 'Contact' section using the left hand menu pane, highlight the 'Import Contacts' selection and select 'Apply':

A pop-up window will offer an opportunity to download the .xls template as well as provide the option to import a completed file:

Once you have selected a completed .xls file, select the 'Import Now' button and your files will automatically be uploaded to the app.

.xls template - Format

The complete template must be saved as a .xls in order to be compatible with the import feature. 

The header contains information about what should be updated in each column:

  • customer_type (company or person) this is important to include so that it indicates whether a customer entry is 'commercial'(company) or 'residential'(person). *mandatory field

  • company_name  *(mandatory for commercial customers)

  • customer_title

  • customer_first_name  *(mandatory for domestic)

  • customer_last_name  *(mandatory for domestic)

  • first_line_address

  • second_line_address

  • town

  • state

  • post_code

  • country

  • phone_number

  • additional_phone_number

  • mobile_number

  • fax_number

  • email_address *(mandatory for both commercial and domestic)

  • website

**Mandatory Fields: please remember that some of the above field are mandatory (first and last name with domestic customers and company name with commercial customers)**

Exporting or deleting contact data

You can also use this feature to export or delete the details of a selection of contacts. 

Using the radial tick boxes to the left of each contact, select the records that you wish to export or delete and then select the corresponding option in the 'Export/Import/Delete Contact' box before selecting 'Apply':

When exporting contacts a file will automatically created and saved to your local downloads folder.

When deleting contacts you will be prompted with a warning that your actions will permanently remove all associated files. By confirming your choice with 'Delete' will remove these files.

Did this answer your question?