-
Save Excel File as CSV"There was an error processing your list, please contact customer support for further assistance" Users attempting to upload an .xls or .xlsx file who receive this error message can often resolve the issue by saving their list as a .csv file. Saving an excel file as a .csv file can also resolve issues that cause some lists to get stuck loading. To save your list as a CSV file, open your mailing list in Excel.
-
Remove a unicode character from a listJobs with mailing lists that contain unicode characters will go into error status. Unicode characters are nonprintable. We can identify those by exporting the list as a csv and opened it in notepad++, scrolling down the list, and looking for the big white box. After that you can delete the character and save the list to reupload. You can also use Excel's CLEAN function to remove unicode characters.
-
Remove Line Breaks in ExcelUsers who find only the first column header from their list is available for selection during address mapping may have line breaks in their list. Follow these steps to remove the line breaks from your Excel file. 1. Select or Highlight the entire list (all cells) 2. Hit CTRL+H on your keyboard or Open the Find/Replace command window 3. In the Find What dialog box hit CTRL+J (it will appear blank- that is ok).