What QuickBooks export file format does this tool accept?

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

Can I convert QuickBooks CSV to Xero Contacts?

Yes, this tool converts QuickBooks Online Customers CSV exports directly to Xero Contacts CSV format compatible with Xero Contacts.

How do I import QuickBooks online customers to Xero Contacts?

Export your online customers from QuickBooks, upload the CSV file to this converter, then import the converted file to Xero Contacts.

Convert QuickBooks Online Customers to Xero Contacts CSV

🥦

Xero Contacts CSV Format

valid rows

Migrate your QuickBooks Online customer list to Xero. Convert customer details, addresses, and contact information to Xero-ready contact CSV.

No API required

Browser-based processing

Run on Google Cloud Platform

Download Sample

Sample QBO customer export CSV

Download

Tool Rating

4.7 / 5 (156 votes)

How It Works

Export Customers

QBO → Reports → Customer Contact List → Export to Excel/CSV

Upload File

Upload the exported customer list CSV or Excel file

Configure Options

Select region and duplicate handling preferences

Import to Xero

Settings → Import → Contacts → Upload converted file

Why QuickBooks Customer Exports Need Conversion for Xero

Different Field Structures

QuickBooks Online and Xero use different field names and structures for contacts. QBO exports "Customer Display Name" while Xero expects "ContactName". Address fields like "Billing Street" need to become "POAddressLine1". Our converter handles all these mappings automatically.

Contact Type and Duplicate Handling

Xero requires unique contact names and doesn't allow duplicates. If you have customers with the same company name, you'll need a strategy to differentiate them. Our tool can append numbers or identifiers to make names unique, or skip duplicates if you want to handle them manually.

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.

Field Mapping

How Quickbooks_Online Customer_List fields map to Xero Contact

Quickbooks_Online Customer_List	Source Value		Xero Contact	Target Value	Note
`Email`	`john@example.com`	→	`EmailAddress`	`john@example.com`	Primary email address
`First Name`	`John`	→	`FirstName`	`John`	Contact first name
`Last Name`	`Smith`	→	`LastName`	`Smith`	Contact last name
`Billing Address Line 1`	`123 Main Street`	→	`POAddressLine1`	`123 Main Street`	Postal address line 1
`Billing City`	`New York`	→	`POCity`	`New York`	Postal city
`Billing State`	`NY`	→	`PORegion`	`NY`	Postal state/province
`Billing Postal Code`	`10001`	→	`POPostalCode`	`10001`	Postal ZIP/postal code
`Billing Country`	`United States`	→	`POCountry`	`United States`	Postal country
`Shipping Address Line 1`	`123 Main Street`	→	`SAAddressLine1`	`123 Main Street`	Street address line 1
`Phone`	`(555) 123-4567`	→	`PhoneNumber`	`(555) 123-4567`	Primary phone
`Mobile`	`(555) 987-6543`	→	`MobileNumber`	`(555) 987-6543`	Mobile phone
`Fax`	`Sample Text`	→	`FaxNumber`	`Sample Text`	Fax number
`Website`	`https://example.com`	→	`Website`	`https://example.com`	Website URL
`Tax Resale Number`	`12-3456789`	→	`TaxNumber`	`12-3456789`	Tax registration number
`Currency`	`USD`	→	`DefaultCurrency`	`USD`	Default currency code

Why Use This Tool?

Field Mapping

QBO customer fields automatically mapped to Xero contact format.

Address Conversion

Billing and shipping addresses converted to Xero PO/SA address format.

Duplicate Detection

Handles duplicate names with configurable strategies.

Batch Processing

Respects Xero's 500 contact per import limit with automatic batching.

Contact Validation

Validates email formats, phone numbers, and required fields.

Browser Privacy

All processing happens locally. Your customer data never leaves your device.

Data Transformation

Each QBO customer becomes one Xero contact

Customer with billing/shipping addresses

Key columns: Customer, Company, Email

1:1 — One input row creates one output row

Contact Record Direct field mapping with normalization

Name required, addresses optional

Common Contact Import Errors

Issues you might encounter when importing QBO Customer 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-append numbers to duplicates

Review duplicates after import for merging

Missing Customer Name

Contact must have a name to import

Rows without any name identifier are skipped

Add customer name in source file before converting

Name Exceeds 255 Characters

Xero limits contact name to 255 chars

Names are truncated automatically

Consider using shorter company/display names

Frequently Asked Questions

We convert display name, company name, email, phone, mobile, fax, website, billing address, shipping address, tax ID, and notes. Custom fields are not exported by QBO's standard report.

QBO Billing Address becomes Xero's PO (Postal) Address, and QBO Shipping Address becomes Xero's SA (Street) Address. All address components are mapped correctly.

This tool converts contact records only, not financial data. Customer balances need to be handled via opening balance journals or invoice migration.

This tool converts one-to-one. To merge customers, you would need to edit the source file before conversion or use Xero's merge contacts feature after import.

Xero uses ContactName as the unique identifier for contacts. It's mapped from QBO's 'Customer Display Name' or constructed from first/last name if display name is empty.

Xero allows up to 500 contacts per import file. If you have more, our converter will indicate you need to split the file.