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

Ready to run

npx skills add https://github.com/takemi-ohama/ai-agent-marketplace --skill scanner-excel-extraction

💬 Prompt for ChatGPT / Claude Chat▼

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.