Troubleshooting Bulk CSV Imports

Resolving CSV Import Errors

When importing contacts through CSV files in your CRM, you might encounter specific error codes that prevent successful data uploads. This guide helps you identify and resolve these issues to ensure clean, efficient bulk imports.

Common Import Errors and Solutions

Below is a list of error codes you may encounter during CSV imports, along with their meanings and recommended fixes:

• Error 1001: Unknown Error
  The CRM cannot process your file due to an unspecified issue. Verify that your file meets all requirements, clear your browser cache, or try a different browser before re-importing.
• Error 1002: Multiple Owners Found
  Your file contains an owner value that matches more than one user in your account. Replace owner names with their email addresses in your CSV file and re-import, or manually update the owner property for affected records.
• Error 1003: Invalid Sheet Count
  Your file contains multiple sheets. Remove any extra sheets and ensure only one sheet remains before re-importing.
• Error 1004: Invalid Required Property
  A required field in your file contains an invalid value. Check the format requirements for the property, correct the value, and re-import.
• Error 1005: Invalid Enumeration Option
  A value in your file does not match existing options for dropdown, multi-select, radio, or checkbox properties. Update the value to match an existing option or add it as a custom option in your CRM before re-importing.
• Error 1006: Invalid Contact ID
  You selected to update existing records using Contact IDs, but the IDs in your file do not match any in the CRM. Ensure your Contact IDs are correct by exporting existing records, or do not select the update option if you are not associating with existing objects.
• Error 1007: File Not Found
  The selected file could not be located. Confirm the file is saved on your computer and is the correct file type, then re-upload.
• Error 1008: Failed Email Validation
  An email address in your file does not follow standard formatting (e.g., missing @ or .com). Correct the email format and re-import.
• Error 1009: Empty Unique Property Value
  A row lacks a value for its unique identifier (primary column). Ensure all rows have values for the primary column and re-import.
• Error 1010: Duplicate Unique Value in CRM
  The same primary column value exists against multiple records in the CRM, potentially creating duplicates. Choose a different primary column or correct mistakes before re-importing.
• Error 1011: Duplicate Unique Value in File
  The same unique value appears multiple times in your file, which may create duplicates. Select a different unique column or fix the duplicates before re-importing.

Pre-Import Checklist

To avoid common errors, follow these best practices before importing:

• Use only one sheet in your CSV file.
• Fill all required fields with properly formatted data.
• Format emails, phone numbers, and dates correctly.
• Ensure each row has a unique Contact ID if used.
• Match enumeration values (e.g., dropdown options) exactly.
• Use valid user emails for the Owner column.
• Select a reliable primary column, such as Email or Contact ID.

By addressing these issues, you can achieve smooth, error-free bulk imports and maintain clean contact data in your CRM.