web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Importing Error "...
Microsoft Dynamics CRM (Archived)

Importing Error "Column Headings Cannot Be Empty"

(0) ShareShare
ReportReport
Posted on by CatherineH 55

I'm using Dynamics CRM 2013 with a Mac. When trying to import data in a csv file to Leads, I'm getting the message "Column Headings Cannot Be Empty." All of the columns have headings. I've tried removing spaces in the headings and replacing with underscores, but still get the same error message.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    Hi,

    Check that you have the same number of values in your data as you do columns. Also check that you don't have any values with commas in that are not text qualified. You can do this by loading the csv in to Excel and check that there are no values in a column that doesn't have a header value.

    To text qualify a value with a comma in it you simply wrap it in double quotes (").

    Hope this helps,

    Scott

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello,

    Your spreadsheet may have a column field with a delimiter character within the cell value which would cause a row of data to not match the header columns. Double check your spread sheet, also try importing a subset of data first, maybe 10 rows in a separate file.

    We can also try the below steps :

    1) Open the csv in excel.

    2) Copy all of the table to import.

    3) Create another sheet in excel

    4) paste special with values only in new sheet

    crm2011andsilverlight.blogspot.in/.../the-column-heading-cannot-be-empty.html

    Thank You

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Remove any special characters from your headings.  Hope that helps

  • Vachay Profile Picture
    Vachay on at

    After checking for commas or other delimiter characters on the header if you don't find any try and resave as CSV and retry.

  • Suggested answer
    mdanish Profile Picture
    mdanish 5 on at

    I found that '/', '(', and ')' were triggering this error in my import file, even though only commas were selected as the delimiter. I had a column named Net Dr/(Cr) from some data I get from our Accounting department, and when I renamed it to Net_Cost, I was able to import it without getting this error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans