skills.rest
smorand
smorandCOMMUNITY
Explore all skills by this author →
𝕏@smorand1980GitHub

spreadsheet-manager

Automate Google Sheets spreadsheet creation, formatting, and CSV import/export.

Updated Aug 27, 2026
Search Tags:#api#formatting#csv#sheets#export#google-sheets
One-click install
npx skills add https://github.com/smorand/claude-config --skill spreadsheet-manager
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheet-manager
Source: https://github.com/smorand/claude-config/tree/main/skills/spreadsheet-manager
Command: npx skills add https://github.com/smorand/claude-config --skill spreadsheet-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides programmatic control over Google Sheets to create, format, import/export data, and automate common spreadsheet tasks.

Core Features & Use Cases

  • Create spreadsheets, add data, import CSV
  • Format cells (currency, date, percent) using patterns
  • Style cells, list sheets, create/rename sheets
  • Export to CSV and other formats

Quick Start

Create a new spreadsheet: "spreadsheet-manager create 'Monthly Report'"

Frequently Asked Questions about spreadsheet-manager

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Google Sheets formatting and data import workflows?▼

Automate Google Sheets workflows by programmatically creating spreadsheets, importing CSV data, and applying formatting like currency, date, and percent patterns using batchUpdate API calls. The Skill handles A1 notation parsing and returns resource identifiers and URLs for created sheets.

Can I import CSV data directly into Google Sheets and apply formatting?▼

Yes. Import CSV data into Google Sheets and apply formatting patterns for NUMBER, CURRENCY, DATE, PERCENT, and TEXT in a single workflow. The Skill supports cell styling, header formatting, and column manipulation through programmatic API calls.

What formatting options are available when working with Google Sheets programmatically?▼

Programmatic Google Sheets formatting supports currency, date, percent, number, and text patterns applied via batchUpdate calls. You can also style headers, apply cell-level formatting, and manipulate sheet structure through A1 notation.

How do I export Google Sheets data to CSV format?▼

Export spreadsheet data to CSV and other formats after creating and formatting your sheets. The Skill returns export URLs and identifiers, enabling downstream data distribution and integration workflows.

What Google Sheets operations can be automated with this approach?▼

Automate creating spreadsheets from templates, listing or renaming sheets, importing and exporting data, applying multi-format cell styling, and managing sheet structure. All operations use OAuth2 credentials and return identifiers for created resources.

Related Skills

Explore More Data & Analytics Skills→
krishagelkrishagel
5

google-workspace

Coordinate Gmail, Calendar, Drive, Docs, Sheets, Slides, Tasks, and Chat across multiple Google Workspace accounts.

Community
Advanced
wuyyyyyouwuyyyyyou

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet to a CSV file for local backup.

Community
Intermediate
googleworkspacegoogleworkspace
30.3k

recipe-log-deal-update

Append deal status updates to a Google Sheets sales tracking spreadsheet.

Official
Basic
MinhThang1009MinhThang1009
15

xlsx

Read, modify, and write xlsx, csv, tsv, and xlsm spreadsheets with Python.

Community
Intermediate