BurntSushi/xsv on Hacker News

It's retired in favor of qsv and xan: https://github.com/BurntSushi/xsv

comment by esafak · 2026-01-19 · in Command-line Tools can be 235x Faster than your Hadoop Cluster (2014)

aaand xsv : https://github.com/BurntSushi/xsv

comment by jgord · 2025-03-27 · in A love letter to the CSV format

shout out to BurntSushis excellent xsv util https://github.com/BurntSushi/xsv

comment by jgord · 2025-03-27 · in A love letter to the CSV format

…just using something like zsv ( https://github.com/liquidaty/zsv , which I'm an author of) or xsv ( https://github.com/BurntSushi/xsv/edit/master/README.md ) and then spending that time saved on "real" work

comment by mattewong · 2024-08-14 · in CSVs Are Kinda Bad. DSVs Are Kinda Good

Or https://github.com/BurntSushi/xsv

comment by g8oz · 2024-05-27 · in Ask HN: How would you chunk a large Excel file?

…that comparable since these tools don't support SQL, but a more fully functioned CLI tool is - https://github.com/BurntSushi/xsv They are both fairly good

comment by skeptrune · 2024-04-02 · in Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes

its parser is buggy! https://github.com/BurntSushi/xsv/issues/337 (I ran into this issue myself)

comment by vmchale · 2024-03-26 · in Friends don't let friends export to CSV

xsv makes dealing with csv miles easier: https://github.com/BurntSushi/xsv

comment by coxley · 2024-03-26 · in Friends don't let friends export to CSV

xsv? I never heard of it. This one? https://github.com/BurntSushi/xsv If yes, looks very cool. Plus, bonus HN/Internet points for being written in Rust!

comment by throwaway2037 · 2024-03-26 · in Friends don't let friends export to CSV

diffeence from https://github.com/BurntSushi/xsv ?

comment by leeoniya · 2024-01-06 · in Csvlens: Command line CSV file viewer. Like less but made for CSV

Also: https://github.com/BurntSushi/xsv https://csvkit.readthedocs.io/en/latest/

comment by hermitcrab · 2023-12-23 · in Qsv: Efficient CSV CLI Toolkit

…online. See https://github.com/learnbyexample/scripting_course#ebooks for links. Have you looked at https://github.com/BurntSushi/xsv for csv processing?

comment by asicsp · 2023-11-08 · in The bash book to rule them all

I have done some similar, simpler data wrangling with xsv ( https://github.com/BurntSushi/xsv ) and jq. It could process my 800M rows in a couple of minutes (plus the time to read it out from the database =)

comment by jakjak123 · 2023-10-19 · in Joining CSV Data Without SQL: An IP Geolocation Use Case

…For a more robust solution, see https://stackoverflow.com/q/45420535 or use other tools like https://github.com/BurntSushi/xsv

comment by asicsp · 2023-06-29 · in The Awk Programming Language, Second Edition

Personally, I use xsv and it’s been tremendously helpful, especially when working with larger files. https://github.com/BurntSushi/xsv

comment by sklarsa · 2023-06-28 · in Using command line to process CSV files (2022)

…many want to expand the featureset of the base of xsv, which seems to be why qsv was created. [1] https://github.com/BurntSushi/xsv/issues/267

comment by keybored · 2023-06-27 · in Qsv: CSVs sliced, diced and analyzed (fork of xsv)

…you like it! CSV utilities (still haven't pick a favorite one...): https://github.com/harelba/q https://github.com/BurntSushi/xsv https://github.com/wireservice/csvkit https://github.com/johnkerl/miller

comment by lot3oo · 2023-03-25 · in icsp – Command-line iCalendar (.ics) to CSV parser

I suggest trying xsv as a first step: https://github.com/BurntSushi/xsv

comment by HopenHeyHi · 2023-03-24 · in Fascination of Awk

…latter of which I'm an author). https://github.com/liquidaty/zsv/blob/main/docs/csv_json_sql... https://github.com/BurntSushi/xsv

comment by mattewong · 2023-03-19 · in Analyzing multi-gigabyte JSON files locally

…[1]: https://www.postgresql.org/docs/current/datatype-json.html [2]: https://github.com/BurntSushi/xsv

comment by sgarland · 2023-03-18 · in Analyzing multi-gigabyte JSON files locally

csvkit and miller are both extraordinarily slow try xsv ( https://github.com/BurntSushi/xsv ) or zsv ( https://github.com/liquidaty/zsv ) instead (the latter of which I'm an author of)

comment by mattewong · 2023-03-14 · in Ask HN: What modern tools should be standard part of a modern unixy distro?Why?

…ton of processing of JSON and csv/tsv. Any word on the performance relative to jq and xsv [1]? [1] https://github.com/BurntSushi/xsv

comment by VWWHFSfQ · 2023-02-04 · in yq: command-line YAML, JSON, XML, CSV and properties processor

…naive comma splitting. Also unlike gnu join, xsv does not require input to be sorted (afaik) [1] https://github.com/BurntSushi/xsv

comment by zokier · 2023-01-15 · in Awk equivalents to SQL query data manipulation

FYI: https://github.com/BurntSushi/xsv is much faster than mlr (like an order of magnitude), and zsv ( https://github.com/liquidaty/zsv ) is even faster. But, neither support formulas. Disclaimer: I am one of the zsv authors

comment by mattewong · 2022-12-21 · in Ask HN: Programs that saved you 100 hours? (2022 edition)

For manipulating CSV from the terminal, check out https://github.com/BurntSushi/xsv

comment by sitkack · 2022-12-10 · in Consider Using CSV

xsv is invaluable for processing big csv files: https://github.com/BurntSushi/xsv

comment by alserio · 2022-09-25 · in Run SQL on CSV, Parquet, JSON, Arrow, Unix Pipes and Google Sheet

In the past I've used https://github.com/BurntSushi/xsv to query some large CSVs

comment by practice9 · 2022-06-21 · in One-liner for running queries against CSV files with SQLite

…`hi` are both returned as `hi`)? - How does it compare, performance-wise (or in other ways) with https://github.com/BurntSushi/xsv , https://github.com/eBay/tsv-utils or https://github.com/liquidaty/zsv ? (disclaimer: I wrote zsv)

comment by mattewong · 2022-06-21 · in Splitting CSV files at 3GB/s

xsv does similar stuff for CSV, and very rapidly: https://github.com/BurntSushi/xsv https://miller.readthedocs.io/en/latest/why/ has a nice section on "why miller": > First: there are tools like xsv which handles CSV marvelously and jq…

comment by llimllib · 2022-05-12 · in Modernizing AWK, a 45-year old language, by adding CSV support

…data at https://github.com/petewarden/dstkdata (credit to xsv for choosing that dataset) against https://github.com/BurntSushi/xsv and https://github.com/liquidaty/zsv (full disclosure: I am one of the zsv authors). Here's what I got.…

comment by mattewong · 2022-05-11 · in Modernizing AWK, a 45-year old language, by adding CSV support

https://github.com/BurntSushi/xsv Can do at least some of these

comment by nicoburns · 2022-05-02 · in Ask HN: What small library or tool do you want that doesn’t exist?

Have you tried https://github.com/BurntSushi/xsv ?

comment by hiq · 2022-05-02 · in Ask HN: What small library or tool do you want that doesn’t exist?

…like `zsv` (sql sub-command) ( https://github.com/liquidaty/zsv ) or `xsv` (sort subcommand) ( https://github.com/BurntSushi/xsv ) for this 3. Use mergesort to sort all shards, at the same time, into a single output table, and in the…

comment by mattewong · 2022-04-18 · in Ask HN: How to Deal with CSVs?

I think xsv is what you're looking for: https://github.com/BurntSushi/xsv . Specifically xsv table.

comment by ajoseps · 2022-03-17 · in TUIs

It is pragmatic with a minor tweak. https://csvkit.readthedocs.io/en/latest/ https://github.com/BurntSushi/xsv Heck, even sqlite has some stuff to help with processing CSV files: https://www.sqlite.org/csv.html

comment by oblio · 2021-12-13 · in Cheating at a company group activity using Unix tools

There's also xsv by BurntSushi, the author of ripgrep. https://github.com/BurntSushi/xsv One killer feature of xsv is creating an index for large csv file, for quicker searches.

comment by 1_player · 2021-11-24 · in Csvkit is a suite of command-line tools for converting and working with CSV

…as far as what it can do. It's very handle for quick statistical analysis of CSV input. [0]: https://github.com/BurntSushi/xsv

comment by ComputerGuru · 2021-09-27 · in Show HN: Tidy Viewer – a cross-platform CSV pretty printer for viewer enjoyment

Is this (supposedly) better than Burntsushi toolset (e.g. XSV[1]) or just different ? [1] https://github.com/BurntSushi/xsv

comment by traceroute66 · 2021-08-25 · in Miller CLI – Like Awk, sed, cut, join, and sort for CSV, TSV and JSON

charming article, as always, from burntsushi. You may also enjoy his xsv util [ https://github.com/BurntSushi/xsv ] for wrangling large csv files.

comment by jstgord · 2021-08-21 · in Index 1.6B Keys with Automata and Rust (2015)

…| xsv select 1,3 | q 'select * from - where col1 != "foo"' (xsv: also invaluable on the terminal: https://github.com/BurntSushi/xsv )

comment by nkcmr · 2021-06-07 · in Q – Run SQL Directly on CSV or TSV Files

Maybe xsv or csvkit? https://github.com/BurntSushi/xsv https://csvkit.readthedocs.io/en/latest/

comment by bitmedley · 2021-03-09 · in Ask HN: What was that texted based CSV data analysis tool?

…but there's a handy `csv2tsv` utility included. There's also `xsv`, from the author of `ripgrep`: https://github.com/BurntSushi/xsv

comment by pianoben · 2020-10-30 · in Awk: `Begin { ` Part 1

…sys; r = csv.reader(sys.stdin); ...' <data.csv` if it needs to run on someone else's machine. 3. https://github.com/BurntSushi/xsv if I want to quickly munge some data or extract a field. 4. Gnumeric if I want a GUI. 5.…

comment by walrus · 2020-10-30 · in Awk: `Begin { ` Part 1

There is https://github.com/BurntSushi/xsv but it doesn't seem to print with borders between cells.

comment by rnestler · 2020-10-30 · in Awk: `Begin { ` Part 1

See also https://github.com/BurntSushi/xsv

comment by asicsp · 2020-10-30 · in Awk: `Begin { ` Part 1

…I know. I've used it to parse / filter large PostgreSQL log files (20GB+) with great success. [1] https://github.com/BurntSushi/xsv

comment by phiresky · 2020-10-10 · in Loading CSV File at the Speed Limit of the NVMe Storage

There is also xsv [0] for CSV SQLing [0] https://github.com/BurntSushi/xsv

comment by sirodoht · 2020-08-16 · in Using Askgit – A SQL interface to your Git repository

…the path most people should take, but I didn't want to write table definitions. I ended up using https://github.com/BurntSushi/xsv (I am not affiliated with the project in any way). It's a command-line tool written in Rust that performs…

comment by alphanumeric0 · 2020-08-06 · in Scientists rename human genes to stop MS Excel from misreading them as dates

…crate [1]. xsv in particular is the best CLI csv tool I've ever used. And I've used them all. [0] https://github.com/BurntSushi/xsv [1] https://github.com/BurntSushi/rust-csv

comment by VWWHFSfQ · 2020-05-15 · in So you want to write your own CSV code (2014)

…so it's one binary - no runtime dependencies, and will happily chunk through multi-gigabyte files. https://github.com/BurntSushi/xsv

comment by nicoburns · 2020-05-15 · in So you want to write your own CSV code (2014)