PHPackages                             sinri/excelxsql - 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. sinri/excelxsql

ActiveLibrary

sinri/excelxsql
===============

turn excel to db and query with sql

01PHP

Since Oct 27Pushed 8y ago1 watchersCompare

[ Source](https://github.com/sinri/ExcelxSQL)[ Packagist](https://packagist.org/packages/sinri/excelxsql)[ RSS](/packages/sinri-excelxsql/feed)WikiDiscussions master Synced 3d ago

READMEChangelogDependenciesVersions (1)Used By (0)

Excel×SQL
=========

[](#excelsql)

This project is design to make possible that use Excel Sheets as database tables and run SQL query on them. For those are familiar with database and SQL but not expert for Excel, it might help.

How this works?
---------------

[](#how-this-works)

Simple, read the excel and set up a database of SQLite3, then you can run query SQL, export result and more.

Usage
-----

[](#usage)

See `example`.

Note:

1. Prepare the source `.xlsx` files. Excel sheet cells are sometimes expressing strangely, especially on numeric values.
2. Prepare the sqlite3 database file. As default memory embedded database instance might be a waste of memory, you may determine a file.
3. Use a proper load method to load. For almost situations, `loadSheetWithTypeDefinition` works best.
4. You may need to output as xlsx file. Note currently only one sheet might be generated.

Donate
------

[](#donate)

You can donate through this alipay account.

[![http://www.everstray.com/resources/img/AlipayUkanokan258.png](https://camo.githubusercontent.com/03d5c15507c67f7623697c12b2ded1719e0e27f39a35e09fcc3f7f15b2aa32f2/687474703a2f2f7777772e6576657273747261792e636f6d2f7265736f75726365732f696d672f416c69706179556b616e6f6b616e3235382e706e67)](https://camo.githubusercontent.com/03d5c15507c67f7623697c12b2ded1719e0e27f39a35e09fcc3f7f15b2aa32f2/687474703a2f2f7777772e6576657273747261792e636f6d2f7265736f75726365732f696d672f416c69706179556b616e6f6b616e3235382e706e67)

###  Health Score

19

—

LowBetter than 10% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity1

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

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.

### Community

Maintainers

![](https://avatars.githubusercontent.com/u/5821330?v=4)[Everstray Jun Sinri Edogawa](/maintainers/sinri)[@sinri](https://github.com/sinri)

---

Top Contributors

[![sinri](https://avatars.githubusercontent.com/u/5821330?v=4)](https://github.com/sinri "sinri (12 commits)")

### Embed Badge

![Health badge](/badges/sinri-excelxsql/health.svg)

```
[![Health](https://phpackages.com/badges/sinri-excelxsql/health.svg)](https://phpackages.com/packages/sinri-excelxsql)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)