XLSX Processor

Extract and convert XLSX spreadsheet data into Markdown, CSV, or JSON.

Updated Sep 6, 2024
One-click install
npx skills add https://github.com/rafazsh/dotfiles --skill xlsx-processor-rafazsh
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: XLSX Processor
Source: https://github.com/rafazsh/dotfiles/tree/main/apps/claude/skills/xlsx-processor
Command: npx skills add https://github.com/rafazsh/dotfiles --skill xlsx-processor-rafazsh

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill removes the manual effort of opening, inspecting, and transforming Excel workbooks by providing reliable spreadsheet reading and conversion workflows.

Core Features & Use Cases

  • Spreadsheet Reading: Open XLSX files, inspect workbook structure, list sheets, and extract data from selected tabs or ranges.
  • Data Conversion: Transform spreadsheet contents into Markdown tables, CSV, or JSON formats for analysis and downstream processing.
  • Use Case: Analyze a multi-sheet business workbook by previewing available tabs, extracting relevant ranges, and converting the results into structured JSON for further automation.

Quick Start

Use the XLSX Processor skill to read the attached Excel file and extract its data into a Markdown table.

Frequently Asked Questions about XLSX Processor

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

FAQPage Schema
How do I extract data from an Excel workbook into JSON?

To extract data from a multi-sheet Excel workbook, this Skill parses XLSX files to inspect workbook structure and list available tabs. It reads selected sheets or specific ranges to extract and transform spreadsheet data into structured formats.

Can I convert specific XLSX ranges to CSV?

Yes, you can convert specific XLSX ranges to CSV. The Skill applies range extraction workflows to read targeted spreadsheet sections and transform the contents into CSV format for analysis and automation tasks.

Does this spreadsheet conversion tool require openpyxl?

Yes, this spreadsheet conversion tool requires openpyxl. It relies on openpyxl-based processing to handle workbook parsing, multi-sheet access, and structured output generation for XLSX reading and conversion.

What is the best way to inspect multi-sheet Excel files for data analysis?

The best way to inspect multi-sheet Excel files is using this Skill to open XLSX workbooks and preview available tabs. It extracts relevant ranges and converts the results into structured data like Markdown tables for analysis.

How do I turn spreadsheet data into a Markdown table?

To turn spreadsheet data into a Markdown table, this Skill reads the attached Excel file and transforms its contents. It extracts data from selected tabs or ranges to generate Markdown tables for immediate analysis.