i've found a migraine trigger

Repairing the Contacts Spreadsheet

This should be done every time before publishing

• Copy the new REVSHARE_CONTACTS_<DATE>.xls to a Windows system

• Open the file in Excel

• Save file as a Tab Delimited (*.txt) format (answer "yes" to losing all the formatting- that's the whole point of doing this)

• Close Excel

• Re-open Excel

• Import/open the  REVSHARE_CONTACTS_<DATE>.txt file

• Save the file as an excel 97-2003 workbook.

This will create a file that should always validate and import correctly