Excel Automation

Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration

5 stars 3 forksProductivity & Notes

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add Engineer1999/A-Curated-List-of-Awesome-Claude-Skills --skill Excel Automation
Manual install
git clone --depth 1 https://github.com/Engineer1999/A-Curated-List-of-Awesome-Claude-Skills.git /tmp/A-Curated-List-of-Awesome-Claude-Skills
mkdir -p ~/.claude/skills
cp -r /tmp/A-Curated-List-of-Awesome-Claude-Skills/app-automations/excel-automation ~/.claude/skills/Excel-Automation

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Excel Automation

Automate spreadsheet operations including creating workbooks, writing data, formatting cells, upserting rows, and managing worksheets. Works with Microsoft Excel (OneDrive) and Google Sheets.

**Toolkit docs:** [claude-skills.ai/toolkits/excel](https://claude-skills.ai/toolkits/excel)

---

## Setup

This skill requires the **Rube MCP server** connected at `https://rube.app/mcp`.

Before executing any tools, ensure an active connection exists for the `excel` (and optionally `googlesheets`) toolkit. If no connection is active, initiate one via `RUBE_MANAGE_CONNECTIONS`.

---

## Core Workflows

### 1. Create a New Excel Workbook

Use `EXCEL_CREATE_WORKBOOK` to generate a new `.xlsx` file and upload it to OneDrive.

**Tool:** `EXCEL_CREATE_WORKBOOK`

**Steps:**
1. Call `EXCEL_CREATE_WORKBOOK` with worksheet names and data
2. The tool creates a `.xlsx` file and uploads it to OneDrive
3. Use the returned file path/URL for subsequent operations

---

### 2. Write Data to a Spreadsheet

Use `GOOGLESHEETS_BATCH_UPDATE` to write values to a specific range or append rows.

**Tool:** `GOOGLESHEETS_BATCH_UPDATE`

**Key Parameters:**
- `spreadsheet_id` (required) -- The spreadsheet ID from the URL (44-char alphanumeric string)
- `sheet_name` (required) -- Tab name, e.g., `"Sheet1"`, `"Sales Data"`
- `values` (required) -- 2D array of cell values, e.g., `[["Name","Amount"],["Alice",100]]`
Read the full skill on GitHub

Details

Skill name
Excel Automation
Path
app-automations/excel-automation/SKILL.md
Repo updated
28 March 2026

FAQ

What does the Excel Automation skill do?

Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration

How do I install the Excel Automation skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add Engineer1999/A-Curated-List-of-Awesome-Claude-Skills --skill Excel Automation. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Excel Automation popular?

It lives in Engineer1999/A-Curated-List-of-Awesome-Claude-Skills, which has 5 GitHub stars and 3 forks.

Related skills

Browse the most popular Claude skills, all productivity & notes skills, or write your own with the skills generator.