Step 4: Send Merits to Your Team

How to send multiple merits from a spreadsheet

Need to send (or propose) merits in bulk? Upload a spreadsheet with your merit recipient data to save time.

Before you start

  1. Make sure that you've already created a merit template to send to your recipients.
  2. Have your bulk merit data organized into columns on a spreadsheet so it can be easily saved into a pre-formatted .csv file and uploaded to Merit.

How it works

Step 1: Go to the Organization Portal and navigate to the Send Merits folder on the left. At the top of the page, click the Multiple (Spreadsheet) tab.

Screen Shot 2019-09-03 at 1.03.59 PM

Step 2: Select the merit template you wish to use in the Download Sample .csv section.

  • Select the merit template in the dropdown box.
  • Click Download.

Download sample .csv

You now have a .csv template that includes all of the fields associated with that merit template, as well as fields that need to be filled out.

Screen Shot 2019-09-03 at 1.13.46 PM

Step 3: Fill in your sample .csv file with your member information. Do not delete the column headers or the .csv file may not import appropriately. 

Screen Shot 2019-07-31 at 4.23.54 PM

Step 4: Once you have completed your file, make sure that it's saved as a .csv file, then click Import in Merit to upload your file. 

Screen Shot 2019-09-03 at 1.20.10 PM


Import view:

Screen Shot 2019-09-03 at 1.21.47 PM

Step 5: You will be directed to an import workflow. Select the merit template that you wish to use. Merit will then show you the fields associated with this template. Once you've confirmed that you've selected the correct template, click Next.

Import spreadsheet_Choose merit template

Step 6: Merit then directs you to the Upload .csv step of the import workflow. Follow the instructions to upload your .csv file. 

Import spreadsheet_upload .csv

Once the .csv file is successfully uploaded, click Next

Import spreadsheet_upload .csv file 1

Step 7: Map your column headers to the merit template fields. If you started with a .csv file downloaded from the sample .csv option, then your spreadsheet column headers should match these fields. Once you're done, click Next.

Screen Shot 2019-07-31 at 4.18.30 PM

Step 8: Merit will then direct you to review your column mapping. Once you're satisfied, you can click on Propose all to propose these merits, or you can click Send all to send!

Screen Shot 2019-07-31 at 4.29.28 PM