Will this file import into Klaviyo?
Find out before you upload. This checks your spreadsheet against Klaviyo's real profiles rules, maps your columns to its field names, and shows you exactly which rows would be rejected — with row numbers.
Runs in your browser. Nothing is uploaded.
Drop a CSV or Excel file here
Or choose a file — nothing leaves your browser.
Klaviyo doesn't need a specific column so much as an identifier: every row must carry an email, a phone number or an ExternalID. Rows with none of the three are dropped, and SMS numbers must be E.164.
- Every row needs at least one of Email, PhoneNumber or ExternalID.
- Phone numbers should be E.164 (+12025550123) so SMS delivery resolves.
- Using PhoneNumber as the only identifier requires SMS enabled on the account.
- Consent columns are applied per row; without them Klaviyo asks you to set one consent type for the whole file.
Common questions
Which columns does Klaviyo require for profiles?
Klaviyo doesn't demand one specific column — it needs an identifier. Every row must carry at least one of Email, PhoneNumber or ExternalID. Rows with none of them are skipped, and this page lists exactly which rows those are.
Why did my Klaviyo import fail?
Klaviyo doesn't need a specific column so much as an identifier: every row must carry an email, a phone number or an ExternalID. Rows with none of the three are dropped, and SMS numbers must be E.164. Drop your file above and you'll get a row-by-row list of what Klaviyo would reject, with the row numbers.
Is my file uploaded anywhere?
No. The mapping and validation run entirely in your browser using JavaScript. Your spreadsheet never reaches our servers, which matters when the file is a customer list.
Does it change my data?
It renames your column headers to Klaviyo's exact field names and reformats values that Klaviyo would otherwise reject — phone numbers, yes/no fields and picklist casing. Every change is listed before you export, and nothing that can't be safely converted is touched.
Field rules sourced from Klaviyo's own documentation.