PHPackages                             stl-horizon/stl-excel-import - 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. [File & Storage](/categories/file-storage)
4. /
5. stl-horizon/stl-excel-import

ActiveYii2-extension[File & Storage](/categories/file-storage)

stl-horizon/stl-excel-import
============================

Framework-agnostic CSV/XLSX/JSON import package for PHP

v1.0.0(3mo ago)07MITPHPPHP ^8.2

Since Mar 17Pushed 3mo agoCompare

[ Source](https://github.com/chriskelemba/stl-excel-import)[ Packagist](https://packagist.org/packages/stl-horizon/stl-excel-import)[ RSS](/packages/stl-horizon-stl-excel-import/feed)WikiDiscussions main Synced 3w ago

READMEChangelogDependencies (2)Versions (2)Used By (0)

Excel Import (Framework-Agnostic PHP)
=====================================

[](#excel-import-framework-agnostic-php)

Standalone CSV/XLSX/JSON/NDJSON preview + import engine for PHP.

This is the same core functionality as `excel-import-laravel`, extracted so it can run in:

- plain PHP projects
- Laravel (service/controller wrapper in app code)
- Yii (service/controller wrapper in app code)

Install
-------

[](#install)

```
composer require stl-horizon/excel-import
```

Optional:

```
composer require phpoffice/phpspreadsheet   # XLSX support
composer require mongodb/mongodb            # MongoDB support
```

Database Support
----------------

[](#database-support)

Supported through `PDO` adapters:

- MySQL / MariaDB (`pdo_mysql`)
- PostgreSQL (`pdo_pgsql`)
- SQLite (`pdo_sqlite`)
- SQL Server (`pdo_sqlsrv`)

Supported through Mongo adapter:

- MongoDB (`mongodb/mongodb` package)

Notes:

- Register one or many connections and switch by `connection` parameter in service calls.
- `insert` and `upsert` modes work across the supported SQL drivers and MongoDB.
- Column/type discovery is automatic for SQL tables.
- MongoDB is schema-less; columns are inferred from sampled documents unless overridden in config.

Quick Start (Plain PHP + PDO)
-----------------------------

[](#quick-start-plain-php--pdo)

```