Learn how to add or update contacts by uploading a CSV file to Brew
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.
Add thousands of contacts at once with a simple spreadsheet upload
No need to worry about duplicates—Brew handles them automatically
Include any custom fields you want to add or update with your contacts
Prepare your CSV file
Create a CSV file with the following columns:
Required column:
Email
- The contact’s email addressRecommended columns:
First Name
- The contact’s first nameLast Name
- The contact’s last nameOptional column:
Subscribed
- Whether the contact is subscribed (use true
or false
, defaults to true
if not specified)Download our example CSV template to ensure your file is correctly formatted.
Access the import screen
Upload your CSV file
Map CSV columns to Brew properties
After uploading, you’ll see a column mapping screen:
If your CSV contains columns for custom properties that don’t yet exist in Brew, they will be automatically created during the import process.
Review and confirm
Review the import summary, which shows:
Complete the import
Click Complete Import to finalize the process.
You’ll see a success message when the import is complete, and your contacts will be available in your Audience.
During the import process, you can optionally add the imported contacts to one or more subscription groups:
Enable subscription group option
On the review screen, toggle on Add to subscription groups
Select subscription groups
Choose the subscription groups you want to add the contacts to from the dropdown menu
Complete the import
Continue with the import process as normal
This will only add contacts to the selected groups - it won’t remove them from any groups they might already belong to.
You can also use CSV upload to update existing contacts:
Matching existing contacts
Brew identifies existing contacts using the email address:
Partial updates
When updating contacts, empty cells in your CSV will not overwrite existing data.
If you want to clear a field, you must use the value null
(4 characters, all lowercase) in the CSV cell.
Subscription status
Important notes about the Subscribed
column:
Subscribed
column with false
valuesYou can optionally trigger automations when importing contacts:
Enable automation triggers
On the review screen, toggle on Trigger automations
Understand which automations will trigger
This will trigger:
Complete the import
Continue with the import process as normal
Be careful when enabling this option with large imports, as it could trigger a high volume of emails.
You can view a history of your past CSV imports:
Duplicate contacts
If your CSV contains duplicate email addresses:
To avoid this, deduplicate your CSV before uploading.
Invalid email formats
Emails must be in a valid format (e.g., [email protected]).
Invalid emails will be flagged during the review step and will not be imported.
Encoding issues
If your CSV contains special characters:
Large file handling
For very large CSV files:
Our team is ready to support you at every step of your journey with Brew. Choose the option that works best for you:
Type in the “Ask any question” search bar at the top left to instantly find relevant documentation pages.
Click the sparkle ✨ icon next to the “Ask any question” search bar in the top left to chat with our AI assistant that’s been trained on our entire documentation.
Click “Open in ChatGPT” at the top right of any page to analyze documentation with ChatGPT or Claude for deeper insights.
Type in the “Ask any question” search bar at the top left to instantly find relevant documentation pages.
Click the sparkle ✨ icon next to the “Ask any question” search bar in the top left to chat with our AI assistant that’s been trained on our entire documentation.
Click “Open in ChatGPT” at the top right of any page to analyze documentation with ChatGPT or Claude for deeper insights.
Book time with our founders for personalized guidance on strategy, best practices, or complex implementation questions.
Need immediate assistance? Reach us at +1-(332)-203-2145 for urgent issues or time-sensitive questions.
Our preferred support channel. You’ll receive an invite after signup for direct founder support and fast responses.
Contact us at [email protected] for detailed inquiries or if you prefer not to use Slack.