Export Profiles
You can export Profile data from several places in Apsis One — the 360 Profile view, a Subscription, a Segment, or a Report. Exports come as CSV or XLSX files (single-Profile GDPR exports come as JSON). Bulk export is also available via the Apsis One API.
💡 Good to know: In the export file you get a column with the export key, that is the unique export identifier per profile, but you cannot use it as a key when importing profiles back.
In this Article
Export a Single Profile
Use this option when you need a complete export of one individual's data — typically to fulfil a GDPR right to access request.
In Audience, click the Profiles tab and enter the email address, mobile number or CRM ID for the Profile you wish to export. Open the profile.
Double-click the Profile, or click Open in the bottom bar. Scroll to the bottom of the 360 Profile view and click GDPR.
Click Export Data. The file download will begin automatically. The file is delivered in JSON format.
💡 Good to know: The single-Profile export is the only export that uses JSON. All bulk exports (Subscription, Segment, Report) come as CSV or XLSX.
Choose what to include in your export
The export options panel is the same across Subscription, Segment and Report exports. From here you choose the file format and which Profile data to include.
Pick your File type. The drop-down offers three options:
CSV — best for importing into another system.
GZIP — a compressed CSV, useful for very large exports where file size matters.
XLSX — best when a person will open the file in Excel.
Tick Add Attributes if you want to include Attribute values for each Profile. A second picker appears.
Click the picker and choose which Default Attributes to include — for example CRM-ID, Email, First Name, Date of Birth.
Tick Select All at the top to include every Default Attribute in one click.
Each chosen Attribute appears as a chip below the picker. Click the × on a chip to remove it from the export.
Tick Add Tags if you want to include Tag values for each Profile. A second picker appears.
Click the picker and choose which Tags to include — for example Ambassador & VIP, Active in Welcome flow, Risk of churn.
Tick Select All at the top to include every Tag.
Each chosen Tag appears as a chip below the picker. Click the × on a chip to remove it.
Click Export. The file download begins automatically.
💡 Good to know: The Attribute and Tag pickers let you build a narrower export — only the columns you actually need. This keeps file sizes down and makes the export easier to work with in another tool. If you want everything, use Select All in each picker.
Export Profiles from a Subscription
Use this option when you want every Profile consented to one specific Subscription. If you need Profiles from several Subscriptions, repeat the process for each one.
In Audience, double-click the specific Subscription or click on it and choose Open in the bottom menu bar.
On the bottom bar, click Export all Profiles.
Adjust your export options:
Choose between CSV, GZIP and XLSX file format.
Tick Add Attributes to include Profile Attributes.
Tick Add Tags to include Profile Tags.
Click Export. The file download will begin automatically.
Export Profiles from a Segment
Use this option when you need only the Profiles that match a specific set of conditions.
Head over to Audience and find Segments in the menu.
Select an existing Segment, or create a new one. After creating your Segment, you can see and export the Profiles that match it.
From the Segments tab or while in the Segment Builder, click Show Profiles on the bottom bar.
A list of Profiles will appear. You will see a preview of the first ten Known and Unknown Profiles.
Click Export all Profiles on the bottom bar.
Adjust your export options (file format, Attributes, Tags).
Click Export. The file download will begin automatically.
Export Profiles from a Report
Export Profiles from Email, SMS or Marketing Automation Reports — for example, everyone who opened a specific campaign, or everyone who clicked a particular link. The example below uses an Email Report, but the process is identical across all three tools.
Head over to the Scheduled & Sent or Active & Paused tab in the relevant tool.
Double-click to open the Report.
On the left, pick a tab to select which Profiles you want to export based on their interactions with your activity (Opened, Clicked, Bounced, and so on).
On the top right, click Export.
Adjust your export options.
Click Export. The file download will begin automatically.
File format and size limits
Export source | Available formats | Optional includes | Maximum file size |
Single Profile (GDPR) | JSON | — | — |
Subscription | CSV, GZIP, XLSX | Attributes, Tags | 50 MB |
Segment | CSV, GZIP, XLSX | Attributes, Tags | 50 MB |
Report (Email, SMS, Marketing Automation) | CSV, GZIP, XLSX | Attributes, Tags | 50 MB |
ℹ️ Need a larger export? The maximum file size for UI exports is 50 MB. If your export exceeds that limit, choose GZIP to compress the file, narrow the Attributes and Tags you include, or contact Support. You can also use the Apsis One API to export in batches.
Use Cases
Fulfil a GDPR data access request
A Profile asks for a copy of everything you hold about them. Open the Profile, click GDPR → Export Data, and send the resulting JSON file.
Share a high-intent audience with your sales team
Build a Segment for "viewed pricing page in the last 7 days and opened the last newsletter". Use Show Profiles → Export all Profiles with Attributes included, and hand the file to sales.
Pull a list of subscribers for an external platform
Open the relevant Subscription, click Export all Profiles, choose CSV, include Attributes, and import the file into your other tool.
Follow up on a specific campaign
Open the Email Report for a recent campaign, pick the Clicked tab, click Export, and send the list to your account managers for follow-up calls.
Troubleshooting
❓ My export file is empty or smaller than expected.
Check that the source actually contains Profiles — open the Subscription, Segment or Report first and confirm the count. For Segments, also confirm that your conditions are evaluating as you expect. A Segment with no matching Profiles will export an empty file.
❓ The export failed or hit the 50 MB limit.
Try unticking Add Attributes and Add Tags to reduce file size. If the data set is genuinely too large, contact Support or use the Apsis One API to export in batches.
❓ The Segment shows a Profile count but the export is smaller.
Segments include both Known and Unknown Profiles. The export only contains Profiles with the identifiers you can act on. The difference between the count and the export size is usually Unknown Profiles without a usable identifier.
❓ I want to schedule recurring exports.
Scheduled exports are not available from the UI. Use the Apsis One API to automate exports from your own systems.
❓ Which file format should I choose – CSV, GZIP or XLSX?
Use CSV when the file will be imported into another system. Use GZIP when the export is large and file size matters — it is a compressed CSV. Use XLSX when a person will open the file in Excel and review it directly.
❓ Are Events included in my export?
No — bulk exports (Subscription, Segment, Report) include Profile Attributes and Tags, but not the Event timeline. Only the single-Profile GDPR export includes Events. For Event-level analysis, use the Apsis One API.