What Square export file format does this tool accept?

This tool accepts Square Customers CSV files. Export from Square and upload the CSV file directly.

Can I convert Square CSV to Xero Contact?

Yes, this tool converts Square Customers CSV exports directly to Xero Contact CSV format compatible with Xero Contact.

How do I import Square customers to Xero Contact?

Export your customers from Square, upload the CSV file to this converter, then import the converted file to Xero Contact.

Square Customers to Xero Contacts — Customer Directory Sync

🥦

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

Export from Square

Customers → Import / Export → Export Customers → Download

Upload and Configure

Upload Customers Export CSV and choose Contact format

Preview and Download

Review converted data, download Xero-ready file

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

How People Use Square Customers → Xero

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.

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.

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.

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

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

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.