SharePoint Document Issues

How to Fix Extra Code in Microsoft Lists JSON Formatting

John WilsonJohn Wilson Nov 3, 2026 869 views

Question details

The user needs to resolve an issue where extra or unexpected raw code appears in Microsoft Lists due to incorrect JSON formatting.

How to Fix Extra Code in Microsoft Lists JSON Formatting
Product
Microsoft Lists
Device & OS
not provided
Scenario
Customizing column formats, specifically when attempting to adjust column heights using JSON code.
Observed behavior
The column displays raw JSON code or unexpected text output instead of rendering the intended visual formatting.
Before you start

Ensure you have 'Edit' permissions for the Microsoft List, and temporarily copy your current JSON code into a plain text editor to prevent data loss while troubleshooting.

Solution 1Recommended

Verify and Correct the JSON Syntax

Checking your JSON structure against Microsoft's official guidelines is the most reliable way to clear unexpected code display.

When JSON is entered incorrectly, Microsoft Lists cannot parse the styling rules, resulting in raw code bleeding into the column view. Structural mistakes like missing commas, unclosed brackets, or unsupported properties are the most common culprits.

1
Access the Formatting Pane

Open the Microsoft List, click the header of the column you want to fix, select 'Column settings' from the dropdown menu, and choose 'Format this column'.

2
Open Advanced Mode

At the bottom of the formatting pane on the right side of the screen, click 'Advanced mode' to view your current raw JSON code.

3
Identify Syntax Errors

Review your code for standard JSON syntax errors. Ensure all keys and string values are enclosed in double quotes, check for missing or trailing commas, and verify that all braces and brackets are properly closed.

4
Test and Save

Click 'Preview' to test your corrections. Once the extra code disappears and the intended style (such as column height) renders correctly, click 'Save' to apply the changes.

Verify and Correct the JSON Syntax
Reference Official Schema: Always compare your custom schema against the official Microsoft JSON column formatting documentation to ensure you are using supported properties.
Free Microsoft Office alternative

Manage Your List Data Easily with WPS Office

While Microsoft Lists requires complex JSON for advanced column formatting, exporting your lists to a robust spreadsheet application can significantly simplify data visualization. WPS Office is a free, lightweight alternative that lets you format, filter, and style your exported list data visually, entirely without coding.

Analyze and format exported Microsoft Lists data visually without writing complex JSON code.Fully compatible with Microsoft Excel (.xlsx) formats seamlessly.Lightweight software with a familiar, easy-to-navigate interface.Built-in advanced conditional formatting to highlight important list data effortlessly.
microsoft office alternative - wps office

Frequently Asked Questions

Why is my Microsoft List column showing raw JSON code instead of formatting?

This happens when the JSON code contains syntax errors, such as missing brackets, unquoted strings, or invalid property names. When the system fails to parse the invalid code, it defaults to displaying it as plain text in the column.

How do I correctly adjust the column height using JSON in Microsoft Lists?

You can adjust the column height by nesting a 'style' object within your JSON and defining the 'height' or 'min-height' properties. Ensure your values are properly quoted strings (e.g., '100px') and placed within a valid HTML element definition like a 'div'.

Can I revert my column formatting to default if the JSON is broken?

Yes. Open the column header menu, select 'Column settings', and click 'Format this column'. In the Advanced mode pane, simply delete all the JSON code and click 'Save'. This will immediately remove all custom formatting and restore the default list view.

Is there a tool to validate my JSON code before pasting it into Lists?

Yes. You can use any free online JSON validator or an advanced text editor like VS Code. Pasting your code into these tools will automatically highlight syntax errors, missing commas, or unclosed brackets before you apply it to your list.