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 appear after you select the file you want to upload. 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 finishes processing, look to the right side and click the Expand Results arrow. This will expand and show if any of the mentioned conditions above were found.
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
Allowed file formats:
Examples of Accepted Text File Formats:
Example Text File 1:
A TXT file that is separated with Comma's [ , ], Pipes [ | ], Tabs [ ], or Semi-Colons [ ; ] (without Carriage Returns and Line Feeds).
Example Text File 2:
A TXT File with only (Carriage Returns and Line Feeds).
Example Text File 3:
A TXT Files that looks like a CSV file will be converted to a CSV file when you upload it.
Examples of Accepted CSV File Formats:
A CSV file is accepted if it's separated by Comma's [ , ], Pipes [ | ], Tabs [ ], or Semi-Colons [ ; ]. 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:
A typical accepted CSV file format
Example CSV File 2:
A typical accepted single column CSV file format
- If your CSV/XLS file contains a header row (in the column matching screen), please check the "Yes" , checkbox for "Does your first row contain labels?" before clicking "Next Step." - 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. For large files, we recommend CSV and NOT XLS/XLSX (please convert/save as .csv).