Free calculator
Least to greatest calculator
Paste numbers from Google Sheets, Excel, or plain text and sort them smallest to largest (least to greatest) or flip to greatest to least. Decimals respect common . vs , conventions; duplicates keep a stable order. The Google Sheets & Excel block has SORT patterns—this page is numeric lists only (see FAQ for fractions).
When to use this calculator
Fast ordering for homework checks, QA lists, and spreadsheet prep—without opening a stats workbook.
- Sort a column you pasted from Sheets or Excel before you re-import or compare.
- Flip between ascending and descending to match worksheet directions (“greatest to least”).
- Confirm how negatives and decimals order relative to zero.
- Keep duplicate values and see that ties do not jump around between runs.
Least to greatest means ascending numeric order: smaller numbers first, larger numbers last. Greatest to least is the reverse (descending). After you paste, the tool reads each token as a plain number (decimals and negatives allowed), then sorts.
Read the list
We split lines and common separators (spaces, tabs, commas, semicolons) the same way as the mean / median / mode and standard deviation calculators. Entries that are not numbers are skipped with a warning.
Sort by numeric value
Ordering uses numeric comparison, not text sorting, so -2 comes before -1, and 2.1 sits between 2 and 3.
Stable ties
When two numbers are equal, their relative order matches your original input order—handy when a duplicate row carries meaning beyond the number itself.
This page does not parse fraction strings like 1/2 or 3 1/4 in v1—convert those to decimals first, or use a dedicated fraction ordering tool if your assignment requires exact rational steps.
For mean, median, mode, and range on the same list, open the mean median mode range calculator.
For spread (variance and standard deviation), open the standard deviation calculator.
For weighted averages, open the average calculator.
FAQs cover fractions, SORT in Sheets / Excel, and how this differs from statistics calculators on the same site.
Google Sheets & Excel
When the data already lives in a sheet, SORT is the native way to reorder a column by value without helper columns. Replace A1:A99 with your range.
=SORT(A1:A99,1,TRUE)Google Sheets: third argument TRUE means ascending on column 1 of the spilled array. In Excel 365, use =SORT(A1:A99,,1) for ascending by the first column.
=SORT(A1:A99,1,FALSE)Google Sheets: FALSE is descending. In Excel 365, =SORT(A1:A99,,-1) sorts descending by the first column.
Frequently asked questions
What does “least to greatest” mean?
It means ascending order: list numbers from the smallest value to the largest. The opposite direction is greatest to least (descending).
How are negative numbers ordered?
On the number line, more negative values are smaller. So -10 sorts before -1, and both come before 0 in least-to-greatest order.
What happens to duplicate values?
Every copy is kept. Equal values stay in the same relative order they had in your input (stable sort), so nothing “jumps” arbitrarily between ties.
Can I sort greatest to least?
Yes—use Greatest to least above. It is the same list sorted descending by numeric value.
Is this the same as the mean / median / mode calculator?
No. This tool only reorders your numbers. The mean median mode range calculator computes summary statistics on the same style of pasted list.
Can I type fractions like 1/2 or 3/4?
Not in this v1. Enter decimals (for example 0.5 for one half) or simplify fractions elsewhere first. Dedicated fraction ordering tools compare rationals with common denominators—this page stays a fast numeric sorter.
How do I sort a column in Google Sheets?
Select the range and use Data → Sort range, or enter =SORT(A1:A99,1,TRUE) in a cell to spill a sorted copy. The spreadsheet cards on this page show ascending and descending examples.
What is the German Excel name for SORT?
In Microsoft 365 with German function names, the dynamic sort function is typically SORTIEREN—use Formulas → Insert function to confirm your build and argument order.
What is the French Excel name for SORT?
In Microsoft 365 with French names, look for TRIER (sort dynamic array)—verify parentheses and argument order on your install.
How should I paste from a spreadsheet?
Copy a column or row and paste into the box. Tabs, newlines, spaces, semicolons, and many comma-separated lists work the same way as our other list calculators.
Can I use this for homework?
As a check only. Your teacher may require hand work, fraction form, or a specific method—this page does not know your rubric.