SharePoint Document Issues

Fix SharePoint List Showing Only Document Names Instead of Columns

Maira Mehtab Sep 24, 2026 869 views

Question details

The user needs to resolve an issue where a SharePoint list web part on a SharePoint page only displays document names, even though other columns (such as title, description, and date) appear correctly when viewed directly in Microsoft Lists.

Product: SharePoint and Microsoft Lists
Device & OS: not provided
Scenario: Displaying a configured Microsoft List on a modern SharePoint page using a web part.
Observed behavior: The SharePoint page renders only the document names, completely omitting the additional columns that are verified to exist and display correctly in Microsoft Lists.

Before you start

Before proceeding, ensure you have 'Edit' permissions for both the SharePoint site page and the underlying SharePoint list so you can modify web part properties and list views.

Solution 1

Check the Web Part Configuration and List View

Ensure that the list web part embedded on the SharePoint page is configured to use the correct view that includes all your desired columns.

SharePoint web parts often default to a compact view or a different default view than what you see when opening the list directly in Microsoft Lists. Updating the web part properties can quickly force the missing columns to appear.

Edit the SharePoint page

Navigate to the SharePoint page where the list is displayed, and click the 'Edit' button in the top right corner.

Access web part properties

Click anywhere on the List web part to select it, then click the 'Edit web part' (pencil) icon that appears on the left side of the web part.

Select the correct view

In the property pane on the right, locate the 'View' dropdown menu. Change it from the current selection to the specific view that contains your title, description, and date columns.

Republish the page

Click 'Apply' if prompted, then click the 'Republish' button at the top of the page to save your changes and verify if the columns now display.

Solution 2Recommended

Recreate the List Using an Excel Export

If view settings are correct but the list still malfunctions on the page, exporting the healthy data to Excel and generating a replacement list can resolve underlying configuration corruption.

Free Microsoft Office alternative

Manage Your Exported SharePoint Lists with WPS Office

When exporting SharePoint lists or Microsoft Lists to troubleshoot view errors, having a reliable spreadsheet tool to inspect and format your data is essential. WPS Office is a free, lightweight, and highly compatible alternative to Microsoft Office that makes handling exported .xlsx or .csv files incredibly easy.

1. Download and install: Get WPS Office Free from the official website and install it on your computer.
2. Open your exported list: Launch WPS Spreadsheets and open the Excel file you exported from Microsoft Lists.
3. Review and edit data: Use WPS Spreadsheets to inspect your columns (Title, Description, Date) and clean up any formatting issues before creating your new SharePoint list.

Fully compatible with Microsoft Excel formats (.xlsx, .csv) used in SharePoint exports.Lightweight design ensures fast loading even for massive list data exports.Familiar ribbon interface allows you to navigate and edit without any learning curve.Free built-in data filtering and formatting tools to perfectly prepare your list before importing it back.

Frequently Asked Questions

Why does my SharePoint list web part look different from Microsoft Lists?

SharePoint list web parts often default to a specific 'Compact' view or a different default view altogether. Even if your Microsoft Lists interface shows all columns, the web part on the SharePoint page must be manually configured to point to the exact view that includes your desired columns.

Can I force a SharePoint list to show all columns on a page?

Yes. You can edit the specific view in your SharePoint list settings, check the boxes for all the columns you want to display (like Title, Description, and Date), save the view, and then ensure that this updated view is selected in the page's web part properties.

What happens to my data when I export a SharePoint list to Excel?

Exporting a list to Excel simply downloads a local copy of the data in its current state. It does not delete, modify, or harm your original SharePoint data, making it a safe method for creating backups or migrating corrupted lists into fresh ones.

Document & File Issues