Klaviyo or Shopify customer import: “Phone is invalid”
Format phone numbers with a country code so SMS and customer imports accept them.
The message you see
Phone is invalid / phone number must be in E.164 formatFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Numbers are missing the + and country code (0612345678 instead of +31612345678).
- Spaces, dashes, brackets or text like “mobile:” in the cell.
- Excel already changed the number (lost zero or E+ notation).
How to fix it
- 1Convert every number to E.164: +, country code, digits only.
- 2Review numbers that can't be converted instead of guessing a country.
Related guides
HubSpot
HubSpot import error: “Make sure each column with data has a header”
ShopifyShopify CSV import: “Illegal quoting on line …”
Google SheetsPhone numbers turn into dates or lose their leading zero in Sheets/Excel
Still stuck? Ask SheetFix Support