Supported File Formats
Bulk email verification or email list cleaning can be performed by uploading email lists on the QuickEmailVerification client area.
QuickEmailVerification supports Comma Separated Value (.csv), Plain Text (.txt) or text-only spreadsheets (.xls, .xlsx or .ods) file upload. You can upload a simple list of emails or emails along with its associated information like name, city, etc.
File upload criteria
The following checklist will help you to prepare an email list for bulk email verification on QuickEmailVerification.
- File must be Plain Text (.txt) or Comma Separated Value (.csv) or spreadsheet (.xls, .xlsx or .ods).
- The file should have only one email address per row and rows without the email address should be removed.
- Plain Text (.txt) file must have only list of email addresses you wish to validate (and nothing else), one per line.
- Multiple column CSV files must have a comma (,) as a field delimiter/separator.
- Keep all emails in the same column.
- File size should not be more than 50MB. For large files, split a single file into multiple smaller files. Contact Us for further assistance.
Plain Text Files
To prepare a plain text file with a list of emails to verify, open any text editor (i.e notepad), copy+paste a list of emails and save it as a .txt file.
If you have exported your email list from any other program or database as .csv file, it may contain other information along with emails. You can still upload such file and QuickEmailVerification will automatically fetch only email values from the file to verify.
The list must contain one email column and all emails should be placed in the same column throughout the file. The header row in such file is optional and if it is found in the file, it will be ignored for processing.
If the file contains additional information associated with the email like name, address, contact no, etc., it will be kept intact in the final verification report and result data will be appended at the end of each row.
Spreadsheets (Excel Files)
Spreadsheet with a list of emails to be verified can be uploaded too. The spreadsheet must be a single sheet having all the emails in a single column with other optional fields. Supported spreadsheet extensions are .xls, .xlsx and .ods. For other spreadsheet extension, it is recommended to convert the spreadsheet into CSV.
To prepare CSV file from spreadsheet, open spreadsheet program (i.e. Microsoft Excel or OpenOffice Calc) with the list of emails in a single column and other optional fields (columns) and save the file as Plain Text CSV (.csv).
Troubleshooting File Upload
The file does not contain valid CSV data
While uploading CSV file if you get error message "uploaded file does not contain valid csv data", you may need to recheck the content of a file. A csv file must conform to the CSV standards and any file with invalid csv data will be rejected.
The most common reason for this error is that file content is not in Comma Separated Value. QuickEmailVerification accepts only Comma Separated Value as CSV file. Files which contains any other delimiter(such as semicolon or pile) separated values will be rejected.
The file is not in an acceptable format
QuickEmailVerification supports the file in text format only. File other than text formats (like pdf, word documents, compressed files) should be converted to acceptable .txt, .csv or .xls file before uploading to QuickEmailVerification.
File is .csv though it is rejected
Sometimes file being uploaded on QuickEmailVerification does not meet with the acceptable MIME type requirements. Often it is possible that the program or website from where the file has been exported/downloaded does not set the content type of the file. Such files may still contain valid data and file format but unable to upload because the content type of the file cannot be detected. You should try to open such file in a related program (like Microsoft Office, OpenOffice), save as the file in .csv format and upload new file.
Other common reason for such issues is manually renaming the file, ie. renaming a .rtf file as .txt or .csv file as .xls. Most of the times, just changing the file extension by renaming it does not convert it to the target file format automatically. The recommended way to convert the file is opening the file in the supported application and then save it to the desired format.
Files in the .gnm or .xlsb or other formats
If you have your data in a spreadsheet other than .xls or .xlsx format, you may need to create a .csv file from it. To create a CSV file from a spreadsheet, open file in a spreadsheet program (i.e. Microsoft Excel or OpenOffice Calc), select "Save As" from the menu and save the file as Text CSV.