Formatting Issues

How to Display a Different SharePoint Column Label Using JSON Formatting

Natalie Taylor Oct 10, 2026 869 views

Question details

The user wants to change the displayed label of a SharePoint column using JSON formatting without altering the underlying column name or data.

How to Display a Different SharePoint Column Label Using JSON Formatting

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Customizing SharePoint list views to display user-friendly custom labels for specific columns.
Observed behavior: The user needs the column to visually show a custom label such as "Department 01" while retaining the original internal column name and underlying values.

Before you start

Ensure you have the necessary edit permissions for the SharePoint list and familiarize yourself with basic JSON syntax to avoid breaking the view display.

Solution 1Recommended

Apply JSON Formatting to Override the Displayed Text

Use a custom JSON schema directly in the SharePoint column settings to override the displayed text while keeping the underlying data intact.

SharePoint JSON column formatting allows you to control how a field is rendered in the browser. By applying a specific schema, you can substitute the displayed text with a custom string or dynamically generate labels without affecting the actual data stored in the list.

Access Column Settings

Navigate to your SharePoint list, click on the column header you want to customize, and select 'Column settings' from the dropdown menu.

Open the Formatting Pane

Click on 'Format this column'. A formatting pane will slide out on the right side of your screen.

Switch to Advanced Mode

At the bottom of the formatting pane, click on 'Advanced mode' to reveal the text box where you can input custom code.

Paste JSON Code and Save

Paste your custom JSON schema (defining the 'txtContent' property to output your custom label) into the text box and click 'Save' to apply the changes.

Apply JSON Formatting to Override the Displayed Text

Microsoft Community Support: For highly complex conditional formatting or custom field behavior inquiries, it is highly recommended to post your specific requirements in the Microsoft Q&A Community using the SharePoint tag for specialist guidance.

Free Microsoft Office alternative

Seamlessly Manage Your Documents with WPS Office

While SharePoint handles your team's intranet and lists, you need a robust, reliable suite for your actual documents. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for creating, editing, and sharing documents with a familiar UI for seamless migration.

1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
3. Open Your Files: Launch WPS Office and instantly open your existing Microsoft Office documents without worrying about formatting issues.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx).Helps format and organize your local spreadsheet data before importing to SharePoint lists.Provides a lightweight footprint for fast installation and reliable performance.Familiar tabbed user interface ensures a seamless migration with zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Does changing the column label with JSON alter the actual SharePoint data?

No. JSON formatting only changes how the data is rendered and displayed in the browser. The underlying column name and the stored list data remain completely unchanged.

Can I use conditional logic in SharePoint JSON formatting?

Yes. You can use Excel-style expressions in your JSON schema to display different labels or apply different styles based on the values in the current field or other fields in the row.

Where can I find examples of SharePoint JSON formatting?

Microsoft provides an extensive GitHub repository (sp-dev-list-formatting) and official documentation containing numerous templates and examples for both column and view formatting.

Why isn't my JSON formatting saving in SharePoint?

This typically happens due to a syntax error in the JSON code, such as a missing comma, unclosed bracket, or incorrect quotation mark. Ensure your JSON is valid before saving, and verify you have the correct list editing permissions.

Document & File Issues