skills.rest
xpert-ai
xpert-aiOFFICIAL
Explore all skills by this author →
Website𝕏@xpertai_cloudGitHub

spreadsheets

Create and modify .xlsx, .xls, .csv, and .tsv spreadsheets with formulas and charts.

8|12|Updated Sep 19, 2025
Search Tags:#data visualization#charts#data analysis#formulas#xlsx#csv#spreadsheets
One-click install
npx skills add https://github.com/xpert-ai/xpert-plugins --skill spreadsheets-xpert-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spreadsheets
Source: https://github.com/xpert-ai/xpert-plugins/tree/main/xpertai/skills/spreadsheets/skills/spreadsheets
Command: npx skills add https://github.com/xpert-ai/xpert-plugins --skill spreadsheets-xpert-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually creating, editing, and analyzing spreadsheets with formulas, formatting, and visualizations is time-consuming and error-prone. This Skill automates spreadsheet workflows to deliver accurate, professional workbooks in minutes.

Core Features & Use Cases

  • Full Spreadsheet Authoring: Create and edit .xlsx, .xls, .csv, and .tsv files with support for 440+ Excel formulas, cell formatting, tables, and data validation.
  • Data Visualization: Add native Excel charts, sparklines, and conditional formatting to highlight trends, comparisons, and outliers in tabular data.
  • Domain-Specific Support: Includes tailored guidance for finance/FP&A, healthcare, marketing, and scientific research use cases, plus routing for Google Sheets-native outputs.

Quick Start

Use the spreadsheets skill to build a formatted monthly revenue forecast workbook with automated variance calculations and a trend chart from your uploaded sales data file.

Frequently Asked Questions about spreadsheets

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

FAQPage Schema
How do I automate creating an xlsx workbook with formulas and charts from a CSV file?▼

Automating xlsx workbook creation with formulas and charts involves parsing CSV data, applying 440+ Excel formulas, adding formatting, and inserting native charts to generate a finalized spreadsheet. This process supports .xlsx, .xls, .csv, and .tsv formats.

What is the best way to build a financial modeling spreadsheet with variance calculations?▼

Building a financial modeling spreadsheet with variance calculations requires applying structured formulas, conditional formatting, and trend charts to raw data. Domain-specific guidance for FP&A workflows ensures accurate financial forecasting and report generation within the workbook.

Does this spreadsheet automation approach support Google Sheets native outputs?▼

Yes, spreadsheet automation supports Google Sheets native outputs alongside .xlsx, .xls, .csv, and .tsv formats. It routes workbook creation requests to generate compatible artifacts for Google Sheets, ensuring cross-platform accessibility.

Can I use Python for data preprocessing before generating Excel charts and sparklines?▼

Yes, Python can be used for data preprocessing before generating Excel charts and sparklines. The workflow utilizes the @oai/artifact-tool JavaScript library for deterministic spreadsheet authoring, with optional Python support to prepare and clean data beforehand.

How do data visualization and conditional formatting work for CSV data analysis?▼

Data visualization and conditional formatting for CSV data analysis work by applying native Excel charts, sparklines, and rules to highlight trends, comparisons, and outliers. This transforms raw tabular data into visually formatted, analytically rich spreadsheets.

What are the limitations of using spreadsheet formulas for healthcare data analysis?▼

Limitations of using spreadsheet formulas for healthcare data analysis include potential errors in manual formatting and complexity in regulated workflows. Domain-specific guidance is provided to navigate specialized requirements, ensuring data validation and accurate report generation.

Related Skills

Explore More Data & Analytics Skills→
sigitpoerwosigitpoerwo

xlsx

Open, modify, and convert spreadsheet files across XLSX, CSV, and TSV formats.

Community
Intermediate
vasilyu1983vasilyu1983
73

document-xlsx

Create, edit, and analyze Excel workbooks with formulas and charts.

Community
Advanced
vuhuudovuhuudo

officecli-data-dashboard

Transform CSV or Excel data into interactive Excel workbooks with dynamic charts and KPIs.

Community
Advanced
claude-office-skillsclaude-office-skills
368

data-analysis

Analyze Excel or CSV spreadsheet data to generate insights, visualizations, and reports.

Official
Intermediate