# 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.