---
title: "Export Customer List From QuickBooks® Online"
slug: "export-customer-list-from-quickbooks-online"
description: "Export the Customer Contact List from QuickBooks Online, remove duplicates, and reformat as CSV for import into R365."
updated: 2025-08-26T17:00:15Z
published: 2025-08-26T17:00:15Z
canonical: "docs.restaurant365.com/export-customer-list-from-quickbooks-online"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.restaurant365.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Export Customer List From QuickBooks® Online

If you use QuickBooks Online and are now setting up Restaurant365, moving your Customer List over is easy. When importing a Customer List, it is important to consolidate and update the list before importing into R365. Follow the instructions below to help prepare a successful file for import.

---

## Download Customer List from QuickBooks Online

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(144).png)

Click 'Reports' in the left-hand navigation and run the 'Customer Contact List' report.

![](https://cdn.us.document360.io/5c9d1111-0c69-4e96-8910-d7f2750fdc9d/Images/Documentation/image(145).png)

The report should look similar to the one in the image above. In the top, right-hand corner of the report, click the 'Export' icon and then the 'Export to Excel' button. This will download the report and allow you to save it as a CSV to your desktop.

---

## Consolidate Customer List

It is important to make a consolidated list of all Customers. To do so, make sure to:

1. Open your downloaded file and delete Customers that you do not currently do business with
2. Delete duplicate Customers (this includes Customers that may be spelled differently, but are the same entity). Click here to follow the steps needed to [remove duplicate Customers](https://support.office.com/en-us/article/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d)
3. Reformat your file to [this structure](http://restaurant365training.com/wp-content/uploads/2019/09/Customer-New.csv): Name (required), Number (personalized), Phone, Email, Street1, Street2, City, State, Zip, Fax, Primary Contact, Payment Terms, Terms Discount Account, Taxable, Discount %, and Franchisee Location

> Only the Name of each Customer is required, but including as much information from your QuickBooks Customer List will benefit you when you fully transfer over to R365
4. Save your CSV file

Restaurant365

Structured documents that provide insights and summaries of various operational metrics and financial data.