Skip to main content

Import Format

The Person import requires data to be uploaded in a valid CSV file format. Any values that need to be escaped in this format should be enclosed in double-quotes (").

The following column headings should be present in the first row:

HeadingAlternate headingContentRequired
forenameForename of the PersonYes
surnameSurname of the PersonYes
titlesalutationTitle (e.g. Mr, Dr, Rev)No
middle_namesMiddle name(s) of the PersonNo
telephonePrimary telephone number for the PersonNo
telephone_secondarySecondary telephone number for the PersonNo
addressEither a Jadu Connect address reference OR a UPRN for the address of the Person.No
emailA valid email address for the Person. Where the Create user accounts for imported people option is enabled, inclusion of this for a row will also result in a User record being created for the Person and the User will be sent an email invite.No

Any additional columns in the CSV file will be ignored.