Split into files of 100 rows

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

Time

18s

New tokens

6.1k

Total input

100.8k

Output tokens

0.6k

Commands

5

Failed

0

Trace

1. I’ll inspect the CSV and the available local file tool, then create numbered chunks of 100 data rows under `parts/`.

2. cat .agents/skills/deft/SKILL.md && pwd && rg --files -g 'countries.csv' -g '"'!parts/**'"'
   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
   … 864 more characters

3. deft find "split CSV into files by row count"
   output

   sheet split   sheet -> sheet...  Split up: --sheets, --columns city or --every 1000
   sheet dedupe  sheet -> sheet     Drop repeated rows, by whole row or --columns
   sheet to-md   sheet -> md        Markdown table (first row is the header)
   sheet group   sheet -> sheet     Group and total: --columns city --values sales --agg sum
   sheet info    sheet -> report    Sheet names, rows, columns

4. deft sheet split --help && ls -la
   output

   deft sheet split - Split up: --sheets, --columns city or --every 1000
   
   Usage: deft sheet split <sheet>... [-o <dir>] [options]
   In: sheet (each handled separately)   Out: sheet files in <name>-split/
   --sheets writes each sheet to its own file; the others split rows.
   
   Options:
     --sheets                     One file per sheet of a workbook
     --columns <text>             One file per value of this column
     --every <n>                  Rows per file
     --sheet <text>               Sheet name or number (default: first)
     --to <csv|xlsx|json>         Output format (default: like the input)
   Common: -o --force --dry-run --json -j   (deft help common)
   
   Examples:
     deft sheet split book.xlsx --sheets -o parts/
     deft sheet split people.csv --every 1 --to json -o rows/
   
   Result fields: files
   total 8
   drwxr-xr-x@    4 user  staff    128 Nov  6 19:06 .
   drwx------@ 1801 user  staff  57632 Nov  6 19:06 ..
   drwxr-xr-x@    3 user  staff     96 Nov  6 19:06 .agents
   -rw-r--r--@    1 user  staff   3835 Nov  5 21:11 countries.csv

5. deft sheet split countries.csv --every 100 -o parts
   output

   ok sheet.split countries.csv -> parts/  3 files  0.00s

6. ls -l parts
   output

   total 24
   -rw-r--r--@ 1 user  staff  1481 Nov  6 19:06 countries-001.csv
   -rw-r--r--@ 1 user  staff  1500 Nov  6 19:06 countries-002.csv
   -rw-r--r--@ 1 user  staff   874 Nov  6 19:06 countries-003.csv

7. Split `countries.csv` into three files in [parts](parts): `countries-001.csv`, `countries-002.csv`, and `countries-003.csv`.

Output

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

Time

9s

New tokens

10.1k

Total input

59.5k

Output tokens

0.5k

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