Square Customers to Xero Contacts — Customer Directory Sync

🥦

Convert Complete

Xero Contact CSV Format
valid rows

Sync your Square customer database to Xero. Import customer names, addresses, emails, and phone numbers for complete contact management.

Free preview — then from $5. Save with bundles.
Free preview before you pay
Files never leave your browser
No account needed to start

Sample Customers

Example Square customers export

Download

Tool Rating

4.4 / 5 (95 votes)

How to Convert Your File

1

Export from Square

Customers → Import / Export → Export Customers → Download

2

Upload and Configure

Upload Customers Export CSV and choose Contact format

3

Preview and Download

Review converted data, download Xero-ready file

4

Import to Xero

Contacts → All Contacts → Import → Upload CSV

Output is in Xero Contact CSV format — ready to import directly, no manual reformatting needed.

How People Use This

We built up a large customer directory in Square over two years but needed all those contacts in Xero for invoicing. The converter mapped company names, emails, and phone numbers into Xero's contact format. The duplicate detection caught 40+ repeated names and added suffixes so Xero accepted the entire import without rejections.

Hannah Q.
Office Manager, Wellness Studio · 850 Square customers

When onboarding new clients to Xero, I sync their Square customer directory so invoices link to existing contacts. The smart name generation handles cases where Square has separate first and last name fields while Xero needs a single combined name. I use the company-first priority so business customers import under their trading name.

Patrick O.
Bookkeeper, Retail Clients · 3 Square merchant accounts

We migrated from basic Square invoicing to Xero and needed all our customer data transferred. I exported the Square customer directory, converted to Xero contact CSV, and imported in one batch. The address mapping copied billing details to both postal and street fields, saving me from manually updating shipping addresses for each contact.

Yolanda S.
Spa Owner, Multi-Location · 2,200+ customer records

Common Conversion Questions

How are duplicate names handled?

By default, we add suffixes like (2), (3) to duplicate names. You can also choose to skip duplicates or keep them (Xero will reject during import).

What customer data transfers to Xero?

Customer name, email, phone, and address typically transfer. Some fields like internal tags may not sync depending on your integration method.

What file formats work for customer import?

CSV, XLS, XLSX, and XLSM files work for importing Square customers to Xero contacts. Ensure proper column mapping before importing.

Syncing Square Customers to Xero

Customer Data Challenges

Square and Xero use different data structures for customer information: - Square separates first/last name; Xero needs combined "Name" - Square has one address; Xero has postal (billing) and street (shipping) - Xero requires unique contact names (duplicates rejected)

What Gets Synced

This tool maps: - Name: Company Name or Given Name + Family Name - Contact Info: Email, phone number - Address: Street, city, state, postal code, country - Reference: Square Customer ID preserved as Account Number

Your Conversion is Secure

Browser-Only Processing

All conversion runs in your browser. Files are never uploaded to any server.

No Data Retention

Nothing is stored after conversion. Close the tab and your data is gone.

GDPR Compliant

Full EU data protection compliance. Your privacy rights are fully protected.

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

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

Why Use This Converter?

Smart Name Generation

Combines Square name fields into Xero-compatible contact names.

Duplicate Detection

Automatically handles duplicate names with suffixes or filtering.

Address Mapping

Maps Square address to both billing and shipping in Xero.

Customer ID Preservation

Square Customer ID saved as Account Number for reference.

Batch Processing

Handles large customer lists with automatic batching.

Browser Privacy

Customer data processed locally, never uploaded.

Data Transformation

Each Square customer becomes one Xero contact record

Input Square Customer

One row per customer from Square Customer Directory

Key columns: Customer ID, Given Name, Family Name, Email Address, Phone Number
1:1 — One input row creates one output row
Output Xero Contact 1 rows per input

One contact record with full details

Contact Record Customer details with name fallback (email/company) and duplicate handling
Name unique (duplicates get suffix); name fallback if Given/Family blank

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

Frequently Asked Questions

Your data never leaves your device. All files are processed entirely in your browser using client-side JavaScript - no data is stored on our servers or sent anywhere. There's no account to hack, no database storing your files, and no API connections to your bank or accounting software. You upload, convert, download, and we forget it immediately.
No payment or signup required. You can upload your file, see a free preview of the conversion results, and verify everything looks correct before paying anything. If it doesn't work for your files, you haven't wasted any money. We only charge when you're satisfied and ready to download the final converted file.
You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.
By default, we add suffixes like (2), (3) to duplicate names. You can also choose to skip duplicates or keep them (Xero will reject during import).
We generate a name from email address or Customer ID (e.g., 'Customer_CUST123'). You can update these in Xero after import.
No, Xero's CSV import creates new contacts. For updates, you'd need to merge or edit contacts in Xero after import.
Some Square customers are Network customers with hidden contact info. Only emails and phone numbers Square has access to will sync to Xero contacts.
Most integrations sync customer data every 10 minutes automatically. Check your integration tool settings for custom sync intervals.
Customer name, email, phone, and address typically transfer. Some fields like internal tags may not sync depending on your integration method.
Yes, but import in batches if possible. Xero recommends limiting large imports to avoid performance issues with your account.
Only new or modified customer records typically sync automatically. Historical customers may need manual import or a one-time full sync.
CSV, XLS, XLSX, and XLSM files work for importing Square customers to Xero contacts. Ensure proper column mapping before importing.
Missing required fields (like name or email), incorrect data formatting, or account connection issues can prevent customer sync. Verify data quality first.

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

Also available as

This platform pair is available in 3 other hubs

Learn More:

vs Zapier vs SyncPenguin vs Activepieces vs Amaka vs Synder vs Skyvia vs CarryTheOne (UK) vs Webgility Export Customers Guide