Upload File Guidelines

File Guidelines
 

Your file must be prepared according to these guidelines:

  • Required – must be provided for each contact 
  • Recommended – complete address details are required during shipping process
  • Optional – fields can be left blank, but will help you save time when creating a shipment
  • Fields must be in the exact order as in the table below

Save the spreadsheet as a CSV (Comma delimited), TXT or XML file.

Field Order 항목 Required Optional Maximum Characters  형식 Description and Tips
1 이름 필수정보 35 Alpha/Numeric/Symbols First and last name
(do not use separators between names)
John Smith
2 회사 필수정보 88 Alpha/Numeric/Symbols Company name
(if no Company name, enter the contact's first and last name again)
DHL Express
3 저장명(닉네임) 선택사항 135 Alpha/Numeric Your unique name which can help you differentiate between duplicate names and multiple locations in your Address Book John at DHL
4 이메일주소 1 필수정보 45 Alpha/Numeric/Symbols Format: name@email.com jsmith@
companymail.com
5 이메일주소 2 선택사항 45 Alpha/Numeric/Symbols Format: name@email.com jsmith@
personalmail.com
6 이메일주소 3 선택사항 45 Alpha/Numeric/Symbols Format: name@email.com assistant@
companymail.com
7 이메일주소 4 선택사항 45 Alpha/Numeric/Symbols Format: name@email.com warehouse@
othercompany.com
8 이메일주소 5 선택사항 45 Alpha/Numeric/Symbols Format: name@email.com  
9 연락처 유형 필수정보 1 Alpha

M - Mobile, H - Home, 

O - Office

 
M
10 전화번호 국가코드 필수정보 6 Numeric Country calling code
(exclude any leading zero)
44
11 전화번호 필수정보 70 Numeric Numbers only, no spaces or punctuation
(exclude any leading zero)
5553239000
12 내선 선택사항 5 Numeric Numbers only, no spaces or punctuation 37
13 팩스 선택사항 70 Numeric Numbers only, no spaces or punctuation
(exclude any leading zero)
2088188888
14 VAT/Tax ID 선택사항 35 Alpha/Numeric Country identifier used for tax purposes VAT123
15 저장명(닉네임) 2 선택사항 135 Alpha/Numeric Additional unique identifier to help you differentiate between duplicate names and multiple locations John Account Manager
16 EORI 번호 선택사항 35 Alpha/Numeric Tax identification number EORI123
17 CNPJ/CPF 세금 유형 선택사항 35 Alpha Tax identification type  
18 CNPF/CPF Tax ID 선택사항 35 Alpha/Numeric Tax identification number  
19 IE/RG 선택사항 35 Alpha/Numeric Tax identification number  
20 국가 선택사항 45 Alpha Country name United Kingdom
21 국가코드 필수정보 2 Alpha Two letter ISO country code GB
22 주소 1 필수정보 45 Alpha/Numeric Address Line 1 3333 N Main St
23 주소 2 선택사항 45 Alpha/Numeric Address Line 2 101
24 주소 3 선택사항 45 Alpha/Numeric Address Line 3  
25 우편번호와 도시

Recommended

35 Alpha/Numeric If the country has postcodes, then this information must be provided   TW4 6JS
26 도시 필수정보 45 Alpha/Numeric City name Hounslow
27 외곽지역

Recommended

45 Alpha If the country requires suburbs, then this information must be provided England
28 주(State)/도(Province) 선택사항 35 Alpha If the country requires state name, then please provide this information  
29 State/Province Code

Recommended

2 Alpha/Numeric If the country requires state code, then this information must be provided: example California CA
30 고객번호 – for Shipments 선택사항 9 Alpha/Numeric Account that should be charged by default 123456789
31 고객번호 – 요금 청구 고객번호 선택사항 9 Alpha/Numeric Account that should be charged by default 123456789
32 고객번호 – 관부가세 청구 고객번호 선택사항 9 Alpha/Numeric Account that should be charged by default 123456789
33 고객번호 – 청구 선택사항 9 Alpha/Numeric Account that should be charged by default 123456789
34 고객번호 – 세금 청구 선택사항 9 Alpha/Numeric Account that should be charged by default 123456789
35 Customs Terms of Trade 선택사항 3 Alpha Also known as Incoterms DAP
36 비고 추가 선택사항 255 Alpha/Numeric Add notes about this contact – such as unique shipping needs and preferences (only visible to you in MyDHL+) This account is for samples only. All orders must be shipped on a different account.
37 참조사항 1 선택사항 35 Alpha/Numeric/Symbols Reference to be printed on the shipping label and billing invoice Sample Only - Not for Use
38 참조사항 2 선택사항 35 Alpha/Numeric/Symbols Additional reference (does not appear on shipment documents); Only visible to you when you view details of a shipment in MyDHL+ Fabric #49  
39 참조사항 3 선택사항 35 Alpha/Numeric/Symbols Additional reference (does not appear on shipment documents); Only visible to you when you view details of a shipment in MyDHL+ End of Day Delivery Only
40 참조사항 4 선택사항 35 Alpha/Numeric/Symbols Additional reference (does not appear on shipment documents); Only visible to you when you view details of a shipment in MyDHL+