Import a CSV into a WhatsApp Web Queue

Exporting customer lists from CRMs like HubSpot, Salesforce, Zoho, or Shopify as a .csv file is the standard starting point for marketing and operational outreach. WaSenderHQ transforms static CSV files into dynamic, personalized WhatsApp Web broadcast queues in seconds.

How to Format and Import a CSV into WhatsApp Web

Step 1: Prepare Your Spreadsheet Headers

Ensure the first row of your spreadsheet contains distinct headers. Common columns include:

• Phone: Complete international phone number with country code.
• Name: Recipient's first or full name for template greeting replacement.
• Custom Fields: Variables such as Company, AmountDue, InvoiceLink, or TicketNumber.

Step 2: Save as CSV with UTF-8 Encoding

When saving from Microsoft Excel, choose CSV UTF-8 (Comma delimited) (.csv). UTF-8 encoding guarantees that accented names, non-Latin scripts (Arabic, Cyrillic, Devanagari), and emojis remain intact.

Step 3: Upload and Map Placeholders

Drag and drop your CSV file into the WaSenderHQ sidebar. The extension parses headers instantly. Map your phone column, insert placeholders into your message draft, and inspect real-time row previews.

Step 4: Launch and Export Campaign Logs

Start the campaign with measured delays. Upon completion, download a detailed activity log showing delivered, failed, and skipped rows for complete CRM record keeping.

Common CSV Formatting Mistakes to Avoid

• Excel Scientific Notation: Large numbers like 919876543210 can turn into 9.19876E+11. Format the column as Text before exporting.
• Missing Country Codes: Local numbers (e.g. 98765-4321) will fail delivery without the country calling prefix.
• Merged Cells: Ensure your table is a flat rectangular grid with one record per row.