Export data from Yammer Enterprise

As a verified admin, you can export Yammer Enterprise data to monitor usage and content and for discovery and compliance purposes. The following table lists the four ways to export data.

Method

Purpose

Export user and admin list

Identify status of current admins and users, and review email, title, location, and department of each user.

Export Yammer network data

View and audit all network data for all users. You can specify a date range, and choose whether to include files and external network data.

Export data for one user

Identify all data related to one user. You can use this export to identify data that needs to be deleted to comply with a GDPR data subject request.

Set up automatic data exports

Automate exports that need to be done on an ongoing basis for compliance by using the DataExport API .

Note: Exported data can't be used for migrating content between Yammer networks. For migration information, see Network migration: Consolidate multiple Yammer networks.

Export user and admin list

  1. In Yammer, click the Yammer settings icon Yammer settings icon , and then click Network Admin.

  2. Click Export Users.

    Yammer Export Users menu

  3. On the Export Users page, choose Export all users, and then click Export.

    Yammer Export Users options - Export all users or Export all users since (date)
  4. Save the exported file. The file is saved as a compressed file with a .zip file name extension.

  5. Go to the location where you saved the compressed file and expand it.

    The export contains the following files:

    File

    Contents

    log.txt

    Summary of the export.

    request.txt

    The parameters of the export.

    Admins.csv

    A list of current admins, their email addresses, and whether they are a verified admin or a network admin.

    For more information on the types of admins in Yammer, see Manage Yammer admins.

    Networks.csv

    Information about your home network and any external networks, including the name, URL, creation date, whether it is moderated, whether it has a usage policy, and the number of users.

    Users.csv

    The ID, name, email, job title, location, department, user ID, deletion status (deletion date, name and id of person who deleted the user), join date, suspension status (deactivated date, name and ID of person who deactivated the user), and the state of the user (active or soft-deleted).

    A user is who is in the soft_delete state means the user is either

    • pending, if there are no joined_at, suspended_at, or deleted_at values)

    • suspended (deactivated), if there is a suspended_at value, but no deleted_at value

    • deleted, if there is a deleted_at value

    Guest users can be identified in the user export by reviewing the email address field. If the email address doesn't match the domain of the home network, the user is a guest.

    The api_url is the URL used to obtain user metadata. For more information about using the data in this field, see the Yammer developer documentation.

Export Yammer network data by date range and network

  1. In the Yammer admin center, go to Content and Security > Export Network Data.

  2. Specify the data to include:

    Export page, showing export options
    • Date range:    Only data in the specified date range will be included.

    • Include attachments: If not selected, you'll get a list of files. If selected, you also get a Files folder with all files in their native format.

    • Include external networks: If not selected, you'll only get data from your home network. If selected, you'll get a separate folder for the data from each network. Each network is identified by its ID, and the full network names are listed in Networks.csv.

      Each network has its own folder, labeled with the network ID
  3. Click Export.

    Data is exported into a .zip file. If there is more than one network exported, a separate folder is created for each network.

    File

    Contents

    log.txt

    Summary of the export.

    request.txt

    The parameters of the export.

    Admins.csv   

    Lists the name, email, and type of all Yammer admins for each selected network.

    Files.csv   

    For any file added or modified during the specified date range, lists the Yammer ID, type of file, name, description, and path to the file in Yammer, along with metadata including the group it was posted in.

    Files.csv does not contain the actual file. If you selected to include attachments in your export, files can be found in the Files folder of the .zip file. Use the ID from Files.csv to identify a specific file in the Files folder.

    For information about how to go directly to a specific file in Yammer, see Find and delete specific messages or files.

    Groups.csv   

    For any group created or modified during the specified date range, lists the Yammer ID, name, description, privacy status, whether the group is internal or external, link to the group, who created the group, creation date, and updated date.

    Messages.csv   

    For any message sent or modified during the specified date range, lists the message ID, thread ID, group ID, group name, privacy status, sender ID, name and email, the full body of the message, attachments, and creation and deletion information.

    For information about how to go directly to a specific message in Yammer, see Find and delete specific messages or files.

    MessageThreadsOutbound.csv   

    Includes IDs of external participants in outbound messages.

    MessageVersions.csv   

    Includes IDs and modification information for messages that have been edited.

    Networks.csv   

    Lists your home network and all external networks included in the export.

    Pages.csv   

    For any page created or modified during the specified date range, lists the IDs, dates, and owners of the page.

    Topics.csv   

    For any topic created during the specified date range, lists the creation information and a link to the topic.

    Users.csv   

    For any user who joined, or was deleted or suspended during the specified date range, lists email, job-title, location, department, a link to the user, and information about the users current state.

    A user is who is in the soft_delete state means the user is either

    • pending, if there are no joined_at, suspended_at, or deleted_at values)

    • suspended (deactivated), if there is a suspended_at value, but no deleted_at value

    • deleted, if there is a deleted_at value

    Guest users can be identified in the user export by reviewing the email address field. If the email address doesn't match the domain of the home network, the user is aguest.

    The api_url is the URL used to obtain user metadata. For more information about using the data in this field, see the Yammer developer documentation.

    Files folder:   

    This folder contain files that have been created or modified during the specified time period. Files are in their native format but are named with their Yammer ID. For example a PowerPoint presentation might be listed as 127815379.pptx.

    For information about how to go directly to a specific file in Yammer, see Delete specific messages or files.

The following types of data are not included in this export:

  • Data available in the user's settings, including their profile, the networks they are members of, their account activity, applications, notifications, and language preferences, and their org chart.

  • User's activity data.

  • Bookmarked messages, group membership, followed or following users, or followed topics. To find this information for a user, click the user's name.

To find this data for an individual user, click the Yammer settings icon Yammer settings icon , click People, and click the name of the user whose data you want to view. This page shows the user's profile, conversations they've participated in, any files, images, and videos they have posted, along with their bookmarks, followed and following users, and followed topics.

Export data for one user

Note: You must export user data for each network the user is a member of.

  1. In the Yammer admin center, go to Content and Security > Export User Data.

  2. Type the user's name and select the user.

  3. Click Export.

    Data is exported into a .zip file containing the following files.

    File

    Contents

    log.txt

    Summarizes the number of entries in each .csv file, and lists any errors that occur during the export.

    request.txt

    Parameters use for the export.

    Files.csv   

    For any file added or modified by this user, lists the Yammer ID, type of file, name, description, and path to the file in Yammer, along with metadata including the group it was posted in.

    Files.csv does not contain the actual file. If you selected to include attachments in your export, files can be found in the Files folder of the zip file. The file ID in Files.csv can be used to identify the files in the Files folder or to go directly to the file in Yammer.

    Groups.csv   

    For any group created or modified by the user, lists the Yammer group ID, name, description, privacy status, whether the group is internal or external, link to the group, creation date, and updated date. This file also includes the aggregated total number of polls the user voted on, and the polls the user created.

    Messages.csv   

    For any message sent or modified by the user, lists the message ID, thread ID, group ID, group name, privacy status, sender ID, name and email, the full body of the message, the ids for attachments, and creation and deletion information. A list of polls you created will also be provided.

    Topics.csv   

    For any topic created by the user during the specified date range, lists the creation information and a link to the topic.

    Files folder   .

    This folder contain files that have been created or modified by the user during the specified time period. Files are in their native format and are named with their Yammer ID. For example a PowerPoint presentation might be listed as 127815379.pptx.

  4. When the user's account activity data is ready, you'll receive a Yammer inbox message with a link to the data. Click the link to open it.

Exported data does not contain bookmarked messages, group membership, followed or following users, followed topics, the user's notification, application, and language settings, and org chart. To find this data for an individual user, click the Yammer settings icon Yammer settings icon , click People, and click the name of the user whose data you want to view. This page shows the user's profile, conversations they've participated in, any files, images, and videos they have posted, along with their bookmarks, followed and following users, and followed topics.

Find and delete specific messages or files

If you have the ID for a message or file, you can go directly to it in Yammer, and delete it if needed.

  • To find and delete a specific message in Yammer:

    1. Build the URL for the message. Use https://www.yammer.com/<network_name>/#/Threads/show?threadId=<thread_id>. For example, https://www.yammer.com/contosomkt.onmicrosoft.com/#/Threads/show?threadId=1040647232.

    2. In the message, click the More icon More icon (...) , and then click Delete.

  • To find and delete a specific file in Yammer:

    • Use the Search box in Yammer. For example, for a file named 12345678.pptx in the export, search for 1235678.pptx. In the search results, click Go to File file, and then click Delete this File.

    • Or, build the URL for the file. Use https://www.yammer.com/<network_name>/#/files/<file_number>, for example https://www.yammer.com/contosomkt.onmicrosoft.com/#/files/12345678. On the Yammer page for the file, click Delete this File.

Set up automatic data exports

To set up automatic recurring exports, use the Yammer API. For information about the Data Export API, go to /export on the Yammer Developer Center.

See Also

View Group Insights in Yammer

View the Yammer Activity report

Audit Yammer user data

Manage GDPR data subject requests in Yammer Enterprise

Manage Yammer data compliance

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×