Skip to main content

Import or Export Customers in Bulk

Learn how to import and export customers in bulk with Excel templates, upload customer spreadsheets, handle multiple shipping addresses, and download customer exports from Brandboom.

Updated yesterday

If you would like to import or export customers in bulk, you can do so using .XLS files.


Import from Excel template

Open the Visitor’s Page by clicking the “Home” icon on your left-hand menu.

Visitor’s Page with the Home icon used to access customer tools.

Click “Customers” along the top toolbar and select “import customers”.

Customers menu with the Import Customers option selected.

The red and green labels at the top of the spreadsheet will explain the various fields.

Customer import spreadsheet template with color-coded field labels.

Once you’ve completed the spreadsheet, you will need to upload it to Brandboom.

Select your file and upload it.

Import Customers upload window with a spreadsheet file selected.


Multiple Shipping Addresses

Importing Additional Shipping Addresses through Excel

If your customer has multiple shipping addresses, pay attention to the “Type” column on the Customer Template.

  • Enter “B” under Type to indicate a billing address.

  • Enter “S” under Type to indicate a shipping address. You can use Customer Code 2 to identify different shipping addresses for one customer.

  • If the Type Column is left blank, customer information in that row will be imported as a Billing & Shipping address.

Customer template example showing Type values for billing and shipping addresses.


Export Customers

If you need to export your Customers, click the “Customers” button and select “Download Customers”.

Customers menu with the Download Customers option selected.

Next, click the “Download” button and you should receive an email with a download link for your export template.

Download Customers dialog with the Download button for the export template.

NOTE: Password-protected files cannot be imported.

Did this answer your question?