How to Fix SharePoint Displaying HTML Tags in Plain Text Columns
Question details
Users see raw HTML tags appearing in a SharePoint multiline column after modifying its type.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Changing a multiline text column from Enhanced Rich Text to Plain Text in a SharePoint list.
- Observed behavior
- Existing HTML tags, such as DIVs and formatting markup, do not disappear automatically and become visible as literal text within the older column entries.
Before modifying column types or running cleanup scripts, always back up your SharePoint list data or test the procedure in a non-production environment to prevent accidental data loss.
Manually Edit and Save the Affected Item
For a small number of records, testing a manual edit can force SharePoint to re-evaluate the text format and drop the HTML markup.
Sometimes simply interacting with the record after the column type has changed will force the system to strip the unsupported formatting.
Navigate to your SharePoint list, select an affected record, and click 'Edit'.
Add a space or make a small edit to the text in the affected multiline column.
Click 'Save' and check if the raw HTML tags have been removed from the item's display.
Strip Unwanted HTML Tags Using a Script
For lists with many records, run a controlled PowerShell script to clean up the existing HTML markup automatically.
Enhance Your Productivity with WPS Office
While SharePoint manages your backend lists, dealing with complex Microsoft environments can be overwhelming. Try WPS Office, a highly compatible, lightweight, and free alternative for all your document creation and team collaboration needs.
- 1. Download the installer: Visit the official WPS website and click the free download button.
- 2. Install the software: Run the setup file and follow the on-screen instructions to install WPS Office on your computer.
- 3. Open and edit seamlessly: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office documents.

Frequently Asked Questions
Why do HTML tags appear when I switch a SharePoint column to plain text?
When a column is set to Enhanced Rich Text, SharePoint stores the formatting as HTML in the database. Changing the column setting to Plain Text changes how SharePoint renders the data, but it does not proactively delete the historical HTML tags already saved in older entries.
Will new list entries also show HTML tags after I change the column settings?
No. Any new entries added after changing the column to Plain Text will be saved and displayed properly without any HTML markup. This issue strictly affects historical entries created prior to the settings change.
Can I revert the column back to Rich Text to hide the tags?
Yes. Reverting the column setting back to Enhanced Rich Text will usually cause SharePoint to render the HTML properly again, hiding the literal tags. However, if your workflow strictly requires plain text, you will need to clean the existing data using a script.





