SPARKPOND / SORT CSV

Sort a CSV by Multiple Columns

Create a persistent export sort, not just a visual table order. Each key has a type, direction and priority, and equal rows retain stable order.

✓ Processed locally✓ No account✓ Original unchanged

LOCAL WORKSPACE

Open your data file

CSV, TSV. o trascinali qui.

Download the example file ↓

Focused purpose

What this tool does

Sort CSV or TSV locally by multiple text, number or date columns. Control direction, empty values and stable priorities, then download without an account.

  • ✓ Text, number and date comparison
  • ✓ Ascending and descending direction
  • ✓ Multiple priority keys
  • ✓ Stable tie handling

Workflow

How to use it

  1. 01

    Select the primary sort column and type.

  2. 02

    Add directions and secondary keys.

  3. 03

    Preview row order and export.

Available controls

Available options

  • Choose comparison type per key.
  • Order empty cells first or last.
  • Add secondary and tertiary keys.
  • Keep equal rows in source order.

Category and amount sort

Example before and after

Rows need category ascending, then numeric amount ascending.

Before

item,category,amount
B,tools,10
A,books,20
C,tools,5

After

item,category,amount
A,books,20
C,tools,5
B,tools,10

Expected result: The stable two-key sort produces a deterministic order.

Download example ↓

Practical scenarios

Common use cases

Sort invoices by date and amount.

Order products by category then name.

Create deterministic import files.

HONEST LIMITS

Important limitations

  • iMixed numeric text sorts as configured; invalid values follow the empty/error policy.
  • iSorting very large files requires memory for row indexes.

FAQ

Questions about this tool

Is 10 sorted before 2?

Only in text mode. Choose number mode to compare numeric values.

Can I sort by more than one column?

Yes. Drag or add keys in priority order.

Where do empty cells go?

Choose first or last for each sort key before previewing.