The bulk email validator accepts .txt, .xls, .xlsx, and .csv file types. Please make sure your file is in one of our accepted formats. When you upload a file, our system will scan it. The file will be rejected if something unusual is detected. If you upload a .csv, .xls, or xlsx file, the first few columns will be displayed after you click "Validate File". Our system will try to determine the column's data type, as well. Any mistakes can be fixed before validation. If you can't get the system to accept your file, please use the help button on the bottom right to contact us.
Please make sure your file follows one of the formats here: Allowed File Formats
Column Matching and Data Append
Column matching is important, because if you upload a .csv, .xls, or .xlsx file with a first name column, our system will use that information to tell you the gender of that email. Apart from the gender, our system also has the ability to determine the location, account creation date, first and last name of some of the emails you upload. It will use the data you provide and fill in the gaps. We don't store your emails or your data. Our Data Append feature uses public sources of information known to be 99% accurate. If the IP address is provided, we will append the city, region/state, zip code, and the country to the output.
Duplicate, Uni-coded, and Malformed Email Addresses
All duplicate, uni-coded, and malformed email addresses will be removed from the list. So, if you upload a list of 5,000 emails and you have 1,000 duplicates, only 4,000 will be processed. No, you will NOT be charged for submitting duplicate, uni-code, or malformed emails. Invalid email syntax is different from uni-coded and malformed emails. Once your file is finished processing, there will be an arrow on the left of the file name that you upload, which will expand a section below to show you if we found any of the above mentioned conditions.
Long File Names
ZeroBounce will truncate all file names over 70 characters. We do this because windows will only support 160 characters in a file path and with log filenames customers hit that limitation when extracting the files from the zip file. Please name your files accordingly, to not exceed the 70 character limitation.
All files, whether it's one email or a million emails, will most likely take 20 minutes or longer to process. We can process the emails much faster, but we have an anti-greylisting technology which requires the results to be delayed by 15 minutes to reduce the number of "Unknown". We do have the ability to process 80-100 million emails a day. Some email domains take longer to validate than others, but you will not be waiting days for the results. It will take about 1 to 3 hours per 100,000 of mixed domains. The system will update the progress on every 100,000 validated emails. You can check the status on the "Download Your Results" page. Once your entire list is fully validated, you will receive an email notification letting you know your results are ready to be downloaded.
TIP: If you want faster results, break out the major ESP domains (Yahoo, Gmail, Hotmail, etc) from the others into separate files. These domains process much faster than the smaller ones.
Allowed File Formats
Examples of Accepted Text File Formats:
Example Text File 1:
Example Text File 2:
Example Text File 3:
Examples of Accepted CSV File Formats:
A CSV file is accepted if it's separated by Comma's [ , ], Pipes [ | ], Tabs [ ], or Semi-Colons [ ; ], or Carriage Returns/Line Feeds. If it's separated with a different delimiter, it will consider your CSV File as a single column file. If you save your spreadsheet as a CSV or TXT file, the system will accept it.
Example CSV File 1:
Example CSV File 2:
- If your CSV file contains a header row (In the column matching screen) after you click "Validate File", please check the "Yes" for "Header Row" before clicking "Process File" , if you check "No" it will process the header row as an email address.
- If your CSV file has multiple columns of email addresses, we will allow you to select which column of emails you want us to process
- If we detect a large number of invalid emails or missing emails the system will reject it.
- All rows that don't have an email address in it will be ignored and removed.
- All duplicate emails will be removed, if a duplicate email is encountered the entire row is removed.
- If you have multiple email addresses in the same cell, it will be processed as a single email address, which will all end up being invalid
- We support up to 500 columns of data in your CSV file and a 1 gigabyte file size uploads.