xlsx

Read local Excel workbooks to list sheets, extract rows as JSON, or dump text.

4|2|Updated Sep 1, 2026
One-click install
npx skills add https://github.com/Procesio-Externals/procesio-cli --skill xlsx-procesio-externals
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: xlsx
Source: https://github.com/Procesio-Externals/procesio-cli/tree/main/tools/xlsx
Command: npx skills add https://github.com/Procesio-Externals/procesio-cli --skill xlsx-procesio-externals

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve? Reading data out of local Excel (.xlsx/.xlsm) workbooks usually requires opening a spreadsheet application or writing ad-hoc parsing code. This Skill turns workbook inspection into a repeatable command-line operation that returns structured JSON or readable text, with no credentials or cloud services involved. ## Core Features & Use Cases - Sheet Listing: Enumerate every worksheet in a workbook with its row and column counts. - Structured Row Extraction: Read a single sheet as a JSON 2D array with empty rows skipped, trailing blank cells trimmed, and dates returned as ISO strings. - Full Workbook Dump: Convert an entire workbook into pipe-delimited readable text, either inline or saved to a file. - Use Case: Download an .xlsx report from Google Drive, then run the dump action to get the full contents as text you can search, diff, or feed into another pipeline. ## Quick Start Ask the assistant to read the sheet named Data from the local file report.xlsx and return the rows as JSON.

Frequently Asked Questions about xlsx

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

FAQPage Schema
How do I read an Excel file as JSON from the command line?▼

Run the read-sheet action with the workbook path and optionally a sheet name. It returns a JSON object containing the sheet name, a 2D array of rows, and a truncated flag, with empty rows skipped and trailing blank cells trimmed.

How to list all sheets in an xlsx file with Python?▼

Use the list-sheets action with the workbook path. It loads the file with openpyxl and returns every worksheet's title along with its row and column counts as a JSON array.

Does this tool support .xls or only .xlsx files?▼

Only .xlsx and .xlsm files are supported because parsing relies on openpyxl. Passing any other extension raises an invalid argument error, so older .xls files must be converted first.

Can I read Google Sheets with this Excel reader?▼

Native Google Sheets are handled by the separate google-sheets tool. This reader is for .xlsx blobs, such as files downloaded from Drive, which you can then dump or read locally.

Why are dates returned as strings when reading Excel rows?▼

Date, time, and datetime cell values are converted to ISO format strings so the output stays JSON-safe. Numbers, booleans, and text pass through unchanged, and empty cells become empty strings.