Import Customers from CSV in Minutes

The Problem

You're migrating to BarSight from another system and have 300 customers in a spreadsheet. Manually entering each one, with name, address, phone, email, contact person and notes, would take days of tedious data entry. You're tempted to just start fresh and lose all that relationship history, but you know that's not ideal. There has to be a faster way.

The Solution

BarSight's CSV import feature lets you upload hundreds of customers from a spreadsheet in minutes. Export from your old system, format the CSV file, upload, and you're done. Perfect for system migrations, bulk customer setup, or importing wholesale accounts from accounting software.

How to Use It

1. Navigate to Brewery → Customers
2. Click Import CSV in the toolbar
3. Download the CSV template to see the required column format
4. Prepare your CSV file with customer data:
   • Required columns: Customer Name, Contact Name
   • Optional columns: Address, City, Province/State, Postal Code, Phone, Email, Notes, Customer Type
   • Use the template format exactly, because the column names must match
5. Click Choose File and select your CSV
6. Click Upload and Import
7. Review the import preview showing how many customers will be created
8. Click Confirm Import

BarSight processes your file and creates customer records. You'll see a summary of how many were imported successfully and any errors that need fixing.

[SCREENSHOT: Import Customers window showing the CSV template download, file upload button, and import preview table]

Pro Tip

Before importing, clean your data in the spreadsheet first. Fix formatting issues, remove duplicates, standardize province/state abbreviations, and validate phone numbers. A clean import saves hours of cleanup work later.

Learn More

After importing, you might discover duplicates that slipped through. Learn how to merge duplicate customer records, or follow the full post-import routine in Cleaning Up After an Import. You can also set up customer visit notes to start building relationship history going forward.