How to resolve “The column heading cannot be empty.” when importing CSV to Dynamics CRM

You are importing a CSV content to your Dynamics CRM instance, and receive the following error, “The column heading cannot be empty.”

Error The column heading cannot be empty

Here’s how to resolve this issue:

  1. Open the source CSV file with Notepad, and check for a comma at the end of each row, which indicates an “invisible” column, normally as a result of manipulating the spreadsheet in Excel and exporting as CSV later on.Empty Column
  2. Now, open the CSV with Microsoft Excel. Remove the blank column by selecting the furthest right empty columns and deleting them, and then re-save the CSV. Check with Notepad again to make sure the comma at the end of each row has now gone.
  3. Retry the import with the updated CSV file.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s