Bring in a list from another app or a spreadsheet
Bring customers or a price book in from any CSV or Excel list, from any app.
Who can do this: Owner, Admin.
Last updated
Coming from an app that isn't on the list, or keeping customers in a spreadsheet? Any list with column names in the first row works.
Only an Owner or Admin can import.
Steps
Export or save your list as CSV or Excel (.xlsx). One list per file: customers in one, price book in another.
This step happens on your phone, outside All Trades Office.
Make sure the first row has the column names.
This step happens on your phone, outside All Trades Office.
In All Trades Office, tap More at the bottom of the screen.

Under Settings, tap Company settings.

Tap Import your data.

Tap Another app or a spreadsheet.

Tap Choose files and pick every file you downloaded. You can add them all at once. Then follow Check the columns and bring it in.

Good to know
- Customers need a name, or a first and last name, or a company. Price book items need a name.
- Common column names like Name, Email, Phone, Street, City, State and ZIP are matched for you. Match the rest yourself; we remember your choices for next time.
- A second address (billing, for example) has its own set of columns.
- For a price book, a Category or Folder column puts items in folders. Use Folder > Subfolder for up to three levels.
- Older Excel files (.xls) need saving as .xlsx or .csv first.
- Files can be up to 15 MB each. Split bigger lists into a few files and add them together.
- Imports never email or text your customers, and nothing is sent to QuickBooks.
Related
- Check the columns and bring it inAfter you add your files: check how the columns were matched, look over the preview, and bring your records in.
- Undo an importTake back an import for up to 30 days. Anything your team has used or changed since is kept.