I can import a spreadsheet successfully, but the import seems to randomly choose which column will be the title section in SharePoint. I have 4 columns, Last Name, First Name, Email address, Apartment Number. I want Last Name to be the title section of the SharePoint List but cannot seem to find t a setting to make this happen. The import makes the email address or Apartment number the title section of the list.

Go to List view then under colums section order last name column top most (i.e 1) So when you export list to excel Last name will be in the titleRegards, Pratik Vyas | SharePoint Consultant |