At BombBomb, we can add a mass number of contacts to your account in one go when you upload a .csv file. While most .csv files will upload contacts into your BombBomb account, there are a few things that could cause your file to fail. This could be anything from formatting issues to using the wrong file type. When you're trying to get contacts into your account so you can start building relationships with video as fast as possible, this can be super frustrating!
Luckily, BombBomb has the ability to alert you if your .csv file upload has failed. Additionally, we will also show you how many (and which!) contacts from your .csv file failed to get added to your account. To understand how this works and to learn some tips and tricks on how to get your .csv file in shape for seamless uploading, keep reading!
If something goes wrong with your file when uploading, BombBomb will alert you with a red banner at the top of your screen after you've attempted to upload the file. If you click “Download Now," you can open up the file to see what data (aka, which contacts) wasn’t able to upload into the system properly.
Below are some steps to help clean up your .csv file, save your file in the correct format, and select the correct contact list:
1. Clean up your .csv file
When opening up your .csv file, you’ll want to remove any outliers in your contacts information. These are going to be malformed columns, which can include special characters in front of email addresses, extra punctuation in columns, or multiple email addresses in the same column.
You’ll also want to remove any formatting, headers, or blank columns to make the file compatible with BombBomb.
Keep in mind, the most important columns you’ll want to include are each contact's email address, first name, and last name.
2. Save your file in the correct format
Whether you are exporting your file or creating it from scratch, you will want to make sure it is saved in Excel as a .csv file.
Follow the steps below to save your file in Excel as a .csv:
- Select the “File” tab in the top left corner of Excel
- Choose the “Save As” option
- Click “Browse” to choose a spot to store the file and give it a name
- Click the drop down arrow next to “Save As Type”
- Select CSV (Comma delimited)
If you'd like some help with creating a .csv file from scratch, click here to download a .csv template!
3. Make sure to select the correct contact list
When importing your .csv file into your contact list, it’s important to make sure they are being uploaded into the correct contact list.
Once you click on “Add People," a window will appear with uploading option - here is where you can choose “Add to List." If you click on this, a drop down menu will appear and you can select a specific list to upload the contacts into.
Once your contacts are loaded into a contact list, you may see differences in the number of contacts uploaded versus the number of contacts in your .csv file. Remember: our system recognizes and removes duplicates, and will also not upload contacts without a valid email address.
After looking over your .csv file using the tips outlined above, try re-uploading it into your contacts. If your .csv file is clean, saved in the proper format, and uploaded to the intended list, you should be all set!