# 6. Note when uploading contacts via excel file

## Notes when uploading contacts via excel file:

* **Format:** All fields need to be converted to text
* **Number:** Numbers should contain a country code with conditions of no spaces, no periods,... between digits. For example, number 0987654321 needs to be converted to 84987654321 with the country code of Vietnam (84). Here is a formula to reformat numbers without beginning 84, numbers with spaces in between, numbers with leading 0, numbers with a forbidden sign separating digits can refer to the formula below. G2 is the data cell to be reformatted.

```excel-formula
=IF(LEFT(SUBSTITUTE(SUBSTITUTE(G2,".",""), " ", ""),2)="84",SUBSTITUTE(SUBSTITUTE(G2,".",""), " ", ""),IF(LEFT(SUBSTITUTE(SUBSTITUTE(G2,".",""), " ", ""),1)="0", "84"&RIGHT(SUBSTITUTE(SUBSTITUTE(G2,".",""), " ", ""),9), "84"&SUBSTITUTE(SUBSTITUTE(G2,".",""), " ", "")))
```

* **Choose the type of contact check when uploading:** learn more at [here](/stringeex-tong-dai-cham-soc-and-quan-ly-khach-hang/en/ii.-system-features/3.-contact/3.1.-contact-management.md#cach-upload-lien-he-excel)
* **Account manager:** This information field is the email of the agent corresponding account manager, not the agent name or agent extension number.
* **Required fields:** Before uploading the contact to the system, the user needs to make sure [the required fields](/stringeex-tong-dai-cham-soc-and-quan-ly-khach-hang/en/ii.-system-features/9.-settings/9.3-field-configuration/9.3.1-contact-field.md#1-danh-sach-cac-truong-cua-lien-he) (including system fields and fields are set to require in the contact field configuration). Note that the name field in the downloaded excel template is "Name\*" ("Name" and has an asterisk "\*"). Users must not delete this asterisk.
* **Error:** When uploading contacts, the system will send an email notification. This message includes upload result, number of successful contacts, number of failed upload contacts. In this email attachment, users can check the error case through the last error code column (this column will have error information when a contact has an error)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.stringeex.com/stringeex-tong-dai-cham-soc-and-quan-ly-khach-hang/en/iv.-frequently-asked-questions/6.-note-when-uploading-contacts-via-excel-file.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.