How to Display SharePoint Multi-Choice Values on Separate Lines
Question details
The user needs to format a SharePoint multi-choice column so that each selected choice appears on its own individual line rather than as a continuous comma-separated list.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Customizing SharePoint list views to improve the readability and organization of data in multi-choice columns.
- Observed behavior
- By default, SharePoint displays multi-choice values as a continuous string of comma-separated text, which can be difficult to read when there are many selections.
Ensure you have the necessary permissions to edit column formatting in your SharePoint list and verify that your target column is configured to allow multiple selections.
Apply JSON Formatting to the Multi-Choice Column
Use SharePoint's built-in column formatting feature to apply a JSON snippet that iterates through the choices and renders them in separate div elements.
SharePoint allows you to customize the display of list data using JSON. By using a forEach loop in your JSON code, you can instruct SharePoint to take the array of selected values and render each one inside its own block-level element, forcing them onto separate lines.
Navigate to your SharePoint list, click the header of the multi-choice column you want to modify, select 'Column settings', and then click 'Format this column'.
At the bottom of the formatting pane on the right side of the screen, click on 'Advanced mode' to input your custom code.
Paste the JSON code that utilizes the forEach operator to loop through the selected values. Configure it to render each item in a separate div, setting txtContent to your current choice value iterator (e.g., [$choiceIterator]).
Click 'Save' to apply the formatting. You may also need to increase the column width in your list view so that all options are easy to read.

Need a Lightweight Office Suite for Your Exported Documents? Try WPS Office
While managing complex list formatting requires SharePoint, dealing with the exported data, reports, and everyday documents is much easier with a streamlined desktop suite. WPS Office is a free, lightweight alternative to Microsoft Office that lets you effortlessly edit Word, Excel, and PowerPoint files without a subscription.

Frequently Asked Questions
Can I use this JSON formatting on a single-choice column?
The specific forEach loop is designed for multi-choice columns that contain arrays of data. For single-choice columns, you only need to format the direct text content without using an iterator loop.
Will this JSON code change my underlying SharePoint data?
No, JSON column formatting only alters the visual representation of the data in the SharePoint list view. Your underlying data remains completely unchanged.
Why is my JSON formatting not saving or displaying correctly?
Ensure that your column is strictly set to allow multiple selections. Additionally, check your JSON code for syntax errors, missing commas, or incorrect column internal names.
Does this formatting carry over when I export the SharePoint list to Excel?
No. JSON formatting only applies to the web view within SharePoint. When exported to Excel, the data will revert to its default format, typically comma-separated text.




