skills.rest
takemi-ohama
takemi-ohamaCOMMUNITY
Explore all skills by this author →
GitHub

scanner-excel-extraction

Extract data from multi-sheet Excel workbooks into JSON or CSV.

1|Updated Nov 11, 2025
Search Tags:#Excel#JSON#formulas#chunking#CSV#sheets#data-extraction
One-click install
npx skills add https://github.com/takemi-ohama/ai-agent-marketplace --skill scanner-excel-extraction
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: scanner-excel-extraction
Source: https://github.com/takemi-ohama/ai-agent-marketplace/tree/main/plugins/ndf/skills/scanner-excel-extraction
Command: npx skills add https://github.com/takemi-ohama/ai-agent-marketplace --skill scanner-excel-extraction

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, xlrd, and includes scripts (resource) components.

What problem does it solve?

Excel data often comes in complex, multi-sheet workbooks. This Skill extracts data from multiple sheets, evaluates formulas, and outputs JSON or CSV, enabling easier downstream analysis.

Core Features & Use Cases

  • Multi-sheet reading and data structuring (JSON/CSV)
  • Formula evaluation to get computed values
  • Cell formatting extraction (basic formatting info)
  • Large file handling via chunking for memory efficiency

Quick Start

Example: python scripts/extract-excel.py data.xlsx --output=json

Frequently Asked Questions about scanner-excel-extraction

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

FAQPage Schema
How do I extract data from multi-sheet Excel workbooks?▼

Extract data from multi-sheet Excel files by using this Skill to read all sheets simultaneously, preserving sheet structure and outputting JSON or CSV. It handles complex workbooks automatically without manual sheet-by-sheet processing.

Can I extract computed values from Excel formulas?▼

Yes, this Skill evaluates formulas in Excel files and outputs their computed values rather than formula text. Enable formula evaluation to get calculated results directly in your JSON or CSV output.

How do I handle large Excel files without memory issues?▼

Large Excel files are processed efficiently through chunking, which breaks data into manageable segments. This prevents memory overload when working with formulas, formatting metadata, and multi-sheet extraction.

What formatting information can I extract from Excel cells?▼

Cell formatting extraction captures basic formatting metadata alongside data values. This Skill preserves formatting info in structured output, enabling downstream styling or conditional processing.

Does this work with Excel files containing formulas and formatting together?▼

Yes, this Skill extracts data from Excel files that combine formulas, cell formatting, and multi-sheet structures simultaneously. It evaluates formulas and preserves formatting metadata in a single pass.

What output formats does this Skill support?▼

JSON and CSV are both supported output formats. Choose the format that best suits your downstream analysis, with JSON preserving nested sheet structure and metadata.

Related Skills

Explore More Data & Analytics Skills→
MichaelYang-lyxMichaelYang-lyx
110

numeric-format-normalization

Normalize numeric columns in Excel workbooks and verify totals against a Summary sheet.

Community
Intermediate
aws-samplesaws-samples
90

file-processing

Process and analyze CSV, JSON, and text data files with automated cleaning and transformation.

Official
Advanced
iliagermaniliagerman
1

excel

Read, write, edit, and format Excel files using Python.

Community
Intermediate
OpenCoworkAIOpenCoworkAI
2.0k

xlsx

Create and edit Excel workbooks with formulas across .xlsx, .xlsm, .csv, and .tsv formats.

Official
Advanced