Smart number sorting
Plain text sorting puts “100” before “9”. This tool compares numbers by value, including negatives, decimals, thousands separators, currency symbols and percentages, so 9 comes before 10 and $1,200 after $950. Text is sorted alphabetically regardless of case, with numbers inside text in natural order, so “Item 2” comes before “Item 10”.
Sorting dates
Dates in YYYY-MM-DD format sort correctly. If your dates look like 05/01/2024, also turn on Standardize dates: it is applied before sorting, so the order is right even when the file mixes formats.
Blank values
Rows with an empty sort value always go to the bottom, whichever direction you choose, so they never push the rows you care about out of view.