How to Upload a CSV to Bulk Create Multiple Contacts
This guide will help you use POWR's Bulk Create/Upload Contacts feature to add multiple contacts to your account at once.
Getting Started
Option 1: Download Our CSV Template
The easiest way to get started is to download our CSV template and edit it using your preferred spreadsheet application.
Option 2: Use Google Sheets Template
- Make a copy of our Google Sheets template
- Add your contact information in the appropriate columns
- When ready to import, go to the File menu
- Select Download → Comma Separated Values (.csv)
- Save the file to your computer
FIX: BROKEN_ATTACHMENT (original: https://help.powr.io/hc/article_attachments/31264839569943)
Uploading Your CSV File
- Navigate to the Contacts section in your POWR dashboard
- Click the Bulk Create Contacts button
- Drag and drop your CSV file into the upload area or click Choose file to select it
- Wait for the upload and processing to complete
- You'll see a confirmation message with details about imported contacts
FIX: BROKEN_ATTACHMENT (original: https://help.powr.io/hc/article_attachments/31264813981463)
CSV File Requirements
To successfully import your contacts, your CSV file must follow these guidelines:
- All columns must exist in your CSV file, even if some cells remain empty
- Email is the only required field - all other fields can be left blank
- Contacts with email addresses that already exist in your database will be skipped
- Tags should be comma-separated within quotes (e.g., "tag1, tag2, tag3")
- Email and Phone Opt-ins should be either "true" or "false"
Required CSV Columns
Your CSV file must include these columns:
- first_name
- last_name
- phone
- street_address
- street_address_2
- city
- state
- zip_code
- country
- notes
- tags
- email_opt_in
- phone_opt_in
Tips for Success
- Ensure all email addresses are correctly formatted
- Make sure your CSV file uses UTF-8 encoding
- Remember that only contacts with unique email addresses will be imported
If you encounter any issues during the upload process, verify that your CSV file follows all the requirements listed above.