How to Fix Extra Code in Microsoft Lists JSON Formatting
Question details
The user needs to resolve an issue where extra or unexpected raw code appears in Microsoft Lists due to incorrect 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.
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.
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.
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'.
At the bottom of the formatting pane on the right side of the screen, click 'Advanced mode' to view your current raw JSON code.
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.
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.

Consult the SharePoint Tech Community
If your JSON syntax appears structurally valid but still fails to render properly, community experts can help identify nuanced platform issues.
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.

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.




