Excel to Constant Contact Mapping
Budget: $30 – $250 USD
I have an Excel file of seating assignments with multiple options for an upcoming event. Each registrant already lists names, ticket type, section, row and individual seat numbers. Some registrants purchased multiple seat types and their email should reflect all their assignments. What I need is a clean, import-ready file (CSV or XLSX) that lines up perfectly with Constant Contact’s standard and custom fields so I can launch a personalized email campaign without manual fixing on my end.
The task is straightforward: reorganize and relabel the existing columns, split or merge any compound fields where needed, and verify the final sheet will upload to Constant Contact without warnings. If look-ups or formulas are the quickest way to get there, feel free to use them; VBA or Power Query is also fine as long as the end file is tidy and non-volatile.
Deliverables:
• Reformatted file ready for Constant Contact import
• A brief note that shows which original columns map to which Constant Contact fields so I can reuse the template next time
Once the sheet passes a quick test upload, the job is done.
The task is straightforward: reorganize and relabel the existing columns, split or merge any compound fields where needed, and verify the final sheet will upload to Constant Contact without warnings. If look-ups or formulas are the quickest way to get there, feel free to use them; VBA or Power Query is also fine as long as the end file is tidy and non-volatile.
Deliverables:
• Reformatted file ready for Constant Contact import
• A brief note that shows which original columns map to which Constant Contact fields so I can reuse the template next time
Once the sheet passes a quick test upload, the job is done.