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 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.
Remove any special characters from your headings. Hope that helps
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (