SharePoint Document Issues

How to Fix SharePoint Displaying HTML Tags in Plain Text Columns

Chanuka GeekiyanageChanuka Geekiyanage Oct 29, 2026 871 views

Question details

Users see raw HTML tags appearing in a SharePoint multiline column after modifying its type.

How to Fix SharePoint Displaying HTML Tags in Plain Text Columns
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 you start

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.

Solution 1

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.

1
Open the list item

Navigate to your SharePoint list, select an affected record, and click 'Edit'.

2
Make a minor change

Add a space or make a small edit to the text in the affected multiline column.

3
Save and verify

Click 'Save' and check if the raw HTML tags have been removed from the item's display.

Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS website and click the free download button.
  2. 2. Install the software: Run the setup file and follow the on-screen instructions to install WPS Office on your computer.
  3. 3. Open and edit seamlessly: Launch WPS Office to instantly open, edit, and save your existing Microsoft Office documents.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Lightweight installation ensures fast loading times and smooth editing without bogging down your device.Built-in robust PDF editing, conversion, and signature tools out of the box.Familiar user interface requires zero learning curve when switching from Microsoft Office.
microsoft office alternative - wps office

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.