Excel Automation
Excel Automation: create workbooks, manage worksheets, read/write cell data, and format spreadsheets via Microsoft Excel and Google Sheets integration
npx skills add composio-community/awesome-codex-skills --skill excel-automation --agent codex
Same command for any agent — swap --agent for claude-code, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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:** [composio.dev/toolkits/excel](https://composio.dev/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
- Setup
- Core Workflows
- 1. Create a New Excel Workbook
- 2. Write Data to a Spreadsheet
- 3. Upsert Rows by Key Column
- 4. Format Cells
- 5. Add New Worksheet Tabs
- 6. Read Data and Verify Content
- Recommended Execution Plan
- Known Pitfalls
- Quick Reference
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 it?
Run `npx skills add composio-community/awesome-codex-skills --skill excel-automation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From composio-community/awesome-codex-skills, a repository with 15,591 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.