How to Use (3 Steps)
Choose your CSV
- Select a file or paste CSV into the text box.
- The first-row preview shows column numbers as
[1] [2] [3] ….
[Completely Free] Utility Tools & Work Support Tools
You can use practical tools like CSV formatting, PDF conversion, and ZIP renaming entirely in your browser, all for free. Each tool page clearly explains “How to use it”, “What the output looks like”, and “Important notes & caveats”, so even first-time users can start without confusion.
Set options
- Delimiter: Comma / Tab / Semicolon / Pipe
- First row is header: Keep checked if your CSV has a header row.
- Target column number: Specify 1, 2, 3… from the left.
- Order: Ascending (small→large / early→late) or Descending
- Compare mode:
- Numeric — treats values as numbers, auto-stripping commas,
%, and spaces (e.g.,1,200,35%). - String (natural order) — compares as text in a human-friendly way (e.g.,
A2 < A10).
- Numeric — treats values as numbers, auto-stripping commas,
- Put empty cells last: Handy when there are many blanks (recommended).
Sort → Download
- A preview (up to 200 rows) appears below, plus a Download CSV button.
- Use Copy All to copy the entire result to the clipboard.
FAQ
- I don’t know the column number.
Once you choose a file, the first-row preview appears. Count from[1]. - Will Excel CSVs (Shift-JIS) work?
Yes. Encoding is auto-converted to UTF-8. If you see garbling, check the delimiter or the original file. - Excel shows garbled text after download.
The output CSV is UTF-8. In Excel, import the data or open with encoding specified. - Large CSV won’t open.
The tool is intended for files up to 5 MB. Split larger files first. - Will the header stay on top?
Yes—if First row is header is checked, the header is fixed to the top.
Examples
- Sort by price (low → high)
Delimiter: Comma / Header: ✔ / Column: Price column number / Order: Ascending / Compare: Numeric - Sort names A→Z (natural order)
Delimiter: Comma / Header: ✔ / Column: Name column number / Order: Ascending / Compare: String (natural) - Sort by date (newest first, prefer
YYYY-MM-DD)
Delimiter: Comma / Header: ✔ / Column: Date column number / Order: Descending / Compare: String (natural)
Notes
- Empty cells: With Put empty cells last checked, blanks are pushed to the end.
- Uneven columns: If rows have different column counts, empty cells are auto-padded to align.
- Preview limit: The on-screen preview shows up to 200 rows, but the downloaded CSV contains all rows.
- Safety: Basic security checks are applied. If something glitches, try reloading the page.
