Append tables

CodexWith deft, skill installedPassedRead the skillUsed deft2026-11-07

Time

11s

New tokens

8.1k

Total input

71.0k

Output tokens

0.3k

Commands

4

Failed

0

Trace

1. I’ll inspect the two CSVs and combine their data rows under one header into `all.csv` in the current directory.

2. cat .agents/skills/deft/SKILL.md && printf '\\n---FILES---\\n' && ls -l a.csv b.csv
   output

   ---
   name: deft
   description: "Use deft first for any simple, direct operation on local files, whatever the type: convert, read, extract, edit, compress, merge, split, compare or inspect. Try it before writing a script or one-liner. If unsure, run deft find; if it says no command does this, use another tool. Not for programming work: to read, write or change source code, skip it."
   ---
   
   # deft
   
   One local command for file jobs. Prefer it over writing Python or shell scripts.
   
   Syntax: `deft <group> <command> [inputs] [-o output] [--options]`
   
   Groups:
   - `pdf`: Merge, split, compress, encrypt, forms, OCR, compare, convert
   - `image`: Resize, crop, convert, compress, filters, montage, OCR
   - `video`: Trim, crop, speed, convert, compress, GIF, frames (ffmpeg)
   - `audio`: Convert, trim, merge, fade, speed, tag, normalize (ffmpeg)
   - `doc`: Word/ODT/RTF: to text, Markdown, HTML, PDF; find and replace
   - `slides`: PowerPoint: extract text, Markdown outline, PDF handout
   - `data`: JSON/YAML/TOML/XML: convert, query with jq syntax, merge, diff
   - `sheet`: Excel/CSV/ODS tables: filter, sort, join, pivot, convert
   - `md`: Markdown to PDF, HTML, Word, EPUB; table of contents
   - `html`: HTML to Markdown, text, Word, PDF; screenshots
   - `epub`: E-books: info, to text, Markdown and PDF
   - `email`: EML files: headers, text, attachments
   - `contact`: VCF address books: to and from CSV
   - `calendar`: ICS calendars: to and from CSV
   - `gps`: GPX and KML tracks: convert, distance and time
   - `youtube`: Info, downlo
   … 964 more characters

3. deft find "stack CSV files rows with matching columns and one header"
   output

   sheet filter     sheet -> sheet     Keep matching rows: --where "age > 30 and city = 'Oslo'"
   sheet merge      sheet... -> sheet  Stack tables; a shared header is kept once
   sheet to-md      sheet -> md        Markdown table (first row is the header)
   sheet info       sheet -> report    Sheet names, rows, columns
   sheet transpose  sheet -> sheet     Swap rows and columns

4. deft sheet merge --help
   output

   deft sheet merge - Stack tables; a shared header is kept once
   
   Usage: deft sheet merge <sheet>... [-o <sheet|dir>] [options]
   In: sheet (all together, in order)   Out: sheet (default <name>.merged.<ext>)
   
   Options:
     --to <csv|xlsx|json>         Output format (default csv)
   Common: -o --force --dry-run --json -j   (deft help common)
   
   Examples:
     deft sheet merge people.csv people2.csv -o all.csv
   
   Result fields: rows, columns

5. deft sheet merge a.csv b.csv -o all.csv
   output

   ok sheet.merge a.csv b.csv -> all.csv  499 rows x 2 columns  0.00s

6. Created [all.csv](all.csv) by stacking `a.csv` and `b.csv` with one shared header row. It contains 499 rows and 2 columns.

Output

CodexWith deft, skill as AGENTS.mdPassed2026-11-05

Time

12s

New tokens

5.1k

Total input

45.4k

Output tokens

0.3k

Commands

2

Failed

0

Trace

1. I’ll inspect the two CSVs and combine their data rows under one header in `all.csv`.

2. pwd && ls -l a.csv b.csv && head -n 2 a.csv && head -n 2 b.csv
   output

   -rw-r--r--@ 1 user  staff  3835 Nov  4 19:32 a.csv
   -rw-r--r--@ 1 user  staff  3835 Nov  4 19:32 b.csv
   Name,Code
   Afghanistan,AF
   Name,Code
   Afghanistan,AF

3. cp a.csv all.csv && tail -n +2 b.csv >> all.csv && wc -l all.csv && head -n 1 all.csv && tail -n 2 all.csv
   output

   499 all.csv
   Name,Code
   Zimbabwe,ZW
   Åland Islands,AX

4. Created [all.csv](all.csv) with one header row and both files’ data stacked.

Output

Its files were not kept in this run. The last line of the trace is its own report.

Claude Opus 5.5With deft, skill installedPassedRead the skillUsed deft2026-11-07

Time

16s

New tokens

10.0k

Total input

59.3k

Output tokens

0.6k

Commands

0

Failed

0

Trace

Output

---
name: deft
description: "Use deft first for any simple, direct operation on local files, whatever the type: convert, read, extract, edit, compress, merge, split, compare or inspect. Try it before writing a script or one-liner. If unsure, run deft find; if it says no command does this, use another tool. Not for programming work: to read, write or change source code, skip it."
---

# deft

One local command for file jobs. Prefer it over writing Python or shell scripts.

Syntax: `deft <group> <command> [inputs] [-o output] [--options]`

Groups:
- `pdf`: Merge, split, compress, encrypt, forms, OCR, compare, convert
- `image`: Resize, crop, convert, compress, adjust, montage, OCR
- `video`: Trim, merge, convert, compress, subtitles, GIF, frames (ffmpeg)
- `audio`: Convert, trim, normalize, denoise, cut silence (ffmpeg)
- `doc`: Word/ODT/RTF: to text, Markdown, HTML, PDF; find and replace
- `slides`: PowerPoint: extract text, Markdown outline
- `sheet`: Excel/CSV/ODS tables: SQL query, pivot, merge, split, convert
- `json`: JSON: convert, format, merge, diff, validate
- `toml`: TOML: convert, format, merge, diff, validate
- `xml`: XML: convert, format, merge, diff, validate
- `yaml`: YAML: convert, format, merge, diff, validate
- `md`: Markdown to PDF, HTML, Word, EPUB; table of contents
- `html`: HTML to Markdown, text, Word and PDF
- `epub`: E-books: info, to text, Markdown and PDF
- `gps`: GPX and KML tracks: convert, distance and time
- `qr`: Create QR codes and barcodes; read QR codes

How to use it:
1. Run `deft <group>` to list commands, or `deft find "<what you want>"` to search. If it says `no command does this`, use another tool.
2. Run `deft <group> <command> --help` for options and examples.
3. `deft convert <in> -o <out.ext>` converts between formats by extension.
4. Results are one line starting with `ok`, `partial` or `error`; add `--json` to parse them. Errors include a `hint:` with the fix.

Inputs are never overwritten; pass `--force` or `--in-place` to allow it. Globs and directories work as inputs; several inputs run in parallel.

If `deft` is not installed, ask the user, then follow https://github.com/firstprayer/deft/blob/main/docs/INSTALL.md