Import contacts
To import contacts into your Marketing section you have to prepare a .CSV document. To prepare a .CSV document one must open spreadsheet document (Example: Excel), where you type in all your contacts and their details. Each information about the contact must be written in its own column. Certain personalized information about your contacts will have to be added to your marketing section as new attributes and those have to be prepared in advance.
To prepare customer’s attributes, please read Attributes in Marketing section or see the tutorial.

WARNING:
Each contact in your .csv file should contain at least one unique identifier. Identifiers that are checked by the system are ID numbers, CODES, and EMAIL addresses.
- At the first import, the ID number will be given to each imported contact automatically. After that, you can use that same ID number for any updates.
- CODE can be given to contacts either manually or automatically.
- DEFAULT EMAIL address is the third and the most common identifier which is given to each contact manually.
After the import, you can see the ID number and code by clicking the View button in your contacts list.
Before the first import, we suggest you prepare a file with all the contact information. If you decide to prepare import files with codes and emails, make sure, each contact gets a unique and only one time used code. If you only decide to use emails, then all the codes and IDs will be given to contacts automatically.
Every import of new contacts will override already existing contacts if one of the three unique identifiers will match the already existing one. Example: If your contacts list already includes a contact with CODE number 101, and you prepare a new import file that also contains CODE number 101, then the latest import will override the already existing one. This way you can lose already existing contacts.
Our advice is to import contacts with Codes and emails and let the system give them automated ID numbers. Once the amount of contacts grows, you can always export them, arrange them by identifiers (either codes or IDs) and edit them or add new ones and then import them back.
IMPORTING CONTACTS WITH MULTIPLE CONTACT DETAILS
When importing contacts with multiple contact information of the same type (Example: contact with more than one email address), you must first import those contacts with only one contact information of the same type. After contacts are imported, you can manually add the other information of the same type.
If you wish to import more contact info with the importer, then you must identify the contact by the code and add the new contact info in the .csv file. The system will add the contact info to the existing one.
IMPORTING CONTACTS WITH ADDRESSES:
When it comes to importing contacts with addresses, make sure you put each info in a separated column and ALWAYS add all the required info: FIRST NAME, LAST NAME, EMAIL, STREET, STREET/HOUSE NUMBER, POSTAL CODE, CITY/TOWN, AND COUNTRY. Without all this information the import will fail.
To create an import document (CSV) with ease, we have prepared a table of content you can import when adding contacts to DG1 marketing to facilitate the process of importing contacts.
BASIC |
|
ID |
The ID number is a unique number of the contact. At the first import, the ID must NOT be written, but it must be added to your .csv when UPDATING the import. |
Code |
The code will be generated automatically. |
First name |
Use any letters. Example: John |
Middle name |
Not obligatory. Use any letters. Example: Paul |
Last name |
Use any letters. Example: Fitzgerald |
Full name |
Use any letters and put a space between the first, middle, and last name. Example: John Paul Fitzgerald |
Username |
It is created automatically. Or you write your own. Note that has to be one word only. |
Gender |
Write the gender with a word. Example: Male |
Date of birth
(YYYY-MM-DD)
Date of birth
(DD.MM.YYYY)
Date of birth
(MM/DD/YYYY) |
Write the date in one of the three date formats:
Example: 1981-06-22
Example: 22.06.1981
Example: 06/22/1981 |
CONTACTS |
|
Default E-mail * |
Obligatory
Write emails only in the email format. Example: john@mydomian.com |
Country calling code |
Do not use +. Only use the number of the country calling code. Example: 44 |
Telephone |
Numbers only. Example: 1 123456798 |
Mobile |
Numbers only. Example: 41 3562564 |
ADDRESSES |
Note! If you add the address of your contacts, you must add all the information marked with * but there are several options on how to add certain data. |
Use either!
Street with No. *
OR
Street *
Street No * |
Use only one option.
Add the street with number. Example: Kensington avenue 101
OR
Use letters only. Example: Kensington avenue
Use numbers or numbers and letters. Example: 303 |
Use either!
Town/City *
Postal code *
OR
Town with postal code *
OR
Postal code with town * |
Use only one option.
Write the name of the town or the city in a separate column. Example: London
Use capital letters and/or numbers only and write the postal code in the separate column. Example: W2 3XA
OR
Write the name of the town and the postal code all in one column. Example: London SW1A 2AA.
OR
Write the postal code followed by the name of the town or the city in one column. |
Country * |
You must write the name of the country according to the ISO standards. Click here to find the correct representation of the country.
Name |
ISO2 |
ISO3 |
Slovenia |
SI |
SVN |
Afghanistan |
AF |
AFG |
Åland Islands |
AX |
ALA |
Albania |
AL |
ALB |
Algeria |
DZ |
DZA |
American Samoa |
AS |
ASM |
Andorra |
AD |
AND |
Angola |
AO |
AGO |
Anguilla |
AI |
AIA |
Antarctica |
AQ |
ATA |
Antigua & Barbuda |
AG |
ATG |
Argentina |
AR |
ARG |
Armenia |
AM |
ARM |
Aruba |
AW |
ABW |
Australia |
AU |
AUS |
Austria |
AT |
AUT |
Azerbaijan |
AZ |
AZE |
Bahamas |
BS |
BHS |
Bahrain |
BH |
BHR |
Bangladesh |
BD |
BGD |
Barbados |
BB |
BRB |
Belarus |
BY |
BLR |
Belgium |
BE |
BEL |
Belize |
BZ |
BLZ |
Benin |
BJ |
BEN |
Bermuda |
BM |
BMU |
Bhutan |
BT |
BTN |
Bolivia |
BO |
BOL |
Caribbean Netherlands |
BQ |
BES |
Bosnia & Herzegovina |
BA |
BIH |
Botswana |
BW |
BWA |
Bouvet Island |
BV |
BVT |
Brazil |
BR |
BRA |
British Indian Ocean Territory |
IO |
IOT |
Brunei |
BN |
BRN |
Bulgaria |
BG |
BGR |
Burkina Faso |
BF |
BFA |
Burundi |
BI |
BDI |
Cape Verde |
CV |
CPV |
Cambodia |
KH |
KHM |
Cameroon |
CM |
CMR |
Canada |
CA |
CAN |
Cayman Islands |
KY |
CYM |
Central African Republic |
CF |
CAF |
Chad |
TD |
TCD |
Chile |
CL |
CHL |
China |
CN |
CHN |
Christmas Island |
CX |
CXR |
Cocos (Keeling) Islands |
CC |
CCK |
Colombia |
CO |
COL |
Comoros |
KM |
COM |
Congo - Kinshasa |
CD |
COD |
Congo - Brazzaville |
CG |
COG |
Cook Islands |
CK |
COK |
Costa Rica |
CR |
CRI |
Côte d’Ivoire |
CI |
CIV |
Croatia |
HR |
HRV |
Cuba |
CU |
CUB |
Curaçao |
CW |
CUW |
Cyprus |
CY |
CYP |
Czech Republic |
CZ |
CZE |
Denmark |
DK |
DNK |
Djibouti |
DJ |
DJI |
Dominica |
DM |
DMA |
Dominican Republic |
DO |
DOM |
Ecuador |
EC |
ECU |
Egypt |
EG |
EGY |
El Salvador |
SV |
SLV |
Equatorial Guinea |
GQ |
GNQ |
Eritrea |
ER |
ERI |
Estonia |
EE |
EST |
Ethiopia |
ET |
ETH |
Falkland Islands |
FK |
FLK |
Faroe Islands |
FO |
FRO |
Fiji |
FJ |
FJI |
Finland |
FI |
FIN |
France |
FR |
FRA |
French Guiana |
GF |
GUF |
French Polynesia |
PF |
PYF |
French Southern Territories |
TF |
ATF |
Gabon |
GA |
GAB |
Gambia |
GM |
GMB |
Georgia |
GE |
GEO |
Germany |
DE |
DEU |
Ghana |
GH |
GHA |
Gibraltar |
GI |
GIB |
Greece |
GR |
GRC |
Greenland |
GL |
GRL |
Grenada |
GD |
GRD |
Guadeloupe |
GP |
GLP |
Guam |
GU |
GUM |
Guatemala |
GT |
GTM |
Guernsey |
GG |
GGY |
Guinea |
GN |
GIN |
Guinea-Bissau |
GW |
GNB |
Guyana |
GY |
GUY |
Haiti |
HT |
HTI |
Heard & McDonald Islands |
HM |
HMD |
Vatican City |
VA |
VAT |
Honduras |
HN |
HND |
Hong Kong SAR China |
HK |
HKG |
Hungary |
HU |
HUN |
Iceland |
IS |
ISL |
India |
IN |
IND |
Indonesia |
ID |
IDN |
Iran |
IR |
IRN |
Iraq |
IQ |
IRQ |
Ireland |
IE |
IRL |
Isle of Man |
IM |
IMN |
Israel |
IL |
ISR |
Italy |
IT |
ITA |
Jamaica |
JM |
JAM |
Japan |
JP |
JPN |
Jersey |
JE |
JEY |
Jordan |
JO |
JOR |
Kazakhstan |
KZ |
KAZ |
Kenya |
KE |
KEN |
Kiribati |
KI |
KIR |
North Korea |
KP |
PRK |
South Korea |
KR |
KOR |
Kuwait |
KW |
KWT |
Kyrgyzstan |
KG |
KGZ |
Laos |
LA |
LAO |
Latvia |
LV |
LVA |
Lebanon |
LB |
LBN |
Lesotho |
LS |
LSO |
Liberia |
LR |
LBR |
Libya |
LY |
LBY |
Liechtenstein |
LI |
LIE |
Lithuania |
LT |
LTU |
Luxembourg |
LU |
LUX |
Macau SAR China |
MO |
MAC |
Macedonia |
MK |
MKD |
Madagascar |
MG |
MDG |
Malawi |
MW |
MWI |
Malaysia |
MY |
MYS |
Maldives |
MV |
MDV |
Mali |
ML |
MLI |
Malta |
MT |
MLT |
Marshall Islands |
MH |
MHL |
Martinique |
MQ |
MTQ |
Mauritania |
MR |
MRT |
Mauritius |
MU |
MUS |
Mayotte |
YT |
MYT |
Mexico |
MX |
MEX |
Micronesia |
FM |
FSM |
Moldova |
MD |
MDA |
Monaco |
MC |
MCO |
Mongolia |
MN |
MNG |
Montenegro |
ME |
MNE |
Montserrat |
MS |
MSR |
Morocco |
MA |
MAR |
Mozambique |
MZ |
MOZ |
Myanmar (Burma) |
MM |
MMR |
Namibia |
NA |
NAM |
Nauru |
NR |
NRU |
Nepal |
NP |
NPL |
Netherlands |
NL |
NLD |
New Caledonia |
NC |
NCL |
New Zealand |
NZ |
NZL |
Nicaragua |
NI |
NIC |
Niger |
NE |
NER |
Nigeria |
NG |
NGA |
Niue |
NU |
NIU |
Norfolk Island |
NF |
NFK |
Northern Mariana Islands |
MP |
MNP |
Norway |
NO |
NOR |
Oman |
OM |
OMN |
Pakistan |
PK |
PAK |
Palau |
PW |
PLW |
Palestinian Territories |
PS |
PSE |
Panama |
PA |
PAN |
Papua New Guinea |
PG |
PNG |
Paraguay |
PY |
PRY |
Peru |
PE |
PER |
Philippines |
PH |
PHL |
Pitcairn Islands |
PN |
PCN |
Poland |
PL |
POL |
Portugal |
PT |
PRT |
Puerto Rico |
PR |
PRI |
Qatar |
QA |
QAT |
Réunion |
RE |
REU |
Romania |
RO |
ROU |
Russia |
RU |
RUS |
Rwanda |
RW |
RWA |
St. Barthélemy |
BL |
BLM |
St. Helena |
SH |
SHN |
St. Kitts & Nevis |
KN |
KNA |
St. Lucia |
LC |
LCA |
St. Martin |
MF |
MAF |
St. Pierre & Miquelon |
PM |
SPM |
St. Vincent & Grenadines |
VC |
VCT |
Samoa |
WS |
WSM |
San Marino |
SM |
SMR |
São Tomé & Príncipe |
ST |
STP |
Saudi Arabia |
SA |
SAU |
Senegal |
SN |
SEN |
Serbia |
RS |
SRB |
Seychelles |
SC |
SYC |
Sierra Leone |
SL |
SLE |
Singapore |
SG |
SGP |
Saint Martin |
SX |
SXM |
Slovakia |
SK |
SVK |
Solomon Islands |
SB |
SLB |
Somalia |
SO |
SOM |
South Africa |
ZA |
ZAF |
South Georgia & South Sandwich Islands |
GS |
SGS |
South Sudan |
SS |
SSD |
Spain |
ES |
ESP |
Sri Lanka |
LK |
LKA |
Sudan |
SD |
SDN |
Suriname |
SR |
SUR |
Svalbard & Jan Mayen |
SJ |
SJM |
Swaziland |
SZ |
SWZ |
Sweden |
SE |
SWE |
Switzerland |
CH |
CHE |
Syria |
SY |
SYR |
Taiwan |
TW |
TWN |
Tajikistan |
TJ |
TJK |
Tanzania |
TZ |
TZA |
Thailand |
TH |
THA |
Timor-Leste |
TL |
TLS |
Togo |
TG |
TGO |
Tokelau |
TK |
TKL |
Tonga |
TO |
TON |
Trinidad & Tobago |
TT |
TTO |
Tunisia |
TN |
TUN |
Turkey |
TR |
TUR |
Turkmenistan |
TM |
TKM |
Turks & Caicos Islands |
TC |
TCA |
Tuvalu |
TV |
TUV |
Uganda |
UG |
UGA |
Ukraine |
UA |
UKR |
United Arab Emirates |
AE |
ARE |
United Kingdom |
GB |
GBR |
U.S. Outlying Islands |
UM |
UMI |
United States of America |
US |
USA |
Uruguay |
UY |
URY |
Uzbekistan |
UZ |
UZB |
Vanuatu |
VU |
VUT |
Venezuela |
VE |
VEN |
Vietnam |
VN |
VNM |
British Virgin Islands |
VG |
VGB |
U.S. Virgin Islands |
VI |
VIR |
Wallis & Futuna |
WF |
WLF |
Western Sahara |
EH |
ESH |
Yemen |
YE |
YEM |
Zambia |
ZM |
ZMB |
Zimbabwe |
ZW |
ZWE |
|
Country State * |
The state must be written according to ISO 3166-2 Code format or simply with a name.
Example for the United States
Name |
Code |
Alabama |
AL |
Alaska |
AK |
Arizona |
AZ |
Arkansas |
AR |
California |
CA |
Colorado |
CO |
Connecticut |
CT |
Delaware |
DE |
District of Columbia |
DC |
Florida |
FL |
Georgia |
GA |
Hawaii |
HI |
Idaho |
ID |
Illinois |
IL |
Indiana |
IN |
Iowa |
IA |
Kansas |
KS |
Kentucky |
KY |
Louisiana |
LA |
Maine |
ME |
Maryland |
MD |
Massachusetts |
MA |
Michigan |
MI |
Minnesota |
MN |
Mississippi |
MS |
Missouri |
MO |
Montana |
MT |
Nebraska |
NE |
Nevada |
NV |
New Hampshire |
NH |
New Jersey |
NJ |
New Mexico |
NM |
New York |
NY |
North Carolina |
NC |
North Dakota |
ND |
Ohio |
OH |
Oklahoma |
OK |
Oregon |
OR |
Pennsylvania |
PA |
Puerto Rico |
PR |
Rhode Island |
RI |
South Carolina |
SC |
South Dakota |
SD |
Tennessee |
TN |
Texas |
TX |
Utah |
UT |
Vermont |
VT |
Virginia |
VA |
Washington |
WA |
West Virginia |
WV |
Wisconsin |
WI |
Wyoming |
WY |
Example for Canada
Name |
Code |
Alberta |
AB |
British Columbia |
BC |
Labrador |
LB |
Manitoba |
MB |
New Brunswick |
NB |
Newfoundland |
NF |
Nova Scotia |
NS |
Nunavut |
NU |
North West Territory |
NT |
Ontario |
ON |
Prince Edward Islands |
PE |
Quebec |
QC |
Saskatchewen |
SK |
Yukon |
YT |
Example for Italy
Name |
Code |
Agrigento |
AG |
Alessandria |
AL |
Ancona |
AN |
Arezzo |
AR |
Ascoli Piceno |
AP |
Asti |
AT |
Avellino |
AV |
Bari |
BA |
Barletta-Andria-Trani |
BT |
Belluno |
BL |
Benevento |
BN |
Bergamo |
BG |
Biella |
BI |
Bologna |
BO |
Bolzano/Bozen |
BZ |
Brescia |
BS |
Brindisi |
BR |
Cagliari |
CA |
Caltanissetta |
CL |
Campobasso |
CB |
Carbonia-Iglesias |
CI |
Caserta |
CE |
Catania |
CT |
Catanzaro |
CZ |
Chieti |
CH |
Como |
CO |
Cosenza |
CS |
Cremona |
CR |
Crotone |
KR |
Cuneo |
CN |
Enna |
EN |
Fermo |
FM |
Ferrara |
FE |
Firenze |
FI |
Foggia |
FG |
Forlì-Cesena |
FC |
Frosinone |
FR |
Genova |
GE |
Gorizia |
GO |
Grosseto |
GR |
Imperia |
IM |
Isernia |
IS |
L'Aquila |
AQ |
La Spezia |
SP |
Latina |
LT |
Lecce |
LE |
Lecco |
LC |
Livorno |
LI |
Lodi |
LO |
Lucca |
LU |
Macerata |
MC |
Mantova |
MN |
Massa-Carrara |
MS |
Matera |
MT |
Medio Campidano |
VS |
Messina |
ME |
Milano |
MI |
Modena |
MO |
Monza e della Brianza |
MB |
Napoli |
NA |
Novara |
NO |
Nuoro |
NU |
Ogliastra |
OG |
Olbia-Tempio |
OT |
Oristano |
OR |
Padova |
PD |
Palermo |
PA |
Parma |
PR |
Pavia |
PV |
Perugia |
PG |
Pesaro e Urbino |
PU |
Pescara |
PE |
Piacenza |
PC |
Pisa |
PI |
Pistoia |
PT |
Pordenone |
PN |
Potenza |
PZ |
Prato |
PO |
Ragusa |
RG |
Ravenna |
RA |
Reggio di Calabria |
RC |
Reggio nell'Emilia |
RE |
Rieti |
RI |
Rimini |
RN |
Roma |
RM |
Rovigo |
RO |
Salerno |
SA |
Sassari |
SS |
Savona |
SV |
Siena |
SI |
Siracusa |
SR |
Sondrio |
SO |
Taranto |
TA |
Teramo |
TE |
Terni |
TR |
Torino |
TO |
Trapani |
TP |
Trento |
TN |
Treviso |
TV |
Trieste |
TS |
Udine |
UD |
Valle d'Aosta/Vallée d'Aoste |
AO |
Varese |
VA |
Venezia |
VE |
Verbano-Cusio-Ossola |
VB |
Vercelli |
VC |
Verona |
VR |
Vibo Valentia |
VV |
Vicenza |
VI |
Viterbo |
VT |
Example for Switzerland
Name |
Code |
Uri |
UR |
Svitto |
SZ |
Obvaldo |
OW |
Nidvaldo |
NW |
Lucerna |
LU |
Zurigo |
ZH |
Glarona |
GL |
Zugo |
ZG |
Berna |
BE |
Friburgo |
FR |
Soletta |
SO |
Basilea Città |
BS |
Basilea Campagna |
BL |
Sciaffusa |
SH |
Appenzello Esterno |
AR |
Appenzello Interno |
AI |
San Gallo |
SG |
Grigioni |
GR |
Argovia |
AR |
Turgovia |
TG |
Ticino |
TI |
Vaud |
VD |
Vallese |
VS |
Neuchâtel |
NE |
Ginevra |
GE |
Giura |
JU |
Example for Japan
Name |
Code |
北海道 |
1 |
青森県 |
2 |
岩手県 |
3 |
宮城県 |
4 |
秋田県 |
5 |
山形県 |
6 |
福島県 |
7 |
茨城県 |
8 |
栃木県 |
9 |
群馬県 |
10 |
埼玉県 |
11 |
千葉県 |
12 |
東京都 |
13 |
神奈川県 |
14 |
新潟県 |
15 |
富山県 |
16 |
石川県 |
17 |
福井県 |
18 |
山梨県 |
19 |
長野県 |
20 |
岐阜県 |
21 |
静岡県 |
22 |
愛知県 |
23 |
三重県 |
24 |
滋賀県 |
25 |
京都府 |
26 |
大阪府 |
27 |
兵庫県 |
28 |
奈良県 |
29 |
和歌山県 |
30 |
鳥取県 |
31 |
島根県 |
32 |
岡山県 |
33 |
広島県 |
34 |
山口県 |
35 |
徳島県 |
36 |
香川県 |
37 |
愛媛県 |
38 |
高知県 |
39 |
福岡県 |
40 |
佐賀県 |
41 |
長崎県 |
42 |
熊本県 |
43 |
大分県 |
44 |
宮崎県 |
45 |
鹿児島県 |
46 |
沖縄県 |
47 |
|
NOTIFICATIONS |
|
Global - All channels |
1 - checked (YES), 0 - unchecked (NO) |
Global - Email |
1 - checked (YES), 0 - unchecked (NO) |
Global - SMS |
1 - checked (YES), 0 - unchecked (NO) |
Warning! Site languages affect only mailing lists and no other functionality. The rest of the marketing works globally and for all sites and site languages. You don’t need to select a specific language for no functionality other than mailing lists.