1and1 Help Centre Categories

print article

What is the correct CSV syntax and format for importing customer data?

The CSV file has to be in the following format and have .csv extension:

Variable Variable name
Group name group_name
Group Description group_caption
Discount discount
The exact syntax has to be followed:

"group_fieldlist: group_name";"group_caption";"discount"
"group: group1";"1st group";"2"
"group: group2";"2nd group";"4"

The data fields for the groups is set with the key word group_fieldlistThe individual group records follow it with the key word groupMake sure there are no hard carriage returns. The above example will create 2
groups with discounts.

Variable variable name
Customer number customer_number
Groups groups
Title title
First name first_name
Last name surname
Company company
Address 1 street
Address 2 street2
City city
Post Code postcode
Country country
Telephone telephone_no
Fax fax_no
E-mail email
Shipping title shipping_title
Shipping first name shipping_first_name
Shipping last name shipping_surname
Shipping address1 shipping_street
Shipping address2 shipping_street2
Shipping company shipping_company
Shipping city shipping_city
Shipping Post Code shipping_postcode
Shipping country shipping_country
Shipping telephone shipping_telephone_no
Shipping fax shipping_fax_no
Shipping email shipping_email
Use Shipping Address use_shipping_address
Send no mailings no_mailings
Inactive inactive
Password password
Comments comments
The "inactive" variable decides whether the customer can order products or not. "1"
means the customer cannot actively order in the shop. "0" or "" means the customer
can order. By default it is "0".

The "no_mailings" variable decides whether the customer receives newsletter or not.
"1" means no newsletters and "0" or "" means the customer receives newsletters. By
default it is set to "0"
The exact syntax has to be followed:

"customer_fieldlist: customer_number";"groups";"title";"first_name";"surname";
"company";"street";"street2";"city";"postcode";"country";"telephone_no";
"fax_no";"email";"inactive";"no_mailings";"password";"comments"

"12345";"group2|group1";"Mr";"James";"Brandon";
"ABC Company";"111 Street";"";"Berwyn";"12345";"UK";"1234567899";
"1234567899";"info@1and1faq.co.uk";"0";"password";"my comments"
The data fields for the customer is set with the key word customer_fieldlistMake sure there are no hard carriage returns.