When uploading contacts with a CSV file the error "missing last_name in row2" occurs - why? | XM Community
Solved

When uploading contacts with a CSV file the error "missing last_name in row2" occurs - why?

  • 1 February 2019
  • 3 replies
  • 14 views

I already uploaded 500 contacts that had the same structure in the CSV and it worked perfectly fine. I am using Mozilla Firexfox as browser, a MacBook and Excel for mac for creating the CSV. Any help is appreciated!
icon

Best answer by KendraR 14 February 2019, 19:00

View original

3 replies

Userlevel 7
Badge +19
It means you didn't name the column exactly "Last Name". You maybe called it "surname" or failed to titled it or something. Just update the spreadsheet file and re-load the list! 🙂

They used to allow you to select the right field from a drop down. I want that feature back. It's really annoying to have to re-open the spreadsheet every time.

Edit: Sorry that's not right. Do you have an empty cell in row 2?
Userlevel 6
Badge +11
Hi @yves! It looks like you were able to reach out to our Support Team and determine that it was an Excel formatting issue! 😀
Badge +1

i am having the same issue. What was the resolution after you reached support Team?

Leave a Reply