What format should the CSV file be in for bulk email verification?
Learn the correct CSV file format for bulk email verification to avoid parsing errors. Follow our guidelines and use the provided template.
What format should the CSV file be in for bulk email verification?
If you're encountering errors while trying to upload your CSV file for bulk email verification, it's essential to ensure that your file is formatted correctly. Below are the guidelines and a template to help you avoid common parsing errors.
Required CSV Format
To successfully upload your CSV file, it must adhere to the following format:
- The first row must contain headers.
- The headers should include at least "email" and optionally "name".
- Each subsequent row should contain the email addresses you want to verify.
Example CSV Format
Here’s a sample of how your CSV file should look:
| email | name | |---------------------|----------------| | replace@this.com | Replace This | | replace2@this.com | Replace This Too|
Make sure there are no extra spaces or special characters in the email addresses.
Common Errors and Solutions
If you receive an error message like "error parsing CSV file," consider the following:
- Check for Headers: Ensure your CSV file includes the required headers.
- Email Format: Verify that all email addresses are correctly formatted and do not contain any typos.
- File Encoding: Ensure your CSV file is saved in UTF-8 format without BOM (Byte Order Mark).
Troubleshooting Tips
If you continue to face issues after following the guidelines:
- Test with a Minimal File: Create a new CSV file with just two email addresses to see if the issue persists.
- Send Us Your File: If you're still having trouble, you can send us the CSV file you are trying to upload, and we can help you identify the formatting issues.
Still stuck?
If you’re still encountering problems, please include the following information in your support ticket:
- The exact error message you received.
- A screenshot of the error.
- The plan you are currently on.
- A brief description of what you were trying to do when the error occurred.