Exporting People Log Data

Exporting People Log Data

Exporting People Log Data

Export your People Log data to CSV for deeper analysis, sharing with stakeholders, or integration with other systems. The export includes all visible user data plus detailed completion information.


Overview

The People Log export creates a CSV file containing:

  • User profile information

  • Team and manager details

  • Completion statistics

  • Content-specific completion dates (when filtering by specific content)

  • Custom field values

This gives you flexibility to analyse the data in spreadsheet applications, create custom reports, or import into other business systems.


Pre-requisites

Role Requirements

To export People Log data, you need one of these roles:

  • Owner – Can export all user data

  • Admin – Can export all user data

  • HR – Can export all user data

  • Reporter – Can export all user data

  • Manager – Can export data for direct and indirect reports only


Quick-Start Guide

Step 1: Configure Your View

Apply any filters you need to narrow down the data you want to export. The export will include only the users currently shown in your filtered view.

Step 2: Start the Export

Click Actions in the toolbar, then select Export CSV.

Step 3: Wait for Processing

For smaller datasets, the download begins immediately. For larger exports:

  1. The export processes in the background

  2. You'll see a notification when it's ready

  3. Click the notification to download your file

💡 Tip: You can continue working while the export processes. You'll be notified when it's complete.

Step 4: Open Your File

The CSV file downloads to your default downloads folder. Open it in your preferred spreadsheet application (Excel, Google Sheets, Numbers, etc.).


Functionality Breakdown

Standard Export Columns

Every People Log export includes these columns:

Column

Description

Column

Description

first_name

User's first name

last_name

User's last name

email

User's email address

job_title

User's job title

invitation_sent_at

Date the invitation was sent

invitation_accepted_at

Date the user accepted their invitation

status (at time of export)

Current status: 'active' or 'on a break'

manager

Whether the user is a manager ('yes' or 'no')

managed_by

Name of their manager

assigned

Number of items assigned

completed

Number of items completed

not_completed

Number of items not yet completed

percentage

Overall completion percentage

primary_team

User's primary team name

other_teams

List of secondary teams

locations

User's location(s)

Conditional Columns

These columns appear based on your organisation's settings:

Column

When It Appears

Column

When It Appears

company

Only for Parent Company accounts viewing child company data

signed_up_via_form_at

When self-registration is enabled

coach

When coaching feature is enabled

coached_by

When coaching feature is enabled

custom_terms_accepted_at

When custom terms are enabled

privacy_policy_accepted_at

When privacy policy acceptance is enabled

[Custom field names]

Any custom fields configured for your organisation

Content Completion Columns

When you filter by specific content items, the export includes a completion date column for each selected item:

  • Format: [Content Name] (completed at)

  • Value: The date and time the user completed that specific item, or blank if not completed


Working with Exported Data

Opening in Excel

  1. Open Excel

  2. Go to File > Open

  3. Select your downloaded CSV file

  4. Excel will automatically parse the columns

💡 Tip: If dates appear incorrectly, use Excel's Text to Columns feature to reformat them.

Opening in Google Sheets

  1. Go to Google Sheets

  2. Click File > Import

  3. Upload your CSV file

  4. Select Replace spreadsheet or Insert new sheet

Common Analysis Tasks

Completion Rate Analysis:

  • Use pivot tables to group by team and calculate average completion rates

  • Create charts showing completion trends over time

Compliance Tracking:

  • Filter for users with completion percentage below 100%

  • Identify overdue completions using date columns

Manager Reporting:

  • Group by the 'managed_by' column to see team performance

  • Share filtered views with individual managers


Best Practices

Before Exporting

  • Apply filters to get only the data you need – smaller exports are faster

  • Check your view shows the expected users before exporting

  • Consider the sensitivity of the data you're exporting

Data Handling

  • Store exported files securely – they contain personal data

  • Delete old exports when no longer needed

  • Follow your organisation's data protection policies

Large Exports

For exports with thousands of users:

  • Expect background processing – you'll be notified when ready

  • Consider breaking into smaller chunks using filters

  • Allow extra time during peak usage periods


Frequently Asked Questions (FAQs)

Q: How long does an export take?
A: Small exports (under 500 users) typically complete in seconds. Larger exports may take several minutes and process in the background.

Q: Can I schedule automatic exports?
A: Automatic CSV exports aren't currently available. For regular reporting needs, save your filter configuration as a report for quick re-running.

Q: Why are some columns blank?
A: Blank values indicate the data isn't available for that user (e.g., no manager assigned, no custom field value set).

Q: Can I export to Excel format directly?
A: Exports are in CSV format, which Excel opens natively. You can then save as an Excel file (.xlsx) if needed.

Q: What character encoding is used?
A: Exports use UTF-8 encoding, which supports international characters.


Troubleshooting

Issue

Solution

Issue

Solution

Export button not responding

Check your browser isn't blocking downloads. Try refreshing the page

File won't open correctly

Ensure you're using a recent version of your spreadsheet application. Try opening as plain text first to check the format

Special characters display incorrectly

Your spreadsheet application may not be detecting UTF-8 encoding. Manually specify UTF-8 when importing

Export seems incomplete

Large exports process in the background. Wait for the completion notification

Missing expected columns

Some columns only appear when specific features are enabled for your organisation


Last Reviewed: November 2025