synthdata-extract
CommunityExtract Excel sheets to JSON for analytics.
Authorrappdw
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Extracting structured data from Excel workbooks is error-prone and manual, hindering data analysis workflows. This skill converts each sheet into a JSON array of objects, enabling consistent downstream processing.
Core Features & Use Cases
- Per-sheet JSON exports: Each worksheet becomes a separate JSON file (or a bundled single JSON file containing all sheets) with records keyed by header names.
- Header detection flexibility: Detects a title/banner row or uses headers directly to adapt to different spreadsheet layouts.
- Real-world use case: Prepare Excel exports for analytics pipelines by converting monthly sales, inventory, or survey data into JSON for ingestion.
Quick Start
Run the extract script on your Excel workbook to generate per-sheet JSON files in the output directory.
Dependency Matrix
Required Modules
openpyxl
Components
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: synthdata-extract Download link: https://github.com/rappdw/synthdata/archive/main.zip#synthdata-extract Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.