Before you import, you will need to review the format of each column in your file. During the import process, you get to map the column in your file with the custom field in your Enginemailer account. Some custom fields like Phone and Address require specific format to import.
- The email address is a required field, without the email address, you will be prompt to restart your import process.
- You can insert any custom field in any order.
- The comma (,) that exist in the field will cause import error, so it is recommended to import tab-delimited file (.txt)
Email Address (Required)
You must include one column for email address in your CSV file. Invalid email address will be highlighted on the Step 4 of the import process.
Max length for email address - 128
Optional: Custom Fields
We recommend using Longtext if your field requires larger amount of input. You can use Text fields for names, company name, job title and etc..
Max length for text - 256
Unlike Text, Longtext supports more characters and you will get multiline handling. Use Longtext fields for comments, description and etc..
Max length for longtext - 512
Dropdown & Checkbox
* Enginemailer does not support importing Dropdown and Checkbox input fields via CSV.
Use Numerical input field to store numbers or currency values. You can use Numerical fields for NRIC, price and etc..
Max length for numerical - 16
To import dates, use the formats below:
// etc. 10/28/2018
// For daterange. etc. 08/06/2017 - 10/24/2018
MM/DD/YYYY - MM/DD/YYYY
In this example, MM is month, DD is day and YYYY is a four-digit year.
|MM||Two digit month||"01" to "12"|
|DD||The day of the month between 1 and 31||"01" to "31"|
|YYYY||Full four digit year||"2001" to "2020"|
Max length for date - 32
The format for Phone fields, as below:
Phone numbers are formatted by prefixing the country code with plus (+) sign. Avoid spaces, dashes and dots between the field.
Max length for phone - 16
The mailing address should only appear in one cell and must include the full country name. If the address in your file is stored in multiple columns, you'll need to combine your address field first.
To format the Address fields, separate each line of the address with two space. As below:
// For Full Address
Level 11, Wisma Prosper, Block B, Kelana Centre Point, No. 3, Petaling Jaya Selangor 47301 Malaysia
// To skip Address Line 2
Level 11, Wisma Prosper, Block B, Petaling Jaya Selangor 47301 Malaysia
The sequence of the address is "Address Line 1", "Address Line 2", "City", "State", "Postcode" and "Country". Leave empty if that line of input is empty.
Max length for address - 256
Download sample file
Download our sample CSV file as starting point if you are unsure how to start. The sample file contains basic columns - Email, First Name and Last Name. After you download the sample CSV file, replace the data with your subscriber data.
When your file is ready, learn how to import it to Enginemailer.