docs-xlsx

name	docs-xlsx
description	Parse Excel spreadsheets (.xlsx) into repository-friendly CSV and JSON artifacts. Use when users need to extract data, formulas, or structure from Excel files.

Excel Spreadsheet Parsing

Parse Excel spreadsheets (.xlsx) into CSV files, JSON metadata, and formula artifacts using multi-method extraction.

Usage

Run the parsing script directly:

./scripts/parse_xlsx.py <path_to_file.xlsx> <output_dir>

Example:

./scripts/parse_xlsx.py ~/data/workbook.xlsx ./parsed/

The script uses 4 extraction methods:

• pandas (basic) - CSV exports + schema
• pandas (detailed) - Data types + statistics
• openpyxl (structure) - Workbook structure JSON
• openpyxl (formulas) - Formula extraction

Output Structure

output_dir/
├── file.xlsx/
│   ├── parsing_summary.json
│   ├── pandas_basic/
│   │   ├── Sheet1.csv
│   │   ├── Sheet2.csv
│   │   └── metadata.json
│   ├── pandas_detailed/
│   │   ├── Sheet1.csv
│   │   ├── Sheet2.csv
│   │   ├── statistics.json
│   │   └── data_types.json
│   ├── openpyxl_structure/
│   │   └── workbook.json
│   └── openpyxl_formulas/
│       └── formulas.json

Script Features

• Exports each sheet as separate CSV file
• Captures data types and statistics
• Extracts formulas with cell references
• Handles multiple sheets per workbook
• Provides schema information for each sheet