Skip to main content
prompt GP ChatGPT

table · genspark-ai, guides — Claude Code prompt: Excel tables, how to install

A prompt that tells the agent when to turn a range into a real Excel table and when to fake the look with plain formatting instead.

Apache-2.0 ★ 12,746 updated 2026-10-29

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/commands/table.md
Open on GitHub

What table does

The table prompt for Claude Code covers the add_table operation: headers and data go in first via set_range/set_cell, then the range becomes a table with a name, a style (TableStyleLight1..21, TableStyleMedium1..28, TableStyleDark1..11) and banded rows. Blank headers get auto-named Column1/Column2, and duplicate headers get numeric suffixes.

After that the agent can grow the table with add_table_row, delete_table_row, add_table_column and delete_table_column without saving in between, but only for tables created during the current session through add_table. Tables that were already in the file when it was opened can't be touched by these four operations; the agent has to ask the user to save and reopen the file first.

The prompt also lays out structured references such as TableName[Column] and TableName[#Data], matched case-sensitively against whatever get_sheet_features reports. For irregular layouts with subtotal rows or merged headers it switches to a fallback: shading via format_range, a MOD(ROW(),2)=0 conditional-format rule for the banded look, and set_filter standing in for the table's dropdown filters.

What it helps with

  • turn a header-plus-rows range into a real Excel table
  • insert or remove rows and columns inside a table created this session
  • add banded row shading and a filter without building it by hand
  • reference a table column with a structured reference like TableName[Column]
  • fake the look of a table on irregular data with subtotals

Example prompts for the agent

  • Turn A1:C20 into an Excel table named SalesDetail
  • Add two columns called Notes and Status to the SalesDetail table
  • Format A1:D100 with banded row shading and a filter on the header row

How to install table

Manually: put the files in place

.claude/commands/table.md

Questions about table

How do I install table in Claude Code?

Add the file .claude/commands/table.md to your project.

What does the table prompt do?

It gives the agent rules for handling Excel tables: when to build a real one with add_table, how to extend it with rows and columns, and when to fall back to a plain range with shading and a filter instead.

Can it modify rows and columns in a table that already existed in the file?

No, add_table_row, delete_table_row, add_table_column and delete_table_column only work on tables created through add_table in the current session. Tables that were already in the file require saving and reopening it first.

Source text

table.md · Apache-2.0
# Structured table guide (table)

## When to use a structured table

When the data is a regular "header + homogeneous record rows" shape, prefer a Table: automatic banded fill, filter dropdowns, and after saving a native table object in Excel (auto-expansion, structured references).

## Creating a table (add_table)

`{op:"add_table", sheetId, range:"A1:D10", name?, style?, bandedRows?}`

- **The first row of range must be headers**: write the headers and data with set_range/set_cell first, then add_table. Headers must be non-empty and mutually unique — empty headers are auto-filled as Column1/Column2, duplicate headers get numeric suffixes, and both are written back into the cells.
- range needs at least two rows (header + ≥1 data row) and must not overlap merged cells, existing tables, or a worksheet filter (set_filter) region — conflicts are rejected at save time.
- name: table name (starts with a letter/underscore, may contain Chinese; unique within the workbook, shares a namespace with defined names). **Always naming explicitly is recommended**; defaults to Table1, Table2… (if it collides with a table already in the file, saving errors).
- style: built-in styles `TableStyleLight1..21` / `TableStyleMedium1..28` / `TableStyleDark1..11`, default `TableStyleMedium2`.
- bandedRows: banded fill, default true.

```json
[
  {
    "op": "set_range",
    "sheetId": "s1",
    "range": "A1:C1",
    "values": [["Product", "Quantity", "Amount"]]
  },
  {
    "op": "add_table",
    "sheetId": "s1",
    "range": "A1:C20",
    "name": "SalesDetail",
    "style": "TableStyleMedium2"
  }
]
```

Notes:

- After creating the table you can extend its structure directly with `add_table_row` / `add_table_column` etc., no save needed first. But tables that came with the file (existed at open time) cannot be modified with these ops — ask the user to save and reopen.
- Don't merge_cells inside table data; don't stack set_filter on the header row (the table has its own filter).

## Structured references

The engine evaluates Excel structured references for every table listed by get_sheet_features (file tables and tables added this session), on the same sheet or on another sheet:

- `TableName[Column]`, `TableName[[ColA]:[ColB]]`, `TableName[#All]`, `TableName[#Headers]`, `TableName[#Data]`, `TableName[[#This Row],[Column]]` (only inside the table's own rows).
- Table and column names are matched **case-sensitively** — copy them exactly as get_sheet_features lists them.

Not supported (write a plain A1 range instead): the `[@Column]` / `TableName[@Column]` shorthand, sheet-qualified table names (`Sheet1!Table[Col]`), `[#Totals]` (a file table's totals row is outside the registered range), and tables that have no header row.

## Inserting/deleting rows and columns

> **Precondition**: these four operations only work on **tables created this session via add_table**; tables that came with the file are unsupported (error: please save and reopen before modifying).

### add_table_row — insert data rows

```json
{ "op": "add_table_row", "sheetId": "s1", "tableName": "SalesDetail", "row": 3, "count": 2 }
```

- `row` (optional, 1-based, relative to the data area): insert position; omitted = append at the end.
- `count` (optional, default 1): number of rows to insert, 1–1000.
- After the operation, fill the new rows with set_range/set_cell.

### delete_table_row — delete data rows

```json
{ "op": "delete_table_row", "sheetId": "s1", "tableName": "SalesDetail", "row": 2, "count": 1 }
```

- `row` (required, 1-based): first row to delete (relative to the data area, excluding the header).
- `count` (optional, default 1): number of rows to delete.
- At least 1 data row must remain; deleting them all is rejected.

### add_table_column — insert columns

```json
{
  "op": "add_table_column",
  "sheetId": "s1",
  "tableName": "SalesDetail",
  "column": 3,
  "columnName": "Notes",
  "count": 1
}
```

- `column` (optional, 1-based): insert position; omitted = append at the far right.
- `columnName` (required): header name of the new column; must not duplicate an existing column in the table.
- `count` (optional, default 1): number of columns to insert. When count>1, subsequent column names get numeric suffixes (Notes, Notes2…).

### delete_table_column — delete columns

```json
{
  "op": "delete_table_column",
  "sheetId": "s1",
  "tableName": "SalesDetail",
  "column": 4,
  "count": 1
}
```

- `column` (required, 1-based): first column to delete (relative to the table's left edge).
- `count` (optional, default 1): number of columns to delete.
- At least 1 column must remain; deleting them all is rejected.

### Typical workflow

1. Create and name the table with `add_table` (**explicit name recommended**).
2. Extend the structure with `add_table_row` / `add_table_column`, then fill data with `set_range` / `set_cell`.
3. When done, remind the user to save (⌘S); after saving, the table ref in the file updates automatically.

## Fallback plan (when a real table doesn't fit)

When the data is irregular (subtotal rows, merged multi-column headers), don't create a Table — simulate the look with a plain range:

```json
[
  {
    "op": "format_range",
    "sheetId": "s1",
    "range": "A1:D1",
    "format": { "bold": true, "fillColor": "#4472C4", "fontColor": "#FFFFFF" }
  },
  {
    "op": "add_conditional_format",
    "sheetId": "s1",
    "range": "A2:D100",
    "rule": {
      "kind": "formula",
      "formula": "=MOD(ROW(),2)=0",
      "format": { "fillColor": "#F2F7FF" }
    }
  },
  { "op": "set_filter", "sheetId": "s1", "range": "A1:D100" }
]
```

- Banded fill via a `MOD(ROW(),2)` conditional format (adapts automatically to row insertion/deletion).
- A filter on the first row (`set_filter`) approximates the Table's filter dropdowns.

## Deleting a table (delete_table)

`{op:"delete_table", sheetId, tableName}` — only tables created this session via add_table can be deleted; the semantics are "convert to a plain range": values and formats are kept, only the Table object is removed (style banding/filter disappear with it). Tables that came with the file cannot be deleted.

© genspark-ai · Apache-2.0 · genspark-ai/genoffice

Similar prompts

All prompts for Office documents →

table by other authors comes first.

table genspark-ai table is a Claude Code prompt for editing existing slide tables, from cell text and merges to sizing and styles. Invoke it to change a table in a presentation. GP ChatGPT ★ 12,746repo stars data-table-filters openstatusHQ data-table-filters — a skill for Claude Code, Cursor, Codex and other platforms: builds React tables with filters, sorting and infinite scroll on top of shadcn registry. Ships as 15 modular blocks installed via npx shadcn@latest add. CX Codex +1 501installs xlsx official anthropics Skill for Claude Code and Claude.ai that generates, modifies, and validates spreadsheets. Triggers whenever tasks involve xlsx, xlsm, csv, or tsv files. CX Codex +1 187,223installs data-analysis claude-office-skills data-analysis is a Claude Code skill that analyzes Excel and CSV spreadsheets, finds trends, and creates visualizations. It runs on requests to examine data or prepare a report. CX Codex +1 8,300installs xlsx-manipulation claude-office-skills xlsx-manipulation — a skill that builds and edits Excel files from code: creates .xlsx workbooks with openpyxl, adds formulas, formatting and charts. CX Codex +1 6,900installs minimax-xlsx MiniMax-AI minimax-xlsx is a Claude Code skill for creating, reading, editing, and validating Excel files. It handles financial models and formula fixes while preserving formatting and macros. CX Codex +1 3,900installs audit-xls official anthropics audit-xls audits Excel sheets for formula errors, hardcoded values, and logic breaks. It checks financial model integrity before sharing work with clients or review committees. CX Codex +1 2,400installs

From the same set65

The whole set →
labor-contract The labor-contract skill drafts an employment contract or offer letter as a Word document and adds a signing checklist. Use it when hiring terms need to be laid out. CX Codex +1 ★ 12,746repo stars data data documents the xlsx operations Claude can run: hyperlinks, AutoFilter, conditional formats, validation, notes and pivots. Useful when a workbook is edited by prompts, not by hand. GP ChatGPT ★ 12,746repo stars pivot Instructions for building native Excel pivot tables with add_pivot or summarizing data grids with dynamic SUMIFS formulas. GP ChatGPT ★ 12,746repo stars deck This prompt guides Claude Code through deck-wide changes to slide size, theme, text, footers, and sections. It calls for clarification when the requested scope is unclear. GP ChatGPT ★ 12,746repo stars charts This Claude Code prompt creates and edits spreadsheet charts. It helps select a chart type and specify the source data. GP ChatGPT ★ 12,746repo stars table table is a Claude Code prompt for editing existing slide tables, from cell text and merges to sizing and styles. Invoke it to change a table in a presentation. GP ChatGPT ★ 12,746repo stars writing writing tells the agent how to edit a spreadsheet: formulas instead of hand-computed numbers, bulk range ops instead of cell-by-cell writes. GP ChatGPT ★ 12,746repo stars text Defines instructions for updating and styling slide text using setText and setFont operations. Useful when automating presentation edits in Claude Code. GP ChatGPT ★ 12,746repo stars

Project sponsors

Companies that keep this analytics open