CSV Workbench

Delimited files get a real grid — typed columns, frozen headers, one-click sorting — at log-file scale. Two million rows parse to a working grid in 2.6 seconds.

Entering the grid

CSV files are detected on open (delimiter and header row inferred) and the grid activates automatically; toggle between grid and raw text any time with ⇧⌘C. The status bar shows live rows × columns and parse progress.

2,000,000 order records, 12 columns. Headers stay frozen; the grid scrolls at full speed.

Sorting

Click any column header. Type inference runs underneath, so numeric columns sort as numbers and text columns sort as text — no dialog, no guessing.

Sorted by the numeric total column: 2M rows in 8.2 s (measured), rows preserved exactly.

Editing cells

Double-click a cell to edit it in place. Edits write through to the underlying text, participate in normal undo/redo, and re-align the grid immediately.

In-place cell editing on a 2M-row file. Esc cancels; Return commits.

Selection

Click row numbers or column headers and drag to select whole rows and columns; the selection copies as proper delimited text.

Filtering in the grid

The same filter engine works in grid mode — conditions apply to whole records, and the grid shows only matching rows.

Filtered to rows containing “returned” — the grid mirrors the filter with original row numbers intact.

Column operations

• Split / combine columns — break one column into several on a delimiter, or join several into one.
• Extract columns — pull selected columns into a new document.
• Dedupe — remove duplicate rows by any column combination.

Malformed files

Rows that don't parse cleanly get explicit parse states rather than silent guesses — you can see exactly which rows are suspect and why, and the raw text view is always one keystroke away.