Importing locations with CSV

Learn how to add many locations to Klaviyo at once by importing a CSV file. Klaviyo creates the locations, their proximity segments, and the location profile property as part of the import.

Before you begin

• Owner, Admin, and Manager have write access.
• Your file must be a .csv, 50 MB or smaller, with up to 500 locations.
• Each location needs a name and an address.

If you are adding only a few locations, you may find it faster to add them manually. See Getting started with Locations.

Download the CSV template

Klaviyo provides a template so your columns match what the importer expects.

1. Navigate to Audience > Locations.
2. Click Create a location.
3. Select Upload a CSV file, then click Next.
4. Click Download a CSV template, select the columns to include, then click Download.

Always included: Name, Country, Address, City, Postal Code

Optional: State/Province, Description, Website URL, Phone number, Location email, Manager name and email

Add your locations to the template, one per row.

Import your file

1. From Audience > Locations, click Create a location, then select Upload a CSV file.
2. Drag your file into the upload area, or click Upload.
3. Work through the import steps below.

Map fields

Klaviyo matches your CSV columns to location properties and shows sample data from your file so you can check each one. Required properties are listed first: Name, Country, Address, City, and Postal code. Use the dropdown next to any property to change which column it reads from, and clear the Import checkbox to leave a property out.

Set location type

Choose 1 location type to apply to every location in the import: Distributor, Gym, Hotel, Restaurant, Retail store, or Spa. If none apply, click Create type and enter your own.

Create segments

Set the default conditions Klaviyo uses when it creates a proximity segment for each location: Distance from location, which defaults to 30 miles, and Marketing channels, which sets the channels a profile must be subscribed to. These conditions apply to every location in the import. You can change them later by editing each segment's definition.

Create a profile property

Klaviyo creates the location profile property for you. The property name is store_region and the value is each location's name. If your account already uses a location profile property, it cannot be changed during the import. You can change it afterward in each location's settings.

Import

Click Import to start. Klaviyo shows progress as it works through your file. You can leave the import running. Click Leave import to return to Locations, then track progress in Import history. You cannot return to this screen once you leave it.

Track your import

Click Import history from the All locations tab to see imports from the last 7 days, with their status and how many locations have been processed. Import history covers both CSV imports and Shopify syncs. Shopify entries are marked with a Shopify icon.

Each import shows how many locations were imported and how many were skipped. An import that brings in some locations shows as Completed with a skipped count. An import where nothing could be imported shows as Failed.

If any rows were skipped, click Download CSV to get a file of just those rows with the reason each one was skipped. Fix the issues in that file and upload it again.

Troubleshooting

A location was skipped because its postal code does not match its country.

Check how your spreadsheet saved the postal code. Spreadsheet apps often drop a leading zero from codes like 02111, treating them as numbers. Format that column as text before you export.

Your locations are different types.

A single import applies one type to every row. Run a separate import for each type, or change the type afterward in each location's settings.

Best practices

• Import one location type at a time. A single import applies one type to every row.
• Start with a small file. Import a few locations first and check the result before importing the rest.
• Review your segments after importing. The distance and channel conditions apply to every location in the import, and a 30 mile radius may not suit a dense city and a rural location equally.

Outcome

Your locations are in Klaviyo, each with a proximity segment and the location profile property. You can open any location to see its audience and start sending.

Additional resources