Importing People Profiles

Locating the Import Template

  1. Navigate to the control panel
  2. Click on Site Content
  3. Click on Import
  4. Choose the type of content you want to Import from the enabled App list. Learn how to Enable an App

Content that can be imported will have a link to a downloadable excel spreadsheet template. (see image below)
download template image

Importing People Profiles - Navigating the Downloadable Template

Person Profile Template Site View
edit profile
edit profile
edit profile

Note: The first row is reserved for the field titles and optional taxonomy vocabulary fields. Do not remove or alter text in the first row from the template.

COLUMNS A - D: Name Fields
Note: Prefix & Middle name fields are optional.

person name excel spreadsheet

COLUMN E: Photo Field
Note: This field is optional. Photos added here will import over the person's profile photo.

Files should be entered here as URL paths. These files should already exist either on your site. You cannot upload a local file from your computer here. To learn how to add files to your site prior to import, see Adding Files.
profile photo excel spreadsheet

COLUMNS F - H: Titles Fields
Note: These fields are optional.

person title excel spreadsheet

COLUMN I: Address Field
Note: This field is optional.

profile address excel spreadsheet

COLUMN J: Phone number field
Note: This field is optional.

excel spreadsheet

COLUMN K: Email Field
Note: This field is optional.

email excel spreadsheet

COLUMNS L - Q: Website Fields
Note: These fields are optional.

Enter in Website names in fields L, N, & P.
Enter in website URLS in fields M, O, Q.

websites excel spreadsheet

COLUMN R: Bio Content
Note: This field is optional.

excel spreadsheet

COLUMN S: Profile Created Date
Note: This field is optional.

Leaving this field blank will result in all imported profiles having the same date (date of import).
excel spreadsheet

COLUMN T: Page Path (URL Path)
Add the URL path ending here. For example, instead of adding help.theopenscholar.com/people/homer-simpson, you'll just need to add homer-simpson.
excel spreadsheet

Saving your CSV File

Make sure to save your CSV file using the UTF-8 file format to ensure that your contents are imported without issue.

The Import Process

  1. Navigate to the control panel
  2. Select Site Content
  3. Click Import
  4. Select Person
  5. Upload the person.csv file
    upload file
  6. Click Submit
  7. Navigate to Site Content > Browse > Content > Type: Person to view people profiles.

Updated: 15Oct2018