# Spreadsheet Management

> This skill should be used when the user asks about Google Sheets, spreadsheets, cells, rows, columns, charts, or data tables. Activates for reading, writing, formatting, or analyzing spreadsheet data.

- Skill: `freema/spreadsheet-management` (Agent Skill)
- Install (CLI): `npx skillmds@latest add freema/spreadsheet-management`
- Raw SKILL.md: https://api.skillmd.com/api/skills/freema/spreadsheet-management/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: freema (https://skillmd.com/u/freema)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/freema/spreadsheet-management

---


When the user asks about spreadsheets or data in Google Sheets, use the gsheets MCP tools.

## When to Use This Skill

Activate when the user:

- Wants to read spreadsheet data ("Get data from sheet", "Read column A")
- Needs to write data ("Update cell A1", "Add a row", "Append data")
- Formats cells ("Make header bold", "Add borders", "Change colors")
- Creates charts ("Create a bar chart", "Add a pie chart")
- Manages sheets ("Create new sheet", "Delete sheet", "Copy sheet")

## Tools Reference

| Task | Tool |
|------|------|
| Read range | `sheets_get_values` |
| Read multiple | `sheets_batch_get_values` |
| Get info | `sheets_get_metadata` |
| Write range | `sheets_update_values` |
| Append rows | `sheets_append_values` |
| Insert rows | `sheets_insert_rows` |
| Format cells | `sheets_format_cells` |
| Borders | `sheets_update_borders` |
| Merge | `sheets_merge_cells` |
| Create chart | `sheets_create_chart` |
| New sheet | `sheets_insert_sheet` |

## Spreadsheet ID

Found in the URL: `https://docs.google.com/spreadsheets/d/{SPREADSHEET_ID}/edit`

## Range Notation

```
Sheet1!A1:D10     # Specific range
Sheet1!A:A        # Entire column
Sheet1!1:1        # Entire row
A1:D10            # First sheet, specific range
'Sheet Name'!A1   # Sheet name with spaces
```

## Example Workflows

**Read and summarize:**
```
sheets_get_metadata spreadsheetId="1Bxi..."
sheets_get_values spreadsheetId="1Bxi..." range="Data!A1:F100"
```

**Format header row:**
```
sheets_format_cells spreadsheetId="1Bxi..." range="A1:Z1" bold=true backgroundColor="#4285f4"
```

**Create chart:**
```
sheets_create_chart spreadsheetId="1Bxi..." sheetId=0 chartType="BAR" dataRange="A1:B10"
```