# Uploading Customers and Gift Certificates in Batch

Here's how to use the Customer Upload Tool:

### Step 1:

#### File Format <a href="#h_a158b4d2be" id="h_a158b4d2be"></a>

First, you have to prepare a CSV file of your customers. This can be done through Microsoft Excel or any spreadsheet program. The required column headers are first\_name, last\_name, name and email. You can [download this sample file](https://drive.google.com/file/d/1PbWZaunY6x8T-g2ssGSMpXf4OUodaWYd/view?usp=sharing).

You can also add other columns to the CSV file if you want to add more information. Here are the other column headers that you can use:

* mobile - Mobile number (numbers only, no spaces or punctuation marks allowed)b
* fax - Fax number (numbers only, no spaces or punctuation marks allowed)
* telephone - Telephone number (numbers only, no spaces or punctuation marks allowed)
* company\_name - Company name
* street - Street address
* zipcode - Zip code
* country - Please use two-letter country shortcodes
* state - U.S. only. Please use two-letter shortcodes.
* birthday - Please use this format: YYYY-MM-DD

Do note that the headers are case-sensitive.

***

### Step 2:

#### Upload File <a href="#h_9d57bbbd34" id="h_9d57bbbd34"></a>

Once you have saved the spreadsheet in CSV format, you can already upload it.

Go to the Data Manager

### Step 3:

Select Customers from the Data to Upload dropdown

### Step 4:

Choose your file then Imonggo will display the products

### Step 5:

Click the Upload button

<figure><img src="https://downloads.intercomcdn.com/i/o/453093934/32b380a1753de37554ff3c80/Data+Manager+2.png" alt=""><figcaption></figcaption></figure>

Once the file is successfully uploaded, you should be able to find your uploaded customers in the Customers page.


---

# 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://imonggo.gitbook.io/imonggo-help-center/advanced-topics/uploading-customers-and-gift-certificates-in-batch.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.