Import contacts from a spreadsheet (CSV)
Bring in customers from Shopify, Excel, Google Sheets, Mailchimp or Klaviyo with a CSV file, keeping who agreed to marketing.
Updated
People already in Rebeckon are updated, not duplicated, and empty cells never erase what's already there.
Import your file
- Save your spreadsheet as a CSV file (up to 15 MB).
- Go to Audience → Contacts and press Import contacts.
- Choose your CSV file, or drop it on the page.
- Under Match your columns, check what each column is imported as. Choose Custom property to keep extra details, or Don't import to leave a column out.
- Under Email consent, choose what happens for rows that don't say. Not sure? Keep Don't change consent.
- If you like, add everyone to a list. Then press Start import.
Who can get marketing email
Only people who agreed get marketing email. If your file has a consent column, such as Shopify's Accepts Email Marketing, Rebeckon reads it for each person.
People without consent come in as not subscribed. They won't get campaigns until they sign up through one of your forms.
Note: Only choose They agreed to receive marketing email if everyone in the file gave you permission: you'll tick a box to confirm you have proof, and Rebeckon records that you did. A “no” in a consent column means they never subscribed, not that they opted out. Someone who unsubscribed always stays unsubscribed.
Birthdays
A column called Birthday, Date of birth or DOB is kept as each person's birthday, the same as your sign-up forms save it. Write it as month and day, like 04-23, or as a full date, like 1990-04-23.
Exporting from Shopify
In your Shopify admin, open Customers → Export and pick CSV. The file already has the Accepts Email Marketing column.