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


---

# 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://docs.zigpoll.com/tutorials/csv-formatting.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.