Office automation

Read and edit Office files without Office

Scripts and agents need facts from a file, a template filled, a cell written, or a slide moved. These commands do that on existing DOCX, XLSX, and PPTX files and never cost a credit.

Terminal

jetformat word inspect contract.docx --json
jetformat excel get finance.xlsx --sheet Summary --cell B12
jetformat ppt reorder deck.pptx --from 1 --to 3 -o deck.pptx --force

Free.Nothing on this page uses credits or needs an account. Creating a blank Office file from scratch is not a CLI command; start from a template instead.

Word documents

Inspect structure, fill templates, add comments and headers, merge and split.

inspect

Paragraphs, tables, images, headers, content controls, styles, bookmarks, and comments.

Terminal

jetformat word inspect contract.docx --json
jetformat word tables contract.docx
jetformat word styles contract.docx
jetformat word bookmarks contract.docx

template / mail-merge / fill-fields

Content-control template, MERGEFIELD mail-merge, and legacy form fields are three different commands.

Terminal

jetformat word template letter.docx --set customer="Acme Corp" -o letter.docx --force
jetformat word mail-merge letter.docx --set Customer="Acme Corp" -o letter.docx --force
jetformat word fill-fields letter.docx --set Name=Ada -o letter.docx --force

comment / footnote / header / toc

Add or list comments, footnotes, endnotes, headers, hyperlinks, numbering, and a table of contents field.

Terminal

jetformat word comment letter.docx --author Alice --text "fix this" -o letter.docx --force
jetformat word footnote report.docx --paragraph 1 --text "see spec" -o report.docx --force
jetformat word header report.docx --text Confidential -o report.docx --force
jetformat word toc report.docx --levels 1-3 -o report.docx --force

watermark / style / add-table / add-image

Text or image watermark. Insert paragraphs, tables, and inline images into an existing DOCX — this is not creating a file from scratch.

Terminal

jetformat word watermark letter.docx --text CONFIDENTIAL -o letter.docx --force
jetformat word style report.docx --paragraph 1 --id Heading1 -o report.docx --force
jetformat word add-table report.docx --row Alpha,Beta -o report.docx --force
jetformat word add-image report.docx --paragraph 1 --image logo.png -o report.docx --force

merge / split

Merge concatenates DOCX files. Split follows section breaks, not pages. For page ranges, run word to-pdf, then pdf extract.

Terminal

jetformat word merge chapter1.docx chapter2.docx -o book.docx --force
jetformat word split report.docx -o report-parts --force

extract-images

Embedded pictures only. Scanned pages are not OCR.

Terminal

jetformat word extract-images report.docx -o report-images

Excel workbooks

Read and write cells, recalculate, sort, filter, freeze, protect.

inspect / get / set / recalc

Inspect sheets, formulas, and named ranges. set writes a value or formula; recalc updates cached results.

Terminal

jetformat excel inspect finance.xlsx --json
jetformat excel get finance.xlsx --sheet Summary --cell B12
jetformat excel set finance.xlsx --sheet Summary --cell A1 --value 5 -o finance.xlsx --force
jetformat excel recalc finance.xlsx -o finance.xlsx --force

table / sort / filter / freeze

Format as table, sort a column, set an auto-filter, freeze panes, and merge cells. Validation is a comma-separated dropdown only.

Terminal

jetformat excel table finance.xlsx --sheet Summary --range A1:B2 --name Sales -o finance.xlsx --force
jetformat excel sort finance.xlsx --sheet Summary --column A -o finance.xlsx --force
jetformat excel filter finance.xlsx --sheet Summary --range A1:C20 -o finance.xlsx --force
jetformat excel freeze finance.xlsx --sheet Summary --row --col -o finance.xlsx --force

add-sheet / protect / protect-sheet

Add, copy, rename, or remove visible sheets. protect locks workbook structure; protect-sheet locks one sheet.

Terminal

jetformat excel add-sheet finance.xlsx --name Extra -o finance.xlsx --force
jetformat excel copy-sheet finance.xlsx --from Summary --name Copy -o finance.xlsx --force
jetformat excel protect finance.xlsx --password secret -o finance.xlsx --force
jetformat excel protect-sheet finance.xlsx --sheet Summary --password secret -o finance.xlsx --force

insert-row / hide-column / print-area

Insert or hide rows and columns. There is no delete-row command. Column width is a character width.

Terminal

jetformat excel insert-row finance.xlsx --sheet Summary --row 2 -o finance.xlsx --force
jetformat excel hide-column finance.xlsx --sheet Summary --column A -o finance.xlsx --force
jetformat excel column-width finance.xlsx --sheet Summary --column A --width 18 -o finance.xlsx --force
jetformat excel print-area finance.xlsx --sheet Summary --range A1:B2 -o finance.xlsx --force

merge / split

Merge copies cell values and formulas from visible sheets. Charts and images may not copy.

Terminal

jetformat excel merge a.xlsx b.xlsx -o workbook.xlsx --force
jetformat excel split workbook.xlsx -o workbook-parts --force

PowerPoint decks

Reorder, copy, remove, and annotate slides. Read speaker notes.

inspect / notes

Slide counts, text boxes, tables, images, and speaker notes.

Terminal

jetformat ppt inspect board-deck.pptx --json
jetformat ppt notes board-deck.pptx
jetformat ppt set-notes board-deck.pptx --page 1 --text "speak now" -o board-deck.pptx --force

reorder / copy-slide / remove / add-slide

Page numbers start at 1. copy-slide appends a clone. remove deletes one slide.

Terminal

jetformat ppt reorder board-deck.pptx --from 1 --to 3 -o board-deck.pptx --force
jetformat ppt copy-slide board-deck.pptx --from 1 -o board-deck.pptx --force
jetformat ppt remove board-deck.pptx --page 2 -o board-deck.pptx --force
jetformat ppt add-slide board-deck.pptx -o board-deck.pptx --force

add-text / add-image / add-table

New shapes land at the top-left of the slide. add-table creates an empty table.

Terminal

jetformat ppt add-text board-deck.pptx --page 1 --text "extra box" -o board-deck.pptx --force
jetformat ppt add-image board-deck.pptx --page 1 --image logo.png -o board-deck.pptx --force
jetformat ppt add-table board-deck.pptx --page 1 -o board-deck.pptx --force

merge / split

Merge concatenates slides. Split writes one PPTX per slide.

Terminal

jetformat ppt merge a.pptx b.pptx -o deck.pptx --force
jetformat ppt split board-deck.pptx -o board-parts --force
jetformat ppt layouts board-deck.pptx
jetformat ppt slide-size board-deck.pptx

Convert one real file today.

Install in a minute. Inspect and PDF tools are free forever. Conversions come with 80 free pages a month, and cost a cent a page after that.

All install options See pricing

macOS · Linux

brew install jetformat/tap/jetformat