Excel Export - Supported Field Types

Select the fields to export in the Available panel of the Select Export Data window. You can export 13 different supported field types from Workpaper records to Microsoft Excel.

The following list describes the supported field types for export and their export format, supported export types, and limitations.

• Date. The export format varies, depending on the user's configured format in the Archer user interface. The date format does not change based on the user's location.

  External Links.Excel separates multiple hyperlinks by semi-colons.

• First Published Date.The export format varies, depending on the user's configured format in the Archer user interface. The date format does not change based on the user's location.

  IP Address. Excel separates multiple hyperlinks by semi-colons.

• Last Update Date. The export format varies, depending on the user's configured format in the Archer user interface. The date format does not change based on the user's location.

• Numeric

• Record Permissions. Excel:

  • Separates both multiple users and multiple user groups by semi-colons.

  • Lists usernames before user groups.

• Record Status

• Related Records.

  • Archer exports the key field of any referenced applications and questionnaires.

  • Excel separates multiple related records by semi-colons.

• Text. Archer cannot export images in text fields.

• Tracking ID

• User/Groups List.

  • Excel:

    • Separates both multiple users and multiple user groups by semi-colons.

    • Lists usernames before user groups.

• Values List.

  • Excel:

    • Adds single values into a dropdown in the cell.

    • Separates multiple values by semi-colons.

  • Archer cannot export images and formatting.