Skip Navigation

Export users to a file

  1. In the navigation bar, click
    Users
    >
    Users
    .
  2. Select the check boxes beside the users you want to export.
    To include dependent users in the export, choose
    Sponsors and Non-Sponsors
    or
    Sponsors
    from the pull-down menu and then select
    Include Dependents
    .
  3. On the
    Users
    screen, click
    More Actions
    >
    Export
    >
    Users
    .
  4. On the
    Export Users
    screen, click
    Add >
    to select the columns you want to include in the export file.
    • The export process allows you to export up to 79 columns of user data into a PDF file.
    • You cannot include the password column in the export file.
  5. Optionally, use the
    Move Up
    and
    Move Down
    buttons next to the
    Selected Columns
    field to change the order the information appears in the export file.
    Click the
    Reset to columns displayed in User List
    to reset the Selected Columns field to its default values.
  6. Click
    Export PDF
    or
    Export CSV
    .
    You can export up to 1000 users to a PDF file. You can export up to 25,000 users to a CSV file in a single export. If you are exporting more than 25,000 users to a CSV file, select a grouping of 25,000 users to export.
If you include a geolocation attribute in the export, if the user profile contains a physical address in the geolocation attribute, it is exported to two columns. The first column displays the geolocation attribute in the POINT(longitude latitude) format. The second column displays the attribute as the text string the user entered in their profile. For example, if you have a geolocation attribute called Office Location, a column with a heading Office Location is exported that contains the address in the POINT (longitude latitude) format. A second column with a heading Office Location (Physical Address) is exported that contains the text string the user entered in their profile.