Cerkl makes it easy to upload lots of subscribers all at once. But there are some guidelines to make sure Cerkl can put all of the data into the correct fields.
- Upload your list as a comma-separated value (.CSV) file
- Email is required and should always be in column 1 of the spreadsheet
- Name is not a required field
- If you include names, place them in column 2 of the spreadsheet
- If a name is not provided, Cerkl will use everything before the @ of the email for that subscriber's name
This same process is how you can attach a segment to a large list of users that already exist. This article covers some of the common ways to manipulate your subscriber's lists in Excel.
First and Last name are in two different columns, need to be combined into one:
A person's name is the most beautiful word in the world. To that person. Cerkl makes sure to capitalize on this by personalizing the email not just to the subscriber's email address, but to their name (i.e. - 'This edition personalized just for Rachel.')
For these reasons it is important that the first and last name not be confused. Cerkl asks for the CSV file to have the first and last name in the same column, first name first, last name last. If you have first name, last name, and email address in individual columns here is how you combine those columns into one.
Once the new column is created, it is being constructed through the use of a formula. So if you delete one of the columns it is pulling information from then the new column will be effected. And if you copy and paste the new column into a new spreadsheet it will not have the original columns to refer to for the formula.
In order to copy and paste your new first/last name column into a new table, you will need to select the Paste drop-down arrow in the top left corner of Excel and click Paste Values. This will paste the values of the cells totally separate from the formula you created to get the values. Do the same thing for the email column and now you have a beautiful new subscriber list that is in the perfect format!
Easier than you thought, right? If you have any questions at all, don't hesitate to reach out to us at firstname.lastname@example.org! Or use the help bot in the bottom right-hand corner of any cerkl.com page for a quick answer.