Get in Touch

Need a hand? We've got you covered.

Knowledge Base Home aero-right Contact Lists Importing / Exporting aero-right I‘m trying to upload my lists but I seem to be having problems. What are some of the possible reasons?

I‘m trying to upload my lists but I seem to be having problems. What are some of the possible reasons?

Contact Lists Importing / Exporting Updated on March 21, 2019

Following are some of the most common problems associated with uploading lists:

Wrong File Type

Benchmark Email can only accept the following file types: .csv (Comma Separated Value), .xls or .xlsx (Microsoft Excel), .txt (text files). If your file is not one of these types, you will not be able to upload it to your Benchmark Email account. Click Here to learn more about list formats accepted by Benchmark.

File Type and Extension Mismatch

When files are saved and reformatted, the file extension can sometimes not match the type of file it names. This can be caused when opening .csv files in Excel and re-saving. Excel will allow you to specify a ‘Save As type’ for the file. This type must match the file extension or an error will occur. For example, if you are saving a .xls file but the extension is .csv, an error will occur. Pay close attention to the ‘Save As type’ when saving files to avoid this problem.

Invalid Formatting

Invalid formatting examples can be found below:

  • All files must contain email addresses. If no valid email address is found, that line cannot be imported.
  • Each email address cannot exceed 80 characters.
  • Each row can only have one email address per line.
  • Your file must contain column headings. In the top row of your file, clearly label each column.
  • If you need column heading ideas, here are some standard headings available in Benchmark Email: Email Address, First Name, Last Name, Middle Name
  • In most cases, columns will already exist in files types such as .xls. If your file type does not, you can indicate separate columns by using a comma ( , ), tab, or semicolon ( ; ).
  • Any empty or missing value in your file will be uploaded as a blank value in the corresponding column.
  • If the same email address is imported twice, the latest import will update your contact’s existing information. If the contact cannot be matched, their details will not be updated. (Tip: Updates to contact details are cumulative. For example, you can update your contacts’ “First Name” values by uploading one file and their “Last Name” values with another.)
Invalid Characters

Sometimes, invalid or incorrectly encoded characters can be part of a file. You may not be able to tell that your file has invalid characters just by looking at it, but if the Benchmark Email system comes across an invalid character in your file, uploading will not continue. If the character is found in the middle of your document, only a portion of your contacts may be uploaded. If you notice this phenomenon, find the email address that seems to be the issue and try retyping it in your file editor of choice. This can eliminate invalid characters so your file will upload properly.

Examples can include pilcrows, page breaks, null characters, etc. These are also known as non-printable characters.

File Too Big

Since the file transfer is performed using HTTP (HyperText Transfer Protocol), we cannot upload files larger than 27 MB. If your file is larger than 27 MB, the transfer will timeout and not complete properly. If you have a very large list, you should break the main list into smaller sections for easier uploading.

If you are experiencing an issue that is not described here, please contact our Support Team at support@benchmarkemail.com.

Did this answer your questions?
1 7

Can't find what you're looking for?

Submit a Ticket

view ticket history