Import Square Customers to Xero Contacts — Sync Your Customer Directory

🥦

Import Complete

Xero Contact Format Format
valid rows

Convert your Square customer directory to Xero contact format. Transfer names, emails, phone numbers, and addresses seamlessly.

No API required
Browser-based processing
Run on Google Cloud Platform

Download Sample

Sample customer directory CSV

Download

Tool Rating

4.5 / 5 (62 votes)

How It Works

1

Export

Square Dashboard → Customers → Export

2

Upload

Upload customer directory CSV

3

Preview

Review converted contact list

4

Import

Import contacts to Xero

Your Data is Safe

Bank-Level Security

256-bit SSL encryption. Same standards as major financial institutions.

No Data Storage

Files are processed directly in browser. No calls to our servers.

GDPR Compliant

Full EU data protection compliance. Your privacy rights protected.

ISO/IEC 27001 Certified GDPR Compliant Swiss Privacy CCPA Compliant

Field Mapping

How Square Customers fields map to Xero Contact

Square Customers Source Value Xero Contact Target Value Note
Email Address john.smith@example.com → EmailAddress john.smith@example.com Customer email
Given Name John → FirstName John First name
Family Name Smith → LastName Smith Last name
Address Line 1 123 Main Street → POAddressLine1 123 Main Street Street address
City New York → POCity New York City
Administrative District NY → PORegion NY State/Province
Postal Code 10001 → POPostalCode 10001 ZIP/Postal code
Country US → POCountry US Country
Phone Number +1-555-123-4567 → PhoneNumber +1-555-123-4567 Phone

Building Your Customer Database in Xero

Customer Data Sync

Your Square customer directory contains valuable contact information built up over time. When using Xero, you want these contacts available for invoicing, tracking, and customer relationship management.

Clean Data Transfer

This tool converts Square's customer export to Xero's contact import format, mapping fields correctly and handling duplicates. Names, emails, phones, and addresses transfer cleanly.

Common Contact Import Errors

Issues you might encounter when importing Customers Export data to Contact - and how we solve them

Duplicate Contact Name

Xero requires unique contact names

John Smith (appears twice)
John Smith, John Smith (2)

We auto-suffix duplicates with numbers

Review and merge contacts in Xero after import

Missing Contact Name

Contact has no name, company name, or email

(all name fields blank)
Customer_CUST123 (from Customer ID)

We generate names from Customer ID if needed

Update contact details in Xero

Name Exceeds 255 Characters

Xero contact names have 255 character limit

Very Long Company Name Inc...
Very Long Company Name Inc... (truncated)

Names are automatically truncated

Edit contact names in Xero if needed

Why Use This Tool?

Full Contact Details

Names, emails, phone numbers, and addresses converted.

Duplicate Detection

Optionally skip duplicate email addresses.

Name Handling

Combine given/family names or keep separate.

Notes Transfer

Customer notes preserved in Xero.

Address Mapping

Full address fields mapped to Xero format.

Browser Privacy

Customer data processed locally.

Frequently Asked Questions

In Square Dashboard, go to Customers → Customer Directory → click the export icon to download your customer list as CSV.
Enable 'Skip Duplicate Emails' to avoid creating duplicate contacts in Xero. The tool uses email address as the unique identifier.
No, Xero's import creates new contacts. If a contact with the same email exists, Xero may flag it as a duplicate during import.
Name, email, phone number, and address fields are converted. Square-specific fields like loyalty points are not transferred.

Square → Xero Data Ecosystem

All available data flows from Square to Xero

Square Customers Export Customer directory with contact info, addresses, and purchase history
→
Xero Contact Customer or supplier contact records
Given Name + Family Name → Name Email Address → EmailAddress Given Name → FirstName
Customer sync, supplier management
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Xero Bank Statement Bank transactions for reconciliation
Date → Date Total Collected → Amount Fees → Amount
Payout reconciliation, fee tracking
Square Transactions Export Payment transactions with fees, tips, taxes, and settlement data
→
Xero Sales Invoice Sales invoices for accounts receivable (B2B, payment terms)
Transaction ID → InvoiceNumber Date → InvoiceDate Date + terms → DueDate
B2B sales, invoiced orders, payment terms