The output of an export

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.

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.

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

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

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