Sort

Node Preparation
PreparationData Table→ Data Table

Sort rows by one or more columns, ascending or descending — like Excel's Sort dialog.

Description

Sorts a table's rows by one or more key columns, each with its own ascending or descending direction. A column sorts numerically only when every one of its non-blank values parses as a number — otherwise it falls back to a plain text sort, so a stray label never ends up treated as smaller or larger than a real number. Blank cells always sort last, matching Excel's own behavior, regardless of the column's direction.

Best For

  • Ordering rows by date, amount, or ID before review or export
  • Sorting by a primary column, then a secondary tie-breaker column
  • Bringing the highest or lowest values in a column to the top for quick scanning

How to Use

1Connect your table
Pass any table into Sort's input.
2Add a sort key
Choose a column and its direction (ascending or descending).
3Add more keys for ties
Add additional columns to break ties in the order they're listed.

Tips & Notes

Numeric detection is per-column
A column sorts as numbers only if every non-blank value in it parses as one — a single text value like "N/A" falls the whole column back to a text sort.
Watch Video TutorialsView playlist on YouTube