Fix a SharePoint List Showing an Item ID Instead of the Title
Question details
The user wants a SharePoint list to show item titles instead of an ID-like value.

- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- An older task list previously had two Title columns, and one was hidden.
- Observed behavior
- The list displays a value such as 1124_.000 instead of the expected title.
Check that you have permission to edit the list view and access List Settings. Identify an affected item and its expected title so you can compare the available columns.
Check the Title Columns and Update the List View
Use this approach when a list has multiple title-related columns or a hidden column.
Open the affected list, select Settings > List settings, and inspect the Columns section for Title and any similarly named custom columns.
Open an affected item and select Edit. Compare the values in the available title-related fields with the title you expect to see.
Return to the list, open the current view menu, and choose Edit current view. Select the column containing the expected title and clear unwanted title-related columns, then save the view.
Return to the list and confirm that the affected item displays its title. If a linked title column is needed, test the available Title linked to item option in the view settings.

Test a New View or List
Use a test view or list to isolate a problem that may be specific to an older list.
Work With Exported SharePoint List Data in WPS Office
WPS Office is a free, lightweight alternative for reviewing and editing exported list data. Its familiar spreadsheet interface and Microsoft Office format compatibility make it easy to move between tools. It does not fix SharePoint list views.

Frequently Asked Questions
Why does my SharePoint list show an ID instead of a title?
The view may be showing a different title-related column from the one containing the expected value. Check Settings > List settings > Columns, then compare the fields on an affected item.
How do I show the correct Title column in a list view?
Open the list's current view menu and choose Edit current view. Select the column containing the expected title, clear unwanted columns, and save the view.
Can I add a linked Title column without keeping two title columns visible?
In the view settings, select the available Title linked to item column and clear the other title-related column. Check an item afterward, because the two columns may contain different values.
What if the problem only happens in an older list?
Create a new view in the affected list and a blank test list with comparable columns. If the new list works but the old one does not, compare their settings or contact a SharePoint administrator.




