The CSV upload feature allows you to easily import new contacts or update existing ones in bulk. This is particularly useful when migrating from another platform or when you need to add a large number of contacts at once.
Getting Started with CSV Uploads
Prepare your CSV file
Create a CSV file with the following columns:Required column:
Email- The contact’s email address
First Name- The contact’s first nameLast Name- The contact’s last name
Subscribed- Whether the contact is subscribed (usetrueorfalse, defaults totrueif not specified)- Any custom properties you’ve created in Brew
Access the import screen
- Go to the Audience page
- Click the Add Contacts button in the top right corner
- Select CSV Upload from the dropdown menu
Upload your CSV file
- Drag and drop your CSV file into the upload area or click to browse your files
- Wait for the file to upload and process
Map CSV columns to Brew properties
After uploading, you’ll see a column mapping screen:
- Ensure each CSV column is correctly mapped to the corresponding Brew property
- For any columns that don’t have a default mapping, select the appropriate property from the dropdown
- Click Continue when the mapping is complete
Updating Existing Contacts
You can also use CSV upload to update existing contacts:Matching existing contacts
Matching existing contacts
Brew identifies existing contacts using the email address:
- If an email in your CSV matches an existing contact, that contact will be updated
- If no match is found, a new contact will be created
Partial updates
Partial updates
When updating contacts, empty cells in your CSV will not overwrite existing data. Only cells with values will update the corresponding property.
Subscription status
Subscription status
Important notes about the
Subscribed column:- If not included, all new contacts will be marked as subscribed by default
- To import unsubscribed contacts, include a
Subscribedcolumn withfalsevalues - The importer will not re-subscribe contacts who have previously unsubscribed
Viewing Import History
Past imports are shown below the upload area on the CSV Upload page. Each entry shows details like import date, number of contacts imported, and success/error rates.Troubleshooting Common CSV Issues
Duplicate contacts
Duplicate contacts
If your CSV contains duplicate email addresses, Brew will process them in order. The last row for each email will be the final state. To avoid confusion, deduplicate your CSV before uploading.
Invalid email formats
Invalid email formats
Emails must be in a valid format (e.g., name@domain.com).Invalid emails will be flagged during the review step and will not be imported.
Encoding issues
Encoding issues
If your CSV contains special characters:
- Ensure your CSV is UTF-8 encoded
- If you see garbled text in the column mapping screen, try re-exporting your CSV with UTF-8 encoding
Large file handling
Large file handling
For very large CSV files, the import may take several minutes. Consider splitting very large files into smaller batches for easier tracking.
Need Help?
Our team is ready to support you at every step of your journey with Brew. Choose the option that works best for you:- Self-Service Tools
- Talk to Our Team
Search Documentation
Type in the “Ask any question” search bar at the top left to instantly find relevant documentation pages.
ChatGPT/Claude Integration
Click “Open in ChatGPT” at the top right of any page to analyze documentation with ChatGPT or Claude for deeper insights.