# CSV Formatting

When running a Zigpoll email campaign, you can upload a CSV file with additional metadata for each recipient. This enriches your survey responses with extra context beyond just the email address.

#### Creating Your CSV File

1. Create a CSV file using the tool of your choice (Excel, Google Sheets, etc.).
2. Create a column called **email**. Enter the email addresses you want to contact.
3. Add additional columns for each variable you want to include.

#### Special Variables

The following column names are treated as special values internally:

| Column Name           | Purpose                                          |
| --------------------- | ------------------------------------------------ |
| `email`               | **Required.** The recipient's email address      |
| `shopify_customer_id` | Links the response to a Shopify customer profile |
| `shopify_order_id`    | Links the response to a specific Shopify order   |

You can also add any custom column names to pass through additional metadata.

#### Example CSV

```
email,shopify_customer_id,shopify_order_id
customer1@example.com,12345,67890
customer2@example.com,12346,67891
```

{% hint style="info" %}
We recommend starting small when running a campaign using a CSV file so that you can test everything out before reaching your larger audience.
{% endhint %}

#### Uploading Your CSV

1. Go to **Surveys → Select your survey**.
2. Click **Campaigns → Emails**.
3. Choose to upload a CSV file instead of entering emails manually.
4. Upload your formatted CSV and click **Send Email**.