• [Fatal] Entirely blank first row in the Excel worksheet (no field names found).
• [Fatal] No names in the first row of the Excel worksheet match any of the collection's field names.
• [Severe] Some columns in the Excel worksheet have no field name (blank row 1 value). These columns will be skipped during the import.
• [Moderate] There are some columns in the Excel worksheet with duplicate field names (in row 1). Recollector will only import data from the first of multiple same-named columns.
• [Moderate] There are columns in the Excel worksheet with names that don't match the names of your collection's fields. These columns will be skipped during import.
• [Minor] Not all rows in the Excel worksheet have the same number of columns. Rows will be truncated or padded (with empty values) as necessary, to match the number of fields identified in the field name row (row 1) of the worksheet.
• [Minor] Some of the collection fields do not have corresponding column names present in the Excel worksheet. These fields will be given empty values during the import of new records.
• [Minor] The Excel worksheet contains a column matching the collection's ID # field, and some of the values match existing ID # values in your collection. You will be given the opportunity to decide whether to skip, merge, or add new records for the matching-ID # value records.

If Recollector sees that the Excel worksheet has records with ID # values that duplicate the ID # of existing collection records, the program will ask you how you want to proceed. In particular, it will ask how to handle records in the Excel worksheet whose ID # values match the ID # value of an existing record. For these matching records, your choices are as follows:

• Skip over any matching Excel worksheet records.
• Merge the Excel worksheet record with the matching collection record, blanking out any non-imported fields. This is equivalent to completely replacing the existing record with the imported record.
• Merge the Excel worksheet record with the matching collection record, but leave any non-imported fields unchanged. This is equivalent to a selective update of the collection record, updating only the imported data fields.
• Import any Excel worksheet record as a new data record, even though this will result in the collection now having more than one record with the same ID # value.