Skip to main content
Users
CloudPortalLogin
  • Powered byPowered by
Introduction to Sitecore CDP
Data availability
Managing your account
Managing system settings
Managing guests
Batch segmentation
Data browser
Audience export
Dashboards
Developer center
AI in CDP
  • Sitecore CDP
  • Audience export
  • Understanding audience export
  • The output of an export

The output of an export

This topic describes the file formats you can choose from for the output of an audience export, and the contents of the output.

File formats

When creating an audience export in Basic mode on the Define output screen, you choose whether to export the data as a CSV or a JSON output on the File format tab.

Note

In Advanced mode, the output is JSON. CSV is not supported.

You can further customize the CSV output by choosing whether to:

  • Separate values with commas (,) or pipes (|).

  • Include headers in the output.

  • Wrap values in double quotes (""), for example, "email".

Contents of the output

After the audience export finishes running, one way you can access the exported data is by downloading the output directly from Sitecore CDP. The output is gzipped, and you need to extract it using a file archiver. Alternatively, you can receive the output in external APIs or integration tools such as Sitecore Connect, and extract the output there. This enables you to send the output of an audience export to third-party systems.

sidebar. Output of a full export

For a full export, if the exported data contains up to 500,000 records maximum, the output is one gzipped file containing one CSV or JSON file. If the exported data contains more than 500,000 records, the output is multiple gzipped CSV or JSON files.

sidebar. Output of a delta export

For a delta export, the output contains separate CSV or JSON files for distinguishing added guests from removed guests. If the exported data contains up to 500,000 records maximum, the output is one gzipped file containing multiple CSV or JSON files. If the exported data contains more than 500,000 records, the output is multiple gzipped CSV or JSON files.

Example 3. Example output

Here's an example CSV output. The file format was configured to:

  • Separate values with pipes.

  • Include headers.

  • Not wrap values in double quotes.

RequestResponse
email|age|lastSeen
[email protected]|28|04/09/2025
[email protected]|26|01/09/2025

Here's an example JSON output. The JSON file consists of individual JSON records, one record per line.

RequestResponse
{"email":"[email protected]","age":28,"lastSeen":"04/09/2025"}
{"email":"[email protected]","age":26,"lastSeen":"01/09/2025"}


Do you have some feedback for us?

If you have suggestions for improving this article,

Privacy policySitecore Trust CenterCopyright © 1999-2025 Sitecore