# Xlfilter

> Use when the user asks to filter, query, search, or extract specific rows or columns from an Excel spreadsheet. Also use when the user wants to sort spreadsheet data, find rows matching conditions, or select specific columns from an xlsx file.

- **Type:** Skill
- **Install:** `agentstack add skill-louloulibs-claude-skills-xlfilter`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [LouLouLibs](https://agentstack.voostack.com/s/louloulibs)
- **Installs:** 0
- **Category:** [Data & Analytics](https://agentstack.voostack.com/c/data-and-analytics)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [LouLouLibs](https://github.com/LouLouLibs)
- **Source:** https://github.com/LouLouLibs/claude-skills/tree/main/skills/xlfilter

## Install

```sh
agentstack add skill-louloulibs-claude-skills-xlfilter
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# xlfilter — Excel Row/Column Filter

Filter, sort, and select data from Excel files. Outputs markdown tables or CSV.

## Quick Reference

```bash
# Filter rows where State equals CA
xlfilter file.xlsx --where State=CA

# Multiple filters (AND logic)
xlfilter file.xlsx --where State=CA --where Amount>1000

# Select specific columns
xlfilter file.xlsx --cols State,City,Amount

# Sort by column (ascending by default)
xlfilter file.xlsx --sort Amount
xlfilter file.xlsx --sort Amount:desc

# Limit output rows
xlfilter file.xlsx --where Status=Active --limit 10

# First/last N rows (before filtering)
xlfilter file.xlsx --head 20
xlfilter file.xlsx --tail 10

# Target a specific sheet
xlfilter file.xlsx --sheet Revenue --where Region=East

# Skip metadata rows above the real header
xlfilter file.xlsx --skip 2 --where Name~alice

# CSV output for piping
xlfilter file.xlsx --where Amount>500 --csv
```

## Filter Operators

| Operator | Meaning | Example |
|----------|---------|---------|
| `=` | Equals | `State=CA` |
| `!=` | Not equals | `Status!=Draft` |
| `>` | Greater than | `Amount>1000` |
| `=` | Greater or equal | `Score>=90` |
| `` | Filter rows (repeatable, AND logic) |
| `--cols ` | Select columns by name or letter (A,B,D) |
| `--sort ` | Sort by column (`col` or `col:desc`) |
| `--limit ` | Max rows in output (after filtering) |
| `--head ` | First N rows (before filtering) |
| `--tail ` | Last N rows (before filtering) |
| `--sheet ` | Select sheet by name or 0-based index |
| `--skip ` | Skip metadata rows above header |
| `--csv` | Output as CSV instead of markdown |

## Exit Codes

| Code | Meaning |
|------|---------|
| 0 | Success |
| 1 | Runtime error |
| 2 | Invalid arguments |

## Workflow

1. Use `xlcat file.xlsx` first to see schema and sample data
2. Use `--where` to filter rows by conditions
3. Use `--cols` to narrow to relevant columns
4. Use `--sort` to order results
5. Use `--csv` when piping to other tools

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [LouLouLibs](https://github.com/LouLouLibs)
- **Source:** [LouLouLibs/claude-skills](https://github.com/LouLouLibs/claude-skills)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-louloulibs-claude-skills-xlfilter
- Seller: https://agentstack.voostack.com/s/louloulibs
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.