When uploading contacts with a CSV file the error "missing last_name in row2" occurs - why? | Experience Community
Skip to main content
JoseS
Administrator
1 year ago
Solved

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

  • Feb 1, 2019 3:43 PM UTC
  • 3 replies
  • 92 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!

Best answer by KendraR

Hi @yves! It looks like you were able to reach out to our Support Team and determine that it was an Excel formatting issue! 😀
View original

    3 replies

    Level 5 ●●●●●
    Forum|alt.badge.img+19
    • Kate
    • Level 5 ●●●●●
    • Feb 1, 2019 4:10 PM UTC
    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?
    KendraR
    Qualtrics Employee
    Forum|alt.badge.img+11
    • KendraR
    • Qualtrics Employee
    • Answer
    • Feb 14, 2019 6:00 PM UTC
    Hi @yves! It looks like you were able to reach out to our Support Team and determine that it was an Excel formatting issue! 😀
      Forum|alt.badge.img+1
      • abthin
      • Oct 14, 2021 6:38 PM UTC

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

      Terms & ConditionsAccessibility statement