Example Data Table
This table shows how comma-separated rows are interpreted when column two is selected as the default sort key.
Formula Used
The calculator extracts a sort key from each row. If the selected column is c, each row receives K = row[c]. The cleaned key becomes N(K) after trimming, type conversion, and case rules.
The final ordered view is calculated as SortedRows = argsort(blankRank, N(K), originalIndex). The blank rank handles empty keys. The original index keeps tie order stable when that option is enabled.
For numeric mode, keys are compared as decimal values. For date mode, keys are compared as timestamps. For text mode, keys are compared with natural alphabetical ordering.
How to Use This Calculator
- Paste one data record on each line.
- Select the column separator used inside each row.
- Enter the column number that should control the default view.
- Choose a data type or leave auto detection enabled.
- Select ascending or descending order.
- Choose how blank keys and duplicate keys should be handled.
- Press the sort button and review the result above the form.
- Download the sorted view as CSV or PDF when needed.
Why Default Sorting Matters
A calculation view is useful only when readers can understand it fast. Raw data often arrives in mixed order. Some rows may include blank values. Other rows may repeat the same key. A default sort rule gives that data a predictable structure before decisions are made.
Cleaner Review Process
This tool helps you build a clean review layer from plain pasted data. You can sort product scores, task dates, invoice totals, ranking labels, or audit rows. The selected column becomes the main key. The calculator then converts that key into the correct comparison type.
Smart Type Detection
Auto detection saves time when the data is simple. Numeric values are compared as numbers, not characters. Dates are compared by their real time order. Text values use natural sorting, so labels with digits feel more human. You may also force a type when your input has mixed formats.
Better Control Over Messy Rows
Blank values can hide problems in reports. This calculator lets you move blanks first, move them last, or remove them. Duplicate key removal is useful when only the first matching record should remain. Stable sorting preserves the original order when two keys are equal.
Useful Output Metrics
The result view does more than list rows. It reports input count, output count, blank count, and unique keys. Numeric data also receives minimum, maximum, average, and median values. Date data receives earliest date, latest date, and span. Text data receives key length checks.
Export Ready Results
Sorted data often needs to move into another workflow. CSV export is practical for spreadsheets and database imports. PDF export is useful for summaries, approvals, and archived views. Both exports use the same rules as the on-page calculation, so the saved result matches the visible result.
FAQs
What does this calculator sort?
It sorts pasted rows by a selected key. The key can be the whole row or a chosen column inside each row.
Can I sort numbers and dates?
Yes. Choose number, date, text, or auto detection. Auto mode checks the nonblank keys and selects a suitable comparison method.
How do I sort a table?
Paste one table row per line. Pick the row separator, then enter the column number that should control the order.
What happens to blank values?
You can move blank keys to the top, move them to the bottom, or remove rows with blank keys before sorting.
Can duplicate keys be removed?
Yes. Select the duplicate removal option. The calculator keeps the first matching key and skips later repeated keys.
What is stable sorting?
Stable sorting keeps the original row order when two sort keys are equal. This protects meaningful input order during ties.
What does the CSV export include?
The CSV file includes the new position, original row, extracted sort key, and original row number for review.
Does the PDF export use the same rules?
Yes. The PDF report is generated from the same submitted rules and includes summary metrics plus sorted rows.