Export a List of Reviewers to MS Excel


Concept

In this topic, you will learn how to export a list of reviewers from G5 to Excel.


Steps:

  1. Click the Reviewer Pool menu item to begin the process of querying a list of reviewers to export to Excel.

    Step 1
  2. Note:  There are different ways to query reviewers.  You may query all reviewers with certain key words in their profiles by using the Smart Search field.  You may also query using a combination of parameters to display a list of reviewers from which to choose.  For this example, the Last Name and State fields will be used.

    Step 2
  3. Enter the information into the Last Name field.

     

    For this example, enter a valid value e.g. "Reviewer".

    Step 3
  4. Click the button to the right of the State field to display the list of states.

    Step 4
  5. Click the DISTRICT OF COLUMBIA list item.

    Step 5
  6. Click the Search button to search for reviewers which match the criteria.

    Step 6
  7. Click the Vertical scrollbar to scroll down and view the search results.

    Step 7
  8. Note:  There are different role types in G5.  Depending on where the reviewer is in the registration process, he or she may have one of three possible roles:

     

    Other - This type of reviewer is not yet in the reviewer pool.  He or she has registered in G5, but has not yet completed the Reviewer registration fields.

     

    Potential Reviewer - This type of reviewer is not yet in the reviewer pool.  He or she has registered in G5, and has completed the Reviewer registration fields.

     

    Reviewer - This type of reviewer is in the reviewer pool, has registered in G5 and has completed the Reviewer registration fields.

    Step 8
  9. Click the Export to Excel button to begin the process of exporting the search results to MS Excel.

    Step 9
  10. The systems displays the standard MS Office exporting to Excel box.

     

    Click the OK button to continue exporting to Excel.

    Step 10
  11. Note:  The data displays in an Excel spreadsheet.  You may format the data as needed for analysis and save as needed to one of your directories.

    Step 11
  12. Once you have saved the file, click the Close button to return to the G5 Search Results screen.

    Step 12
  13. Click the Vertical scrollbar to scroll back to the top of the screen.

    Step 13
  14. Note:  If you would like to perform another search, you may clear your search terms and repeat the process.

    Step 14
  15. Hover over the Main menu and click the Home menu item to return to the My Home Page screen.

    Step 15

Congratulations!

 

You have successfully exported a list of reviewers to Excel.