When importing a file for email validation, it needs to have the following properties:
Email addresses in a single column
Only one email per row in the email column
Saved as a .csv file where the comma character (,) typically separates each field of text
Your file may contain other data (such as phone number, address, ect) as long as the emails are secluded to one column only - and this column contains only email data.
Your email column must be within the first 10 columns listed in the file.
All files should be saved in the correct file format to ensure a successful upload to DataValidation. To export your data to an accepted file format, use the Save As or Export commands while in your spreadsheet.
The file formats we accept:
If you received an error message when uploading your list, you need to save your file with UTF-8 encoding and re-upload your file. UTF-16 is not currently supported.