Sort and Filter a CSV in the Browser: Original Kept, Download Filtered
I work on OnePassApps. The Data Studio in app.onepassapps.com has a tab called Sort / filter that filters rows and sorts columns without sending the file anywhere. This is a look at how that tab actually behaves, with th
I work on OnePassApps. The Data Studio in app.onepassapps.com has a tab called Sort / filter that filters rows and sorts columns without sending the file anywhere. This is a look at how that tab actually behaves, with the panel copy and a run that I watched.
The page's own line is the whole promise: View and transform CSV, JSON, and YAML locally in this browser tab.
The tab you open
The Data Studio carries eleven tabs: CSV Viewer, Sort / filter, Columns, Duplicates, Merge, Split, To JSON, JSON Formatter, Validator, To CSV and YAML. The Sort / filter tab is the second one.
Getting the CSV in, and the step that trips people up
You can paste rows straight into the Source stage, browse for a file, or start from the CSV Viewer tab and press Parse CSV. Here is the part worth knowing: switching to the Sort / filter tab does not carry a parsed CSV into its options panel. The panel says Filter and sort options appear once the CSV is loaded, and the options stay empty until you press Load / refresh CSV on that tab.
That is not a complaint about the copy - it is a deliberate two-step design. The tab wants a CSV it owns, so that the sort and filter it applies are applied to the same source you can see in the preview.
The controls
Four of them, and they are all short:
- Filter rows - a text field that searches for a value.
- Filter column - a picker offering All columns plus every column in the file.
- Sort by - a picker offering Original order plus every column in the file.
- Order - Ascending or Descending.
- And the button that does the work: Apply filter and sort.
The delimiter sits alongside them: Auto detect ยท comma by default, with Comma, Tab, Semicolon and Pipe available. Auto detect reads the first lines to find the separator, so a pasted file with pipes or tabs usually works without touching it.
The Sort / filter tab's column pickers are built from the file itself. Drop a file with different headers and the two pickers change; they are not a fixed list of names.
What a run actually reported
I parsed a small CSV into the Data Studio:
name,role,score
Ada,engineer,92
Grace,engineer,75
Linus,maintainer,88
Alan,analyst,64
Then in the Sort / filter tab I set the filter to engineer, the sort column to score, the order to Descending, and pressed Apply filter and sort.
The Result step reported:
- Applied row filter and sort.
- 2 of 4 rows remain.
- 2 of 4 rows ยท 3 columns ยท no parsing issues
- Delimiter found Comma
- Parsed in 122 ms
The preview under it showed the two surviving rows, Ada with a score of 92 and Grace with a score of 75, in that order.
One detail in that preview is worth a second look. Each column carries its own type badge, so the header row reads name TEXT role TEXT score NUMBER. The score column was detected as a number, which is why sorting on it puts 92 above 75 rather than putting 75 above 92 the way a string sort would.
The line the tab prints under the options
Sorting and filtering change the preview and the safe CSV download. The original input is kept.
That sentence is the honest summary of the design. Filter and sort are not destructive. The Source stage still holds what you pasted, and the preview and the download are the filtered, sorted view of it. If you clear the filter, the full set is back.
The preview carries Table and Raw views and a Download CSV button, so you can check the filtered rows as a table or read the raw text before you take the file away.
Nothing leaves the tab
The panel states Nothing leaves this tab, and the stage says Processing stays in this browser. The plan block reads:
FREE PROMOTIONAL PERIOD
Standard is free right now
$0 / month
100,000 credits every 30 days ยท No end date set ยท No card required
No automatic paid subscription. Existing paid subscriptions keep their terms.
If you want the tool in context, the app guides are at app.onepassapps.com/guides.
A short summary
Sort and filter a CSV in the browser:
- Paste or browse your data into the Data Studio.
- Open Sort / filter and press Load / refresh CSV.
- Choose the filter column and the value to look for.
- Choose the sort column and Ascending or Descending.
- Press Apply filter and sort and read the preview.
The original input is kept, the download is the filtered copy, and nothing is uploaded to get there.
Originally published by Dev.to WebDev. Aggregated on AIWithGhost for educational purposes โ full credit and traffic to the original publisher.