How to use this office tool
- Upload a workbook and enter the primary column number.
- Choose ascending or descending order.
- Sort, review the first rows, and download the XLSX result.
#080 · Sort Filter & Search Tool
Sort Excel by Multiple Columns
Sort an Excel worksheet by two columns with a stable browser-based sort. Choose the primary column, direction, and header row, then download a new copy.
Office File Tool
Local spreadsheetrow
rows
Ad space
What this tool does
Sorts data rows by the chosen primary column and then the next column as a tie-breaker. The header row stays above the sorted records.
Primary column + adjacent secondary column + direction → stable sorted XLSX worksheet
Text comparisons use the browser locale with numeric-aware ordering. Excel may use different locale or custom-list rules.
Supported formats
Reads XLSX, XLS, CSV, and TSV and writes a new XLSX workbook.
| Input | XLSX, XLS, CSV, TSV as applicable |
|---|---|
| Processing | Local browser session |
| Output | New XLSX, TSV, XML, or HTML file |
Tips for better results
- Confirm the header row before sorting.
- Standardize mixed numbers and text in the sort columns.
- Use a unique secondary column when deterministic order matters.
FAQ
How does multi-column sorting work here?
The selected column is the primary key and the column immediately to its right is used when primary values are equal.
Can I sort numbers stored as text?
Numeric-looking strings are compared with numeric-aware locale rules, but mixed types should still be cleaned for predictable results.
Does the header row move during sorting?
No. Rows through the selected header row stay in place and only the following data records are sorted.
Is the sort stable when both keys match?
Yes. Records with equal primary and secondary keys retain their original relative order.
Does this change the original file?
No. It creates a separate XLSX download and does not overwrite the uploaded spreadsheet.
Related office tools
Processing notes
| Privacy | Files stay in this browser session |
|---|---|
| Preview | Limited rows for responsive display |
| Source | The original file is not overwritten |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all