Can I download a sample Excel or CSV file for audience creation?

Can I download a sample Excel or CSV file for audience creation?

To avoid formatting errors, MyOperator provides a sample file you can download during campaign setup. This file ensures your audience data is structured correctly before upload.

đź”˝ How to Download the Sample File

  1. Go to the Campaign Creation page.
  2. In the Audience / Upload Contacts section, click “Download Sample File” or “Download Template.”
  3. A pre-formatted .xlsx or .csv file will be downloaded to your system.

📊 What’s Inside the Sample File

Column Header

Description

Example

name

Recipient’s full name (optional but recommended)

John Doe

phone_number

WhatsApp number in international format (mandatory)

+91 9876543210

amount (optional)

Variable value (e.g., payment, invoice)

1,500

date (optional)

Delivery or event date

25 July 2025

đź“Ś The optional columns (like amount and date) align with template variables (, , etc.) for personalization.

âś… Best Practices

  • Always use the exact column headers provided in the sample file.
  • Save your file as .csv or .xlsx before uploading.
  • Ensure all required fields (especially phone_number) are filled correctly.
  • Match optional columns to template variables for smooth personalization.

⚠️ Common Issues to Avoid

Mistake

Problem Caused

Renaming or deleting mandatory columns

Upload fails

Adding extra characters in numbers (spaces, dashes, symbols)

Numbers rejected

Leaving blank rows

Validation errors

Mixing formats (e.g., local 10-digit numbers instead of +91XXXXXXXXXX)

Campaign blocked

âś… Summary

  • The sample file acts as your blueprint for campaign uploads.
  • phone_number is mandatory; other fields are optional but improve personalization.
  • Stick to provided headers and formats to avoid errors during campaign validation.