Add/Update People from Excel in the browser client

Add/Update People from Excel in the browser client

To add multiple users to OfficeMaps from an Excel file:

First you need to download the example excel file:

  1. Click on the arrow on the left top corner (on top of your username).
  1. Click on the 'People' button. 
  1. Click on the 'Action' button on the top bar.
  1. Click on 'Download Example Excel File Add/Update People' option.
Downloading Example Excel File
The Table below explain each field on the Example Excel File:


  Excel Column Headers 


  OfficeMaps Corresponding Field

  Username
  Is the 'Username' field when adding a user manually
  Email
  Is the 'Email' field when adding a user manually and is display on the User's Profile
  FirstName
  Is the 'First Name' field when adding a user manually and is display on the User's Profile
  LastName
  Is the 'Last Name' field when adding a user manually and is display on the User's Profile
  DisplayName
  Normally is auto generated from the First and Last Name field
  Initials
  Is the 'Initials' field when adding a user manually and is display on the User's Profile
  Position
  Is the 'Position' field when adding a user manually and is display on the User's Profile
  Phone
  Is the 'Phone' field when adding a user manually and is display on the User's Profile
  PhoneExt
  Is the 'PhoneExt' field when adding a user manually and is display on the User's Profile
  Cell
  This is only display on the User's Profile
  HomePhone
  This is only display on the User's Profile
  ProfileBlurb
  This is the Profile Description on the User's Profile
  WebPage
  This is only display on the User's Profile
  Title
  This is only display on the User's Profile
  Facebook_Profile
  This is the link to the User's Facebook Profile and it is only display on the User's Profile
  Twitter_Profile
  This is the link to the User's Twitter Profile and it is only display on the User's Profile
  Linkedln_Profile
  This is the link to the User's Linkedln Profile and it is only display on the User's Profile
  Skype_Profile
  This is the link to the User's Teams Profile and it is only display on the User's Profile

To upload the file after you fill the 'Example Excel File' just:

  1. Click on the arrow on the left top corner (on top of your username).
  1. Click on the 'People' button. 
  1. Click on the 'Action' button on the top bar.
  1. Click on 'Add/Update From People' option.
  1. Click on 'Select File' and choose the file on your computer.
Add/Upload People from Excel
In addition, the same process and template can be used to update details of users who already exist in OfficeMaps. 
Username and Email cannot be altered via Update, these are the fields used to identify the person during the process.
When performing updates, you can use restrict the columns to Username and or Email to identify the person and the additional field/s that you would like to update.

Note: If you would like to set a value for a field to be blank, use the special code {CLEAR} in the column rather than simply leaving it empty. Columns that have no value for a field will be skipped.




    • Related Articles

    • Update People Work Days from Excel

      OfficeMaps allows administrators to set the default Working Days for any individual to be controlled via a manually uploaded spreadsheet. To obtain the basic template for this spreadsheet on the People Tab, click Actions, Download Example Excel file ...

    • Assign People to Assets From Excel

      OfficeMaps allows Permanent assignments to be controlled via a spreadsheet. To obtain the basic template for this spreadsheet on the People Tab, click Actions, Download Example Excel file to Assign People to Assets. The template has three columns: ...

    • Step 3: Adding People to OfficeMaps

      There are 3 ways to add people to OfficeMaps: First: Manually via the browser interface. This allows you to edit users via the browser. Useful for adding/editing/removing small numbers of users. Users created this way are managed in OfficeMaps. ...

    • Importing, Updating and Exporting People

      Exporting People A spreadsheet containing all OfficeMaps data for every user in the system is available by using the Export To Excel function. This function is available by selecting the People option from the menu and then selecting the Export ...

    • How To: View the map for a future date in the browser client

      View the map for a future date in the browser client There are 2 methods to view the map for a future date: First method:  Click on the reserve button on the top bar. Use the calendar icon to select a day you want to check if a desk is available.  It ...