Spreadsheet Import: Step-By-Step Instructions

If you need to manage user data for multiple users, Recognize's Spreadsheet Import can be a convenient way to add users, update email addresses, and update user information such as display name, team, roles, managers, and anniversaries. This spreadsheet can be imported directly from within Recognize by a Company Admin.

How To Import a Spreadsheet

  1. Click 'Menu' in the upper right corner of Recognize
  2. Select 'Company Admin' from the drop-down menu
  3. Select 'Users' from the navigation menu on the far left

    Screen_Shot_2020-12-18_at_10.28.25_AM.png

  4. Select 'Import' from the top-right menu on the 'Users'' page

    Screen_Shot_2020-12-18_at_10.43.26_AM.png

  5. Once the 'Spreadsheet Import' page has populated, download the sample spreadsheet to fill out

    Note: use the sample spreadsheet template to ensure proper data import. Do not rename the columns, or the information will not be imported correctly. Delete any columns that you are not filling out, as columns that are left blank could overwrite any previously uploaded data. Format dates as strings, and use commas to separate roles or teams.

  6. To upload your users’ data, Select 'Choose File' and select the completed spreadsheet
  7. Checking the box, 'Update Only' will only update the attributes of users in the data-sheet who are found in Recognize. If new users are found in the data-sheet, they will not be added
  8. Checking the box, 'Remove Users' will update the attributes of users in the data-sheet and disable users who are not present in the data-sheet
  9. Checking the box 'Dry Run' runs the data-sheet and gives a report of potential changes or errors without actually making any changes. *Do not select this when you are ready to make changes. 
  10. If 'Send Invitations to new users' is enabled and users are added, invitations will be automatically sent out. If not enabled, users who are added will remain in a "pending invite" state and can be sent an invitation at a later date. 
  11. Select 'Import'. By default, uploading a spreadsheet will add new users and update existing users' email addresses unless you have checked the above options

Screen_Shot_2022-08-08_at_11.53.55_AM.png

Please Note the Following:

  • Your import will be queued and processed in the background.
  • Stay on this page to watch the progress.
  • You can leave this page and the import will continue in the background. 
  • You will be emailed when the import is complete. 
  • If there are any errors, a spreadsheet will be created with the results. This spreadsheet is accessible from the completion email as well as from the "Last Import" section on the Spreadsheet import page above. 

  • If you are using the Spreadsheet Import to change a user's email address, it is important to remember that each time a new email address is added to the Spreadsheet Import, it will create a new profile and disable the profile associated with the previous email address. To avoid this, we suggest using the Employee ID column in the spreadsheet import. This way, we can identify users based on the Employee ID instead of the email address, which will prevent the creation of multiple accounts.

    Note: If you have duplicate accounts, please contact us at support@recognizeapp.com with the User’s name, original email address, and the new email address that you would like the original account information to be merged into, and we will merge the accounts for you.