Supported File Formats
Bulk email verification or email list cleaning can be performed by uploading email lists on 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 simple list of emails or emails along with its associated information like, name, city etc.
File upload criteria
Following checklist will help you to prepare email list for bulk email verification on QuickEmailVerification self-service platform.
- File must be Plain Text (.txt) or Comma Separated Value (.csv) or spreadsheet (.xls, .xlsx or .ods).
- 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 file must have comma (,) as a field delimiter/separator.
- Keep all emails in same column.
- File size should not be more than 5MB. For large files, split single file into multiple smaller files. Contact Us for further assistance.
Plain Text Files
To prepare a plain text files with 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 email list from any other program or database as .csv files, it may contain other information along with emails, you can still upload such file and QuickEmailVerification will automatically fetch only emails from the file to verify.
The list must contain one email column and all emails should be placed in same column throughout the file. Header row of such files is optional and if it is found in the file, it will be ignored for processing.
If file contains additional information associated with the email like name, address, contact no, etc 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 list of emails to be verified can be uploaded too. Spreadsheet must be a single sheet having all the emails in single column with other optional fields. Supported spreadsheet extensions are .xls, .xlsx and .ods. For other spreadsheet extension, it is recommended to convert 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 single column and other optional fields (columns) and save file as Plain Text CSV (.csv).
Troubleshooting File Upload
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 file. A csv file must conform to the CSV standards and any file with invalid csv data will be rejected.
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.
File is not in acceptable format
QuickEmailVerification supports file in text format only. File other then text formats (like pdf, word documents, compressed files) should be converted to acceptable .txt, .csv or .xls files 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 content type of the file cannot be detected. You should try to open such file in 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 time, just changing the file extension by renaming it does not convert it to the target file format automatically. Recommended way to convert the file is opening file in the supported application and then save it to the desired format.
Files in the .gnm or .xlsb or other format
If you have your data in spreadsheet other than .xls or .xlsx format, you may need to create a .csv file from it. To create a CSV file from spreadsheet, open file in spreadsheet program (i.e. Microsoft Excel or OpenOffice Calc), select "Save As" from the menu and save the file as Text CSV.