I have a raw CSV full of customer information that Xero refuses to accept in its current shape. I need the file transformed so it fits Xero’s Contact-import template perfectly. Scope • Parse the source CSV and map every record to the following Xero Contact columns: Name, Email, Phone Number, Address, City, and Postal Code. • Preserve all existing data exactly; no truncation, no re-formatting that alters meaning. • Deliver a clean, Xero-ready CSV that passes Xero’s validation without manual tweaks. Preferred workflow Excel, Google Sheets, Power Query, or a quick Python script—use whichever tool gets us to a compliant file fastest, provided the final output is a standard CSV. Acceptance criteria 1. I can drag-and-drop the delivered file into Xero and see each customer appear under Contacts with the correct fields populated. 2. Record count in the finished file matches the original. 3. Phone numbers and postcodes retain their leading zeros (where applicable) and stay in plain-text format. Please let me know if you need a sample of the existing CSV or Xero’s template before starting; I can supply both immediately.