// Read, write, analyze, and format Excel spreadsheets (.xlsx). Use when the user needs to create Excel files, extract data from spreadsheets, apply formulas, format cells, or generate Excel reports from data. Supports multiple sheets, charts, and conditional formatting.
| name | excel-processor |
| description | Read, write, analyze, and format Excel spreadsheets (.xlsx). Use when the user needs to create Excel files, extract data from spreadsheets, apply formulas, format cells, or generate Excel reports from data. Supports multiple sheets, charts, and conditional formatting. |
| compatibility | Requires Python 3 and openpyxl (pip install openpyxl). |
Read, write, analyze, and format Excel spreadsheets (.xlsx) using Python.
| Script | Purpose | Dependencies |
|---|---|---|
excel_tool.py | Read, write, format, and analyze Excel files | openpyxl |
pip install openpyxl
CRITICAL — Dependency Error Recovery: If the script fails with an
ImportError, install the missing dependency using the command above, then re-run the EXACT SAME script command that failed.
python scripts/excel_tool.py read "INPUT.xlsx"
Options:
--sheet SHEET_NAME — Read a specific sheet (default: active sheet)--format json — Output as JSON instead of table--format csv — Output as CSV--save OUTPUT_PATH — Save output to filepython scripts/excel_tool.py create "OUTPUT.xlsx" --from-csv "DATA.csv"
Options:
--from-csv PATH — Import data from CSV file--from-json PATH — Import data from JSON file--sheet SHEET_NAME — Set the sheet name (default: Sheet1)--title TITLE — Add a title row with merged cells--auto-width — Auto-adjust column widths to fit content--header-style — Apply bold + colored header rowpython scripts/excel_tool.py add-sheet "EXISTING.xlsx" --sheet "NewSheet" --from-csv "DATA.csv"
python scripts/excel_tool.py format "FILE.xlsx" --auto-width --header-style --freeze-header
Options:
--auto-width — Auto-fit column widths--header-style — Bold white text on blue background for header--freeze-header — Freeze the first row--number-format COLS FORMAT — Apply number format (e.g., --number-format "C,D" "#,##0.00")python scripts/excel_tool.py analyze "FILE.xlsx"
Shows: sheet names, row/column counts, column types, basic stats for numeric columns.
python scripts/excel_tool.py formula "FILE.xlsx" --cell "E2" --formula "=SUM(B2:D2)"
python scripts/excel_tool.py formula "FILE.xlsx" --column "E" --formula "=SUM(B{row}:D{row})" --start-row 2 --end-row 100
excel_tool.py create "report.xlsx" --from-csv "data.csv" --title "Monthly Report" --auto-width --header-style --freeze-headerexcel_tool.py create "workbook.xlsx" --from-csv "sales.csv" --sheet "Sales"excel_tool.py add-sheet "workbook.xlsx" --sheet "Expenses" --from-csv "expenses.csv"excel_tool.py analyze "data.xlsx" — overviewexcel_tool.py read "data.xlsx" --sheet "Sheet1" — view contents--read-only mode for very large files.Comprehensive document creation, editing, and analysis with support for tracked changes, comments, formatting preservation, and text extraction. When GLM needs to work with professional documents (.docx files) for: (1) Creating new documents, (2) Modifying or editing content, (3) Working with tracked changes, (4) Adding comments, or any other document tasks
Process, transform, analyze, and report on CSV and JSON data files. Use when the user needs to filter rows, join datasets, compute aggregates, convert formats, deduplicate, or generate summary reports from tabular data. Works with any CSV, TSV, or JSON Lines file.
Generate professional email drafts using Python templates. Use when the user needs to compose business emails, follow-ups, introductions, meeting requests, or other professional correspondence. Supports multiple tones, languages, and email types with structured output.
Extract text from images using Python OCR. Use when the user wants to read text from screenshots, photos of documents, scanned pages, or any image containing text. Supports PNG, JPEG, TIFF, BMP, and WebP formats.
Comprehensive PDF manipulation toolkit for extracting text and tables, creating new PDFs, merging/splitting documents, and handling forms. When GLM needs to fill in a PDF form or programmatically process, generate, or analyze PDF documents at scale.
Scrape web pages, search the internet, and extract structured content using Python. Use when the user wants to fetch a webpage, search for information online, extract links, or crawl JavaScript-rendered dynamic pages.