web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Is it possible to crea...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Is it possible to create a custom solution to export Real-time Segments to Excel?

(1) ShareShare
ReportReport
Posted on by Stephani 4
I know that Microsoft has on their roadmap the ability to export Real-time segments to Excel - but until we have this feature, is it technically possible to create a custom solution to do this?  If so - can you provide some tips/tricks/how-to information to get us started?
I have the same question (0)
  • Suggested answer
    PaulineKolde Profile Picture
    PaulineKolde 732 Moderator on at
    Hi Stephani, 
     
    Amey Holden has created a great solution for segments in realtime marketing. Maybe this also helps for your request: Browse and Search Segment Membership in Customer Insights - Journeys — Amey Holden | Anything But Code | Dynamics 365 Marketing & Power Platform
  • Suggested answer
    Yogesh Mulay Profile Picture
    Yogesh Mulay 54 on at

    While native export to Excel for Real-time segments is not yet available in Microsoft Dynamics 365 Marketing, it's technically feasible to build a custom solution to achieve this functionality. Here's a breakdown of how you can approach this:

    Conceptual Approach:

    1. Retrieve Segment Data:

      • Use the Dynamics 365 Marketing API to fetch the members (contacts) of the Real-time segment.
      • You'll need appropriate authentication and authorization to access the API.

    2. Format Data for Excel:

      • Organize the retrieved contact data into a structure suitable for Excel (e.g., rows representing contacts, columns for attributes like name, email, etc.).
      • Consider any data transformations or filtering required based on your specific needs.

    3. Generate Excel File:

      • Utilize a library or tool to create an Excel file (e.g., OpenXML SDK, EPPlus, ClosedXML).
      • Populate the Excel file with the formatted contact data.

    4. Provide Download or Export:

      • Make the generated Excel file available for download to the user.
      • You could trigger this process manually (e.g., a button in the Dynamics 365 Marketing interface) or automate it based on certain events or schedules.
     
    Please mark my answer verified if this is helpful!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Manoj - ManoVerse Profile Picture

Manoj - ManoVerse 131 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 91

#3
Chris1968 Profile Picture

Chris1968 20

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans