Running a Query

1. Navigate to the Slate homepage; Homepage Queries will be located in the bottom left part of the screen
   
2. Select the query link you wish to run
   
   
3. In the following page, select the Run Query button.
   
   
4. Review the query results to see what kinds of information can be populated from this query. Please note that you can horizontally scroll to reveal more columns of data. Shown below is an example query result.

Exporting to an Excel Spreadsheet

The default export option is downloading the populated data into an Excel Spreadsheet.

To do so:

1. Select Excel Spreadsheet as your Output
2. Click the Export button.

Excel Tips 

Changing link text into clickable hyperlinks

When you export Homepage Query results to Excel, you will notice that any URL (Application URL, Reader URL, Person URL) will only display in text, not a clickable link. To convert these text fields into clickable links quickly, follow the directions below.

1. Open the query results in Excel. (You may need to enable editing.)
2. Add a new blank column by (1) right-clicking the top of a column and then (2) selecting Insert.
   
3. In the top cell of the column, type in the formula =HYPERLINK( as shown in the screenshot below.
   
4. Select the cell with the link text, which should add that cell name to your formula. in the example shown below, the selected E2 cell was added to the formula).
   
5. If you wish to change the link to a more user-friendly hyperlink, add a comma and then select the cell that has the applicant's name. In the example below, the selected A2 cell was added to the formula, and now the whole formula reads =HYPERLINK(E2,A2).
   
6. If you click out of the cell now or select your Enter key, you will see that the text has been changed to a hyperlink of the applicant's name. In the example below, you will see that it has changed to a clickable hyperlink Potter, Harry.
   
7. To apply this same formula to all of the cells in this column, hover over the bottom right hand corner of the cell, until your cursor turns into a + select tool. Double-click the corner, and then the formula will be applied appropriately to all of the cells in this column.
   
   
8. If you don't want to distract viewers of this Excel sheet with columns, you can hide the old link text column by (1) right clicking the column header and then (2) selecting Hide.
   

"Stale Request" Error Troubleshooting

If one of your faculty reviewers is receiving a "Stale Request" error when trying to click a link or hyperlink of the application, it is likely due to an outdated version of Excel. The reliable fix is to update to Office 365 so the links will work as intended.

One workaround is to provide a column of the link text in your spreadsheet as well as a clickable hyperlink. Reviewer experiencing this "Stale Request" error should be able to copy that link text and paste it into their browser to access the application.