skills.rest
jonnytacos8
jonnytacos8COMMUNITY
Explore all skills by this author →
GitHub

excel-table-summarize

Summarize key figures and trends from SharePoint Excel tables using rag_search.

Updated Feb 13, 2026
Search Tags:#excel#data-analysis#sharepoint#summarize#trend-detection#rag_search#table-summarize
One-click install
npx skills add https://github.com/jonnytacos8/closed_claw --skill excel-table-summarize
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-table-summarize
Source: https://github.com/jonnytacos8/closed_claw/tree/main/mvp-skills/excel-table-summarize
Command: npx skills add https://github.com/jonnytacos8/closed_claw --skill excel-table-summarize

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Summarizes data from SharePoint-hosted Excel files to identify trends and key figures, reducing manual analysis time.

Core Features & Use Cases

  • RAG-backed data summarization from Excel tables across SharePoint libraries.
  • Sheet-aware analysis using metadata.sheet_name and metadata.cell_range to produce per-sheet insights.
  • Use-case: Quickly identify totals, trends, and outliers across one or more sheets and present results in a Markdown table with source citations.

Quick Start

Ask me to summarize data from a named SharePoint Excel file or library, and I will fetch the relevant table chunks and produce a trend-focused summary with citations.

Frequently Asked Questions about excel-table-summarize

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

FAQPage Schema
How do I summarize data from an Excel table stored in SharePoint?▼

You can summarize SharePoint Excel data by specifying the file name, library, and range metadata. The Skill fetches relevant table chunks via rag_search to identify key figures and trends, producing a concise narrative and optional markdown table with cited figures.

Can I analyze specific sheets and cell ranges within a SharePoint Excel file?▼

Yes, you can analyze specific sheets and cell ranges. The Skill performs sheet-aware analysis by respecting metadata.sheet_name and metadata.cell_range, allowing it to extract data and produce per-sheet insights from spreadsheets with multiple sheets or libraries.

How does RAG search work for extracting trends from Excel spreadsheets?▼

RAG search extracts trends by querying relevant table chunks from SharePoint Excel files. It targets specific data based on file names, libraries, and range metadata to identify totals, trends, and outliers across one or more sheets.

Do I need to manually format the summarized Excel data into a report?▼

No, you do not need to manually format the summarized data. The Skill automatically generates a concise narrative summary and an optional markdown table, presenting identified trends and key figures while citing all data points with document references.

What are the limitations when summarizing large SharePoint Excel libraries?▼

A key limitation is that summarization relies on SharePoint table chunks and rag_search, requiring accurate metadata.sheet_name and cell_range to function correctly. It extracts data based on specified file names and libraries, so poorly indexed or unstructured spreadsheet data may limit trend detection.

Related Skills

Explore More Data & Analytics Skills→
jonnytacos8jonnytacos8

document-qa

Answer questions about SharePoint-hosted documents with cited sources.

Community
Intermediate
pluginagentmarketplacepluginagentmarketplace
3

red-team-reporting

Generate security assessment reports from structured findings in Markdown, HTML, PDF, or DOCX.

Community
Basic
zephyrwang6zephyrwang6
333

xlsx

Create, edit, and analyze spreadsheets in .xlsx, .xlsm, and CSV formats.

Community
Advanced
saeed-vayghansaeed-vayghan
30

data-analyst

Analyzes raw data using SQL, Python, and BI tools for actionable insights and dashboard development.

Community
Advanced