PHPackages kraenzle-ritter/spreadsheet-inspect - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [CLI & Console](/categories/cli) 4. / 5. kraenzle-ritter/spreadsheet-inspect ActiveProject[CLI & Console](/categories/cli) kraenzle-ritter/spreadsheet-inspect =================================== CLI tool to inspect and analyze Excel/ODS spreadsheet files v1.0.0(4mo ago)00MITPHPPHP ^8.3CI passing Since Feb 16Pushed 4mo agoCompare [ Source](https://github.com/kraenzle-ritter/spreadsheet-inspect)[ Packagist](https://packagist.org/packages/kraenzle-ritter/spreadsheet-inspect)[ Docs](https://github.com/kraenzle-ritter/spreadsheet-inspect)[ RSS](/packages/kraenzle-ritter-spreadsheet-inspect/feed)WikiDiscussions main Synced today READMEChangelog (1)Dependencies (7)Versions (2)Used By (0) Spreadsheet Inspect =================== [](#spreadsheet-inspect) [![Tests](https://github.com/kraenzle-ritter/spreadsheet-inspect/actions/workflows/tests.yml/badge.svg)](https://github.com/kraenzle-ritter/spreadsheet-inspect/actions/workflows/tests.yml)[![License: MIT](https://camo.githubusercontent.com/fdf2982b9f5d7489dcf44570e714e3a15fce6253e0cc6b5aa61a075aac2ff71b/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d4d49542d79656c6c6f772e737667)](https://opensource.org/licenses/MIT)[![PHP Version](https://camo.githubusercontent.com/5905ad7daa620add8ed055a2fa609f36bd8f433119251b4b8d46c217ceddda53/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f7068702d762f6b7261656e7a6c652d7269747465722f73707265616473686565742d696e7370656374)](https://packagist.org/packages/kraenzle-ritter/spreadsheet-inspect)[![Downloads](https://camo.githubusercontent.com/d91976c06b69f010044b27adbee88ea034821922eccf86b3ca803027e8931e25/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f646f776e6c6f6164732f6b7261656e7a6c652d7269747465722f73707265616473686565742d696e73706563742f746f74616c)](https://github.com/kraenzle-ritter/spreadsheet-inspect/releases) A CLI tool to inspect Excel (.xlsx, .xls) and LibreOffice (.ods) spreadsheet files. Analyze sheet structures, column statistics, find cross-sheet references, and extract embedded images. Features -------- [](#features) - 📊 **Sheet Analysis** – List all sheets, view column headers, row counts, and fill rates - 📈 **Value Statistics** – See distinct values per column with occurrence counts - 🔗 **Cross-Sheet Reference Check** – Find where values from one sheet appear in others - 🖼️ **Image Inspection** – Count and extract embedded images/drawings - 📁 **Multiple Formats** – Supports Excel (.xlsx, .xls) and LibreOffice Calc (.ods) Installation ------------ [](#installation) ### Download PHAR (recommended) [](#download-phar-recommended) Download the latest release: ``` curl -L https://github.com/kraenzle-ritter/spreadsheet-inspect/releases/latest/download/spreadsheet-inspect -o spreadsheet-inspect chmod +x spreadsheet-inspect ``` Optionally move to your PATH: ``` sudo mv spreadsheet-inspect /usr/local/bin/ ``` ### From Source [](#from-source) ``` git clone https://github.com/kraenzle-ritter/spreadsheet-inspect.git cd spreadsheet-inspect composer install ``` Usage ----- [](#usage) > **Note:** Replace `php inspect` with `spreadsheet-inspect` if using the PHAR. ### List all sheets [](#list-all-sheets) ``` php inspect spreadsheet myfile.xlsx --sheets ``` ### Analyze a specific sheet [](#analyze-a-specific-sheet) ``` php inspect spreadsheet myfile.xlsx --sheet=1 # or by name php inspect spreadsheet myfile.xlsx --sheet="Sheet Name" ``` **Output:** ``` ## Available sheets - **[1]** `Products` - **[2]** `Categories` # Sheet `Products` (Index: 1) ## Sheet statistics - **Rows** (excluding header): `150` ### `ProductID` - **Filled**: `150 / 150` (100%) - **Distinct**: `150` ### `Category` - **Filled**: `148 / 150` (98.67%) - **Distinct**: `12` Values: - `Electronics` (45) - `Clothing` (32) ... ``` ### Analyze images in a sheet [](#analyze-images-in-a-sheet) ``` php inspect spreadsheet myfile.xlsx --sheet=1 --images ``` ### Extract images to a directory [](#extract-images-to-a-directory) ``` php inspect spreadsheet myfile.xlsx --sheet=1 --extract-images=./images ``` ### Cross-sheet reference check [](#cross-sheet-reference-check) Find where values from a column appear in other sheets: ``` php inspect spreadsheet myfile.xlsx --sheet=1 --column=ProductID ``` Check against a specific target sheet: ``` php inspect spreadsheet myfile.xlsx --sheet=1 --column=ProductID --cross-sheet=2 ``` Compare only against a specific column in target sheets: ``` php inspect spreadsheet myfile.xlsx --sheet=1 --column=ProductID --target-column=ID ``` ### Options [](#options) OptionDescription`--sheets`List all sheet names only`--sheet=`Inspect a specific sheet (by index or name)`--column=`Cross-search for values from this column`--cross-sheet=`Only check this target sheet`--target-column=`Only compare against this column in target sheets`--images`Count and list images in the sheet`--extract-images=`Extract images to specified directory`--output=`Output format: `console` (default), `html`, `pdf``--output-file=`Output file path (required for html/pdf)`--debug`Show detailed matching values`--memory=`Memory limit in MB (default: 2000)### Export to HTML or PDF [](#export-to-html-or-pdf) Generate a styled HTML report: ``` php inspect spreadsheet myfile.xlsx --sheet=1 --output=html --output-file=report.html ``` Generate a PDF report: ``` php inspect spreadsheet myfile.xlsx --sheet=1 --output=pdf --output-file=report.pdf ``` Supported Formats ----------------- [](#supported-formats) - Microsoft Excel: `.xlsx`, `.xls` - LibreOffice Calc: `.ods` Requirements ------------ [](#requirements) - PHP 8.3+ - Composer Testing ------- [](#testing) ``` ./vendor/bin/pest ``` Built With ---------- [](#built-with) - [Laravel Zero](https://laravel-zero.com/) – Micro-framework for console applications - [PhpSpreadsheet](https://phpspreadsheet.readthedocs.io/) – Library for reading/writing spreadsheet files - [FastExcel](https://github.com/rap2hpoutre/fast-excel) – Fast Excel import/export - [Dompdf](https://github.com/dompdf/dompdf) – HTML to PDF converter License ------- [](#license) MIT License. See [LICENSE](LICENSE) for details. ### Health Score 34 — LowBetter than 75% of packages Maintenance75 Regular maintenance activity Popularity0 Limited adoption so far Community6 Small or concentrated contributor base Maturity49 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Unknown Total 1 Last Release 138d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/76f31e7e6772db47a91388ed82840fae1fa57185bb82a64924bb3839697222c2?d=identicon)[ottosmops](/maintainers/ottosmops) --- Top Contributors [![ottosmops](https://avatars.githubusercontent.com/u/4144389?v=4)](https://github.com/ottosmops "ottosmops (16 commits)") --- Tags phpcliexcelxlsxspreadsheetodsinspectanalyze ### Code Quality TestsPest Code StyleLaravel Pint ### Embed Badge ![Health badge](/badges/kraenzle-ritter-spreadsheet-inspect/health.svg) ``` [![Health](https://phpackages.com/badges/kraenzle-ritter-spreadsheet-inspect/health.svg)](https://phpackages.com/packages/kraenzle-ritter-spreadsheet-inspect) ``` ### Alternatives [openspout/openspout PHP Library to read and write spreadsheet files (CSV, XLSX and ODS), in a fast and scalable way 1.2k70.2M245](/packages/openspout-openspout)[mehrancodes/laravel-harbor A CLI tool to Quickly create On-Demand preview environment for your apps. 10097.5k](/packages/mehrancodes-laravel-harbor)[helsingborg-stad/municipio A bootstrap theme for creating municipality sites. 4028.5k10](/packages/helsingborg-stad-municipio) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)