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.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample

Sample QBO customer export CSV

Download

Tool Rating

4.7 / 5 (52 votes)

How to Convert Your File

Export from Quickbooks Online

Sales → Customers → Export to Excel

Upload and Configure

Upload QBO Customer 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 Contacts CSV format — ready to import directly, no manual reformatting needed.

How People Use This

Customer data is always one of the first things I migrate from QuickBooks Online to Xero. I converted a client's 800-contact customer list and the field mapping handled display names, billing addresses, and email addresses without manual intervention. Xero's PO and SA address fields populated correctly from QBO's billing and shipping columns.

We had over a thousand customers in QuickBooks Online and needed them in Xero for our platform migration. The conversion mapped QBO customer fields to Xero contact format and the duplicate name handling appended numbers where two companies shared the same display name. Import took under a minute.

I converted QuickBooks Online customer exports to Xero contacts CSV for multiple clients during their migrations. The tool validated email formats and phone numbers before output, so I didn't get import rejections. The batch processing respected Xero's 500-contact limit per file automatically.

Switching from QuickBooks Online to Xero meant moving our entire customer database. The conversion transferred display names, company names, emails, phone numbers, and full billing addresses into Xero's contact CSV format. I skipped inactive customers to keep the import clean and it worked on the first upload.

Customer migration is always cleaner when you convert QBO customer data to Xero contacts in bulk rather than re-entering manually. The address conversion from QBO's billing street format to Xero's POAddressLine fields handles multi-line addresses correctly. I run the duplicate check with append-number mode to avoid Xero's unique name requirement errors.

Common Conversion Questions

What customer fields are converted?

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.

What happens to customer balances?

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

Does customer data need cleaning before migration?

Yes, remove duplicates and verify addresses/contacts in QBO first. Clean data prevents errors and duplicate contacts in Xero.

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 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 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 Converter?

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

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.

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.

Yes, remove duplicates and verify addresses/contacts in QBO first. Clean data prevents errors and duplicate contacts in Xero.

Yes, payment terms transfer during migration when exported from QBO and properly mapped to Xero contact fields.

Merge or remove duplicates in QBO before migration using the 'Find duplicates' tool to avoid duplicates appearing in Xero.

Yes, tax ID information can be exported from QBO and imported as part of customer contact details in Xero.