Creating a CSV file
Many applications in which you have contacts stored can easily save the data out to a CSV format. The resulting file will contain your data in the order determined by the application, separated by commas (comma separated values = CSV).
The easiest way to edit or create a CSV file is using Excel. When saving your CSV file from Excel, choose File, Save AS and select the .CSV format (towards the bottom of the available formats list). If using Excel, only the data on the first worksheet will be saved to your CSV file, so don’t set your data out on many worksheets.
Preparing your CSV file for import into eNudge
There are just a few things you need to be careful of to ensure that your data ends up in the right place when you do your upload:
Because a CSV file is a format that separates each item using a comma, you can’t have commas inside a value (or a cell, if you are using Excel to create your CSV file). For example, if the street value is “Level 1, 105 Walker Street” then you need to remove the comma otherwise when you upload, “Level 1” will be treated and the street, and “105 Walker Street” will be treated as the next field value, and so on… shifting each field along one which will create havoc in your upload. It may even cause it to fail if the email address or mobile phone number are moved along to a different field, because eNudge checks the format of these two fields before creating your contact.
Dealing with apostrophes
Apostrophes are treated differently in databases, so in order to successfully include an apostrophe in your data, you need to “escape out” the apostrophe.In non-technical terms this means putting a \ (slash) character in front of the apostrophe which forces the database to treat it as an ordinary character rather than a field delimiter.For example, if a surname in your CSV file is “O’Connor” you need to change this to “O\’Connor” for it to upload successfully.
Remove any empty columns
Do not leave any empty columns in your CSV file; remove the whole column instead.
Remove any carriage returns / line feeds / new line breaks
A new line break left inside a value in your CSV file will cause the information after the line break to be treated as the new contact record, and likely produce errors in the contact creation.
Remove any empty rows
Empty rows will produce errors when you upload your contacts.
Remove the heading row
As a final step, delete your heading row so that eNudge doesn't try and process it as a contact.
Add a Category to your Contacts
Adding one or more categories to your contacts as you upload them makes it super quick to attach your contacts to a particular campaign later. To add a category, simply put the name of the category in a separate column for each contact. You can add up to 5 categories during an upload, and eNudge will create the category as you upload, if it doesn't already exist.
Uploading your Contacts CSV File
Once you have prepared your CSV file and are ready to upload your contacts, choose Contacts from the main navigation, then choose Upload Contacts, and browse to find your file. Once your CSV file is uploaded, the next step is to re-arrange the field names to match your file, and then process.
For more information, read the article re: Uploading your Contacts via a CSV file.