The steps are:

  1. Create a new custom report in Administration. Make sure Excel is listed as one of the output formats
  2. Select HTML and Excel as available Report Formats
  3. Add a new custom section to the report
  4. In this custom section, add the ESQL query below in the Query section:
  5. Create a Template in the template section to render the report as a table (see example below)
  6. Go to Reports
  7. Choose your new report
  8. Choose MS-Excel as the output format
  9. Click on the button to generate the report
  10. You now have an Excel sheet with the required user list

If you want a list of just the email addresses, this article describes that process.


ESQL Query

select R.USER_ID, R.FIRST_NAME + ' ' + R.LAST_NAME as FULL_NAME, R.USER_NAME, R.EMAIL_ADDRESS, R.IS_ACTIVE from SpiraTestEntities.R_Users as R where R.IS_ACTIVE = True


Example XSLT Template

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  <xsl:template match="/RESULTS">
    <table class="DataGrid" style="width:100%">
        <th>User ID</th>
        <th>Full Name</th>
        <th>Email address</th>
        <th>Is Active?</th>
      <xsl:for-each select="ROW">
            <xsl:value-of select="USER_ID"/>
            <xsl:value-of select="FULL_NAME"/>
            <xsl:value-of select="USER_NAME"/>
            <xsl:value-of select="EMAIL_ADDRESS"/>
            <xsl:value-of select="IS_ACTIVE"/>