Klaviyo CSV to Dashboard
Klaviyo exports carry e-commerce-specific fields, SMS and email marketing consent status alongside list or segment membership, laid out with header names particular to how Klaviyo structures audiences internally. Normalize first so the breakdown below reads a stable schema instead of Klaviyo's raw field names.
Step 1: Normalize the Export
Run the raw export through the Klaviyo Normalizer. It maps fields onto a consistent Email / FirstName / LastName / ListName / ConsentStatus / SubscribedDate schema, preserving consent-related columns rather than dropping them.
Step 2: Pick a Breakdown
Subscribers by List
Counts subscribers per list or segment on the normalized column.
Subscribers by Consent Status
Surfaces how many contacts are actually opted in before a campaign send.
Deduplicate Before Migrating
Check for duplicate emails across multiple exported segments.
Also Running Shopify? →
Cross-reference subscriber lists against order and customer data.
Frequently Asked Questions
Is consent status preserved when normalizing?
Yes, SMS and email consent columns are kept intact, which matters for compliance if you re-import the list somewhere else.
Is this specific to Shopify stores?
Klaviyo is most common among Shopify and e-commerce sellers, but the normalizer works on any Klaviyo list or segment export regardless of the storefront platform behind it.
Switching e-commerce marketing platforms?
Normalize first, consent data stays intact.
Open Klaviyo NormalizerTurn this into a saved workflow
Create a free account to save the steps from this guide as a reusable workflow and re-run it on any file, from any device.