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

How to Convert Square Customers → Xero

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.

Square Customers → Xero 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.

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

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

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 the Square Customers → Xero 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

Your Square Customers → Xero Conversion is Secure

Local Processing Engine

Your Square Customers → Xero files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your Square Customers → Xero files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your Square Customers → Xero files.

More credits - more savings

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

Frequently Asked Questions

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