How to Sort a Microsoft List by Multiple Columns
Question details
The user wants to organize list data by sorting it across multiple columns simultaneously, such as sorting by date, then time, and then category.

- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Organizing and viewing complex dataset items by applying multiple primary and secondary sorting criteria for better data analysis.
- Observed behavior
- Microsoft Lists only allows sorting by one column directly in the modern list view, and is hard-capped at a maximum of two columns within the standard view List Settings. It lacks native capability to sort by three or more columns.
Identify the two most critical data points in your list, as Microsoft Lists restricts native multi-column sorting to a maximum of two columns.
Configure Sorting by Two Columns Using List Settings
Access the backend list settings to create or modify a standard view, which allows you to define a primary and a secondary sorting column.
While clicking a column header in the modern list view only applies a single-column sort, you can force the list to sort by two variables by editing the underlying view settings.
Open your Microsoft List and click on the gear icon (Settings) in the top right corner, then select 'List settings' from the dropdown menu.
Scroll down to the bottom of the settings page to the 'Views' section. Click on the name of your current view (e.g., 'All Items') to edit it, or click 'Create view' to make a new one.
Locate the 'Sort' section on the view configuration page. Under 'First sort by the column', select your primary data column from the dropdown list and choose whether to sort it in ascending or descending order.
Immediately below, under 'Then sort by the column', select your secondary data column from the dropdown menu and set its sorting order.
Scroll to either the very top or bottom of the page and click 'OK' to save your changes. Your list will now load with the two-column sort applied.

Use 'Group By' as a Sorting Alternative
If you need more organizational depth than the two-column sort provides, use metadata grouping to categorize your list visually.
Overcome Sorting Restrictions with WPS Spreadsheet
Microsoft Lists restricts your data sorting to just two columns. If you frequently need to organize data by three or more columns (e.g., Date, then Time, then Status), exporting your list to WPS Spreadsheet provides a completely free, unrestricted environment for complex multi-level data analysis.
- 1. Export Your List: In Microsoft Lists, click 'Export' and choose 'Export to CSV' or 'Export to Excel'.
- 2. Open in WPS Spreadsheet: Launch WPS Office, open your downloaded file, select all data, and click Data > Sort to add as many sorting columns as you need.

Frequently Asked Questions
Can I natively sort a Microsoft List by three or more columns?
No, Microsoft Lists does not offer native support for sorting by three or more columns. You are restricted to sorting a maximum of two columns through the List Settings menu.
Why does clicking column headers only sort one column at a time?
The modern list view interface is designed for quick, single-column sorting overrides. To apply a permanent sort involving two columns, you must configure it within the backend List Settings under the standard view options.
How can I achieve advanced sorting if Microsoft Lists doesn't support it?
If your project requires advanced data organization, you can use the 'Export to Excel/CSV' feature from the Microsoft Lists top menu, then open the file in a dedicated spreadsheet tool like WPS Spreadsheet or Excel to apply unlimited Custom Sort levels.




