Full Excel toolkit for LM Studio. Supports .xlsx, .xlsm, .xls, .ods, .xlsb, .csv, .tsv — all without Python.
Installation
npm install
npm run build
lms dev
Data (12)
| Tool | Description |
|---|
excel_read | Read rows with range/pagination |
excel_write | Create a new file with formatting |
excel_append_rows | Append rows (validates headers) |
excel_filter | Filter with =, !=, >, <, contains, regex, isNull... |
excel_sort | Multi-column sort |
excel_delete_rows | Delete rows by filter |
excel_update_rows | UPDATE ... WHERE |
excel_merge_files | Merge multiple files into one workbook |
excel_find_replace | Find & replace across sheet |
excel_deduplicate | Remove duplicate rows |
excel_rename_columns | Rename headers |
excel_add_column | Add computed column via JS expression |
Sheets (7)
| Tool | Description |
|---|
excel_list_sheets | List all sheets with stats |
excel_create_sheet | Add new sheet with optional data |
excel_delete_sheet | Delete sheet |
excel_rename_sheet | Rename sheet |
excel_copy_sheet | Duplicate within same or another file |
excel_move_sheet | Reorder tabs |
excel_copy_rows_between_sheets | Copy/move rows between sheets |
| Tool | Description |
|---|
excel_format_cells | Font, fill, border, alignment on any range |
excel_conditional_format | Color cells by rules |
excel_freeze_panes | Freeze rows/columns |
excel_set_dimensions | Set column width / row height |
excel_add_data_validation | Dropdowns, numeric constraints |
excel_add_comment | Cell notes/comments |
excel_add_hyperlink | Clickable links in cells |
Charts (1)
| Tool | Description |
|---|
excel_create_chart | Real interactive Excel chart (bar, barh, line, area, pie, doughnut, scatter) — not an image |
VBA (1)
| Tool | Description |
|---|
excel_read_vba | Extract VBA module code from .xlsm |
Analysis (7)
| Tool | Description |
|---|
excel_summarize | Stats per column + outliers + duplicates |
excel_pivot | Pivot table with multiple aggregations |
excel_diff | Compare two files (added/removed/modified rows) |
excel_validate_data | Check data quality rules |
excel_query | SQL-like query: SELECT ... FROM ... WHERE ... |
excel_split_sheet | Split sheet into multiple files by column value |
excel_info | File metadata (format, size, sheets, VBA presence) |
Automatic backup
All destructive operations (delete, update, sort) create a .bak copy before modifying.
Dependencies
- ExcelJS — formatting, data validation, freeze panes, write
- SheetJS (xlsx) — reading .xls, .ods, .xlsb, VBA extraction
- JSZip — native Excel chart XML injection (no Python needed)