Free ToolNo signup · No upload · Instant

Sort Excel Online — Sort by Any Column

Upload any Excel file and sort it by up to 3 columns in ascending or descending order. Cell formatting is preserved. Works on single sheets or entire workbooks. Your file never leaves your browser.

Drop your Excel file here

or click to browse — .xlsx, .xls, .xlsm, .xlsb

100% private — your file never leaves your browser

How to Sort Excel Online

1

Upload your file

Drop your Excel file. Sheet tabs appear for multi-sheet workbooks.

2

Set sort rules

Choose a column and direction (A→Z or Z→A). Add up to 2 more tiebreaker columns.

3

Choose scope

Apply the sort to the active sheet only, or to all sheets in the workbook at once.

4

Download result

Click "Sort & Download" to get the sorted file. The original is unchanged.

Understanding Multi-Column Sorting

Multi-column sorting lets you define a hierarchy of sort rules. A common example:

  • Sort by Region (A→Z), then by Sales Amount (Z→A) — this groups all rows by region alphabetically, and within each region shows the largest sales first
  • Sort by Date (A→Z), then by Category (A→Z), then by Amount (Z→A) — chronological order with alphabetical categories and highest amounts first within each date/category group

Excel's built-in sort dialog supports this, but this tool works directly in your browser without needing Excel installed — useful for quick sorts on shared or remote machines.

This Tool vs Other Ways to Sort Excel

FeatureExcel Sort DialogSORT() FunctionThis Tool
Sort levelsUp to 64 (Excel 365)Unlimited (array formula)Up to 3 (primary, secondary, tertiary)
Preserves cell formattingYesNo — SORT returns values onlyYes — cell objects remapped directly
Sort all sheets at onceNo — one sheet per useNo — one formula per sheetYes — "All sheets" option
Result typeIn-place (modifies data)Dynamic spilled array (non-destructive)New file download (original unchanged)
Requires Excel installedYesYes (Excel 365 or 2021+)No — any browser, any OS
Undo capabilityCtrl+Z (within session)Delete formula to revertOriginal file always untouched
Works on Mac/LinuxMac: Yes. Linux: NoMac: Yes. Linux: NoYes — any modern browser

Frequently Asked Questions

Does sorting preserve cell formatting?

Yes. The tool remaps cell objects directly (not through an array conversion) so colours, fonts, borders, and number formats travel with their cells to new row positions.

How does multi-column sorting work?

Add up to 3 sort levels. The primary column sets the overall order. When two rows tie on the primary column, the secondary column is the tiebreaker. The tertiary column resolves further ties. Each can be ascending or descending independently.

How are numbers sorted vs text?

Numeric cells sort numerically (10 after 9). Text cells sort alphabetically with natural number ordering (Item 10 after Item 9, not after Item 1). Empty cells always sort to the bottom.

Can I sort multiple sheets at once?

Yes — select "All sheets" and the same sort rules are applied to every sheet in the workbook. This is useful if all sheets share the same column structure.

What is the difference between this and Excel's built-in sort?

Excel's built-in sort is great for interactive use. This tool is useful when you need to sort without opening Excel, want to automate sorting from a script workflow, or are working on a device where Excel isn't installed.

More Free Excel Tools