Quick summary
xan is a fast, command-line utility for working with CSV datasets. Implemented in Rust, it’s optimized for speed and low memory footprints, so it can process files measured in gigabytes without excessive resource use. Commands are designed to be composed and piped together, letting you build compact workflows for repeated data tasks.
Core operations you can chain
- Join multiple CSVs into combined tables
- Sort rows by one or more columns
- Aggregate and summarize values across groups
- Slice out subsets of rows or columns
- Apply row- and column-level filters
- Peek at file contents for quick previews
Supported formats and data interchange
xan isn’t limited to plain CSV — it reads and writes several adjacent formats and conversion targets. Examples include:
- Excel spreadsheets and related XLSX formats
- JSON documents for structured interchange
- Other delimited and tabular formats commonly used in pipelines
Advanced capabilities for analysis
Alongside basic manipulation, xan provides a compact expression language tuned for tabular data, which often runs faster than ad-hoc scripts. It also includes visualization helpers and specialized utilities for tasks in lexicometry and network/graph analysis, making it particularly useful in fields like social science research.
Alternate option to consider
If you need a different utility for system cleanup or product-specific removal tasks, consider the McAfee Consumer Products Removal Tool (available as a free download) as an alternative for that particular use case.
Technical
- Windows
- Free